time: 0.000159 query: SELECT * FROM salt params:

time: 0.000055 query: SELECT * FROM salt params:

time: 0.000274 query: SELECT * FROM city WHERE (url = 'магнитогорск') params:

time: 0.000032 query: SELECT * FROM groups WHERE (url = 'служба-скорой-помощи-и-пожарной-охраны') params:

time: 0.000082 query: SELECT * FROM city WHERE (id = '8913') params:

time: 0.000033 query: SELECT * FROM groups WHERE (id = '6') params:

time: 0.000030 query: SELECT * FROM canonical_groups WHERE (groups_id = '6') params:

time: 0.000233 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 6, 8913

time: 0.000243 query: SELECT * FROM firm WHERE (street_url = 'уральская') LIMIT 1 params:

time: 0.000299 query: SELECT * FROM firm WHERE (district_url = 'ленинский-район') LIMIT 1 params:

time: 0.000550 query: SELECT COUNT(*) FROM firm_contacts LEFT JOIN firm ON firm_contacts.firm_id = firm.id WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) params: 1651966, 1651967, 1651968, 1651969, 1651974, 1651975, 1651976, 1651977, 1651978, 1651981, 1651982, 2596567, 2603065, 2617824, 2625836, 2625844, 2626998, уральская, ленинский-район

time: 0.000440 query: SELECT COUNT(DISTINCT user) FROM comment LEFT JOIN firm ON comment.firm_id = firm.id WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) params: 1651966, 1651967, 1651968, 1651969, 1651974, 1651975, 1651976, 1651977, 1651978, 1651981, 1651982, 2596567, 2603065, 2617824, 2625836, 2625844, 2626998, уральская, ленинский-район

time: 0.000396 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) params: 1651966, 1651967, 1651968, 1651969, 1651974, 1651975, 1651976, 1651977, 1651978, 1651981, 1651982, 2596567, 2603065, 2617824, 2625836, 2625844, 2626998, уральская, ленинский-район

time: 0.000288 query: SELECT firm.street_url,firm.street FROM firm_group LEFT JOIN firm ON firm_group.firm_id = firm.id WHERE (firm_group.groups_id = ? AND firm_group.city_id = ?) GROUP BY firm.street_url params: 6, 8913

time: 0.000283 query: SELECT firm.district_url,firm.district FROM firm_group LEFT JOIN firm ON firm_group.firm_id = firm.id WHERE (firm_group.groups_id = ? AND firm_group.city_id = ?) GROUP BY firm.district_url params: 6, 8913

time: 0.000466 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) ORDER BY random LIMIT 25 params: 1651966, 1651967, 1651968, 1651969, 1651974, 1651975, 1651976, 1651977, 1651978, 1651981, 1651982, 2596567, 2603065, 2617824, 2625836, 2625844, 2626998, уральская, ленинский-район

time: 0.000263 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1651976') params:

time: 0.000177 query: SELECT * FROM comment WHERE (comment.firm_id IN (1651976, 2603065)) params:

time: 0.000161 query: SELECT * FROM firm_contacts WHERE (firm_id = '1651976') params:

time: 0.000147 query: SELECT * FROM city WHERE (city.id IN (8913)) params:

time: 0.000159 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2603065') params:

time: 0.000140 query: SELECT * FROM firm_contacts WHERE (firm_id = '2603065') params:

time: 0.000198 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 6, 8913

time: 0.000393 query: SELECT DISTINCT firm_group.firm_id AS id,firm.name,firm.url,firm.subtitle,firm.city_id,firm.address FROM firm_group LEFT JOIN firm ON firm_group.firm_id = firm.id WHERE (firm_group.groups_id = ? AND firm_group.city_id = ?) ORDER BY id DESC LIMIT 3 params: 6, 8913

time: 0.000079 query: SELECT * FROM city WHERE (city.id IN (8913)) params:

time: 0.000103 query: SELECT * FROM city WHERE (id = '8913') params:

time: 0.000091 query: SELECT * FROM city WHERE (id = '8913') params:

time: 0.000076 query: SELECT * FROM city WHERE (url = 'магнитогорск') params:

time: 0.000094 query: SELECT * FROM city WHERE (id = '8913') params: