starting pubchem
INFO:root:Creating admin ZINC application
INFO:root:ZINC admin application loaded
INFO:root:SELECT concat(:param_1, CAST(substance.sub_id AS VARCHAR)) AS short_zinc_id, mol_to_smiles(substance.smiles) AS smiles 
FROM substance 
WHERE substance.sub_id >= :sub_id_1 AND substance.sub_id <= :sub_id_2 AND substance.purchasable > :purchasable_1 ORDER BY substance.sub_id
INFO:root:Creating admin ZINC application
INFO:root:ZINC admin application loaded
INFO:root:SELECT concat(:param_1, CAST(substance.sub_id AS VARCHAR)) AS short_zinc_id, mol_to_smiles(substance.smiles) AS smiles 
FROM substance 
WHERE substance.sub_id >= :sub_id_1 AND substance.sub_id <= :sub_id_2 AND substance.purchasable > :purchasable_1 ORDER BY substance.sub_id
INFO:root:Creating admin ZINC application
INFO:root:ZINC admin application loaded
INFO:root:SELECT concat(:param_1, CAST(substance.sub_id AS VARCHAR)) AS short_zinc_id, mol_to_smiles(substance.smiles) AS smiles 
FROM substance 
WHERE substance.sub_id >= :sub_id_1 AND substance.sub_id <= :sub_id_2 AND substance.purchasable > :purchasable_1 ORDER BY substance.sub_id
INFO:root:Creating admin ZINC application
INFO:root:ZINC admin application loaded
INFO:root:SELECT concat(:param_1, CAST(substance.sub_id AS VARCHAR)) AS short_zinc_id, mol_to_smiles(substance.smiles) AS smiles 
FROM substance 
WHERE substance.sub_id >= :sub_id_1 AND substance.sub_id <= :sub_id_2 AND substance.purchasable > :purchasable_1 ORDER BY substance.sub_id
INFO:root:Creating admin ZINC application
INFO:root:ZINC admin application loaded
INFO:root:SELECT concat(:param_1, CAST(substance.sub_id AS VARCHAR)) AS short_zinc_id, mol_to_smiles(substance.smiles) AS smiles 
FROM substance 
WHERE substance.sub_id >= :sub_id_1 AND substance.sub_id <= :sub_id_2 AND substance.purchasable > :purchasable_1 ORDER BY substance.sub_id
INFO:root:Creating admin ZINC application
INFO:root:ZINC admin application loaded
INFO:root:SELECT concat(:param_1, CAST(substance.sub_id AS VARCHAR)) AS short_zinc_id, mol_to_smiles(substance.smiles) AS smiles 
FROM substance 
WHERE substance.sub_id >= :sub_id_1 AND substance.sub_id <= :sub_id_2 AND substance.purchasable > :purchasable_1 ORDER BY substance.sub_id