Главная → Северодвинск → Администрации поселений

time: 0.000466 query: SELECT * FROM salt params:

time: 0.000275 query: SELECT * FROM salt params:

time: 0.000354 query: SELECT * FROM city WHERE (url = 'северодвинск') params:

time: 0.000893 query: SELECT * FROM groups WHERE (url = 'администрации-поселений-городов-и-городских-округов-области-и-края') params:

time: 0.000269 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000299 query: SELECT * FROM groups WHERE (id = '98') params:

time: 0.000212 query: SELECT * FROM canonical_groups WHERE (groups_id = '98') params:

time: 0.001022 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 98, 10061

time: 0.003214 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1283081, 1283084, 1283089, 1283090, 1283092, 1283093, 1283098, 1283100, 1283101, 1283103, 1283104, 1283106, 1283107, 1283108, 1283110, 1283111, 1283112, 1283113, 1283114, 1283115, 2158160, 2167440, 2167456, 2167458, 2167461, 2167464, 2167466, 2167470, 2167473, 2169845, 2174695, 2174697, 2174698, 2175278, 2175281, 2175282, 2175284, 2175287, 2175288, 2175290, 2175292, 2175294, 2175296, 2175298, 2175300, 2175302, 2175304, 2175305, 2175307, 2175308, 2175309, 2175311, 2175312, 2175314, 2175316, 2175317, 2175321, 2176265, 2178429, 2178430, 2178431, 2178433, 2178434, 2178435, 2178436, 2178437, 2178447, 2178449, 2178450, 2178451, 2178452, 2178453, 2178454, 2178455, 2178456, 2178458

time: 0.001720 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1283081, 1283084, 1283089, 1283090, 1283092, 1283093, 1283098, 1283100, 1283101, 1283103, 1283104, 1283106, 1283107, 1283108, 1283110, 1283111, 1283112, 1283113, 1283114, 1283115, 2158160, 2167440, 2167456, 2167458, 2167461, 2167464, 2167466, 2167470, 2167473, 2169845, 2174695, 2174697, 2174698, 2175278, 2175281, 2175282, 2175284, 2175287, 2175288, 2175290, 2175292, 2175294, 2175296, 2175298, 2175300, 2175302, 2175304, 2175305, 2175307, 2175308, 2175309, 2175311, 2175312, 2175314, 2175316, 2175317, 2175321, 2176265, 2178429, 2178430, 2178431, 2178433, 2178434, 2178435, 2178436, 2178437, 2178447, 2178449, 2178450, 2178451, 2178452, 2178453, 2178454, 2178455, 2178456, 2178458

time: 0.001451 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1283081, 1283084, 1283089, 1283090, 1283092, 1283093, 1283098, 1283100, 1283101, 1283103, 1283104, 1283106, 1283107, 1283108, 1283110, 1283111, 1283112, 1283113, 1283114, 1283115, 2158160, 2167440, 2167456, 2167458, 2167461, 2167464, 2167466, 2167470, 2167473, 2169845, 2174695, 2174697, 2174698, 2175278, 2175281, 2175282, 2175284, 2175287, 2175288, 2175290, 2175292, 2175294, 2175296, 2175298, 2175300, 2175302, 2175304, 2175305, 2175307, 2175308, 2175309, 2175311, 2175312, 2175314, 2175316, 2175317, 2175321, 2176265, 2178429, 2178430, 2178431, 2178433, 2178434, 2178435, 2178436, 2178437, 2178447, 2178449, 2178450, 2178451, 2178452, 2178453, 2178454, 2178455, 2178456, 2178458

time: 0.002071 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: 98, 10061

time: 0.001834 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: 98, 10061

time: 0.002622 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) ORDER BY random LIMIT 25 params: 1283081, 1283084, 1283089, 1283090, 1283092, 1283093, 1283098, 1283100, 1283101, 1283103, 1283104, 1283106, 1283107, 1283108, 1283110, 1283111, 1283112, 1283113, 1283114, 1283115, 2158160, 2167440, 2167456, 2167458, 2167461, 2167464, 2167466, 2167470, 2167473, 2169845, 2174695, 2174697, 2174698, 2175278, 2175281, 2175282, 2175284, 2175287, 2175288, 2175290, 2175292, 2175294, 2175296, 2175298, 2175300, 2175302, 2175304, 2175305, 2175307, 2175308, 2175309, 2175311, 2175312, 2175314, 2175316, 2175317, 2175321, 2176265, 2178429, 2178430, 2178431, 2178433, 2178434, 2178435, 2178436, 2178437, 2178447, 2178449, 2178450, 2178451, 2178452, 2178453, 2178454, 2178455, 2178456, 2178458

time: 0.000223 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178456') params:

time: 0.000219 query: SELECT * FROM comment WHERE (comment.firm_id IN (2178456, 2178433, 2176265, 2178452, 2178430, 2175302, 2174695, 2175290, 1283115, 2175288, 1283090, 1283111, 2175305, 2178431, 2175308, 1283084, 1283114, 2178449, 2178453, 2175311, 2167458, 2158160, 1283113, 2178435, 1283101)) params:

time: 0.000126 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178456') params:

time: 0.000046 query: SELECT * FROM city WHERE (city.id IN (10061)) params:

time: 0.000114 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178433') params:

time: 0.000113 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178433') params:

time: 0.000111 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2176265') params:

time: 0.000113 query: SELECT * FROM firm_contacts WHERE (firm_id = '2176265') params:

time: 0.000109 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178452') params:

time: 0.000112 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178452') params:

time: 0.000111 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178430') params:

time: 0.000114 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178430') params:

time: 0.000102 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2175302') params:

time: 0.000113 query: SELECT * FROM firm_contacts WHERE (firm_id = '2175302') params:

time: 0.000106 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2174695') params:

time: 0.000107 query: SELECT * FROM firm_contacts WHERE (firm_id = '2174695') params:

time: 0.000100 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2175290') params:

time: 0.000106 query: SELECT * FROM firm_contacts WHERE (firm_id = '2175290') params:

time: 0.000121 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283115') params:

time: 0.000106 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283115') params:

time: 0.000101 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2175288') params:

time: 0.000111 query: SELECT * FROM firm_contacts WHERE (firm_id = '2175288') params:

time: 0.000115 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283090') params:

time: 0.000110 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283090') params:

time: 0.000107 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283111') params:

time: 0.000113 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283111') params:

time: 0.000102 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2175305') params:

time: 0.000108 query: SELECT * FROM firm_contacts WHERE (firm_id = '2175305') params:

time: 0.000111 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178431') params:

time: 0.000120 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178431') params:

time: 0.000126 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2175308') params:

time: 0.000119 query: SELECT * FROM firm_contacts WHERE (firm_id = '2175308') params:

time: 0.000107 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283084') params:

time: 0.000118 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283084') params:

time: 0.000099 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283114') params:

time: 0.000108 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283114') params:

time: 0.000101 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178449') params:

time: 0.000111 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178449') params:

time: 0.000104 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178453') params:

time: 0.000105 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178453') params:

time: 0.000098 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2175311') params:

time: 0.000108 query: SELECT * FROM firm_contacts WHERE (firm_id = '2175311') params:

time: 0.000100 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2167458') params:

time: 0.000104 query: SELECT * FROM firm_contacts WHERE (firm_id = '2167458') params:

time: 0.000102 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2158160') params:

time: 0.000117 query: SELECT * FROM firm_contacts WHERE (firm_id = '2158160') params:

time: 0.000101 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283113') params:

time: 0.000110 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283113') params:

time: 0.000106 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2178435') params:

time: 0.000110 query: SELECT * FROM firm_contacts WHERE (firm_id = '2178435') params:

time: 0.000103 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1283101') params:

time: 0.000099 query: SELECT * FROM firm_contacts WHERE (firm_id = '1283101') params:

time: 0.000172 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 98, 10061

time: 0.000623 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: 98, 10061

time: 0.000045 query: SELECT * FROM city WHERE (city.id IN (10061)) params:

time: 0.000060 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000049 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000047 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000045 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000043 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000041 query: SELECT * FROM city WHERE (id = '10061') params:

time: 0.000042 query: SELECT * FROM city WHERE (id = '10061') params: