Загрузка...
время обработки php (сек) 0,42223787307739
connect
SET NAMES CP1251
SELECT role_id
FROM acl_roles_users
WHERE user_id = 0
AND role_id in (4,11)
limit 0,1
SELECT DISTINCT uos.id AS uos_id, uos.name AS uos_name, uos.hfu AS uos_hfu, cm.name AS cm_name, cm.hfu AS cm_hfu
FROM uos_new uos
LEFT JOIN comm_rel_uos cru ON ( uos.id = cru.uos_id )
LEFT JOIN communitymain cm ON ( cm.id = cru.community_id )
LEFT JOIN communityusers cu ON ( cu.communitymain_id = cm.id ) , uosreluostype urt
WHERE urt.uostype_id =43
AND uos.id = urt.uos_id
SELECT *
FROM a04004_market.IP_TO_COUNTRY
WHERE IP_FROM = inet_aton( '212.2.159.34' )
LIMIT 1
SELECT `pubtype`.* FROM `pubtype` WHERE (types_id = '18') LIMIT 1
SELECT `pubgroups`.* FROM `pubgroups` WHERE (hfu = 'conception') LIMIT 1
SELECT `pg`.`id` AS `iid`, `pg`.`name`, `pg`.`hfu`, count(*) AS `count` FROM `pubgroups` AS `pg`
LEFT JOIN `pubarticles` AS `pa` ON pa.pubgroups_id = pg.id WHERE (pg.pubtype_id = '3') GROUP BY `pg`.`id`,
`pg`.`name` ORDER BY `count` desc
SELECT SQL_CALC_FOUND_ROWS
pa.id, pa.hfu, pa.name, pa.title, pa.photos_dir, pa.users_id, pa.types_id, pa.pubgroups_id, date_final, pa.flag_available,
u.user_hfu, u.user_first_name, u.user_last_name, u.username,
pg.name rubricname, pg.hfu rubrichfu,
t.name typesname, t.tghfu tghfu, t.typesglobal_id typesglobal_id,
pt.name as ptname, pt.descr as ptdescr,
uos.hfu as uos_hfu, uos.name as uos_name
FROM
pubarticles_view as pa
LEFT JOIN pubgroups AS pg ON ( pa.pubgroups_id = pg.id )
LEFT JOIN types_view AS t ON ( pa.types_id = t.id )
LEFT JOIN pubtype AS pt ON ( pa.pubtype_id = pt.id )
LEFT JOIN a04004_meta.users as u ON (pa.users_id = u.id)
LEFT JOIN uos_new as uos ON (pa.uos_id = uos.id)
WHERE
pa.pubtype_id = 3 AND pubgroups_id = 31 AND (pa.flag_available 0 OR pa.users_id = 0)
ORDER BY
pa.date_final desc
LIMIT 0,10
SELECT FOUND_ROWS()
SELECT DISTINCT uos.id AS uos_id, uos.name AS uos_name, uos.hfu AS uos_hfu, cm.name AS cm_name, cm.hfu AS cm_hfu
FROM uos_new uos
LEFT JOIN comm_rel_uos cru ON ( uos.id = cru.uos_id )
LEFT JOIN communitymain cm ON ( cm.id = cru.community_id )
LEFT JOIN communityusers cu ON ( cu.communitymain_id = cm.id ) , uosreluostype urt
WHERE urt.uostype_id =43
AND uos.id = urt.uos_id
SELECT
pa.name, pa.hfu, pa.id, pa.pubtype_id, pa.pubgroups_id, pa.date_pub, pa.date_final, pa.title, pa.body, pa.photos_dir, pa.types_id, pa.flag_available, pa.flag_noseo, pa.users_id, pa.alt_url, pa.uos_id, pa.type_template,
pg.name rubricname, pg.hfu rubrichfu,
t.name typesname, t.tghfu tghfu, t.typesglobal_id typesglobal_id, t.descr,
pt.name as ptname, pt.descr as ptdescr,
u.username, u.user_hfu, u.user_email,
uos.hfu as uos_hfu, uos.name as uos_name
FROM
pubarticles_view AS pa
LEFT JOIN pubgroups AS pg ON ( pa.pubgroups_id = pg.id )
LEFT JOIN types_view AS t ON ( pa.types_id = t.id )
LEFT JOIN pubtype AS pt ON ( pa.pubtype_id = pt.id )
LEFT JOIN a04004_meta.users as u ON (pa.users_id = u.id)
LEFT JOIN uos_new as uos ON (pa.uos_id = uos.id)
WHERE
pa.hfu = 'chuvstvo-stilya-v-odezhde-morgan'
ORDER BY
pa.date_final
SELECT `msgtopic`.* FROM `msgtopic` WHERE (types_id = 18) LIMIT 1
SELECT SQL_CALC_FOUND_ROWS
pa.id, pa.hfu, pa.name, pa.title, pa.photos_dir, pa.users_id, pa.types_id, pa.pubgroups_id, date_final, pa.flag_available,
u.user_hfu, u.user_first_name, u.user_last_name, u.username,
pg.name rubricname, pg.hfu rubrichfu,
t.name typesname, t.tghfu tghfu, t.typesglobal_id typesglobal_id,
pt.name as ptname, pt.descr as ptdescr,
uos.hfu as uos_hfu, uos.name as uos_name
FROM
pubarticles_view as pa
LEFT JOIN pubgroups AS pg ON ( pa.pubgroups_id = pg.id )
LEFT JOIN types_view AS t ON ( pa.types_id = t.id )
LEFT JOIN pubtype AS pt ON ( pa.pubtype_id = pt.id )
LEFT JOIN a04004_meta.users as u ON (pa.users_id = u.id)
LEFT JOIN uos_new as uos ON (pa.uos_id = uos.id)
WHERE
pa.uos_id = 788 AND pa.flag_available 0 AND pa.id 15683 AND pa.types_id 2
ORDER BY
pa.date_final desc
LIMIT 0,4
SELECT
uos.id uos_id, uos.name uos_name,
cm.id as cm_id, cm.name brand,
c.id, c.id c_id, c.name c_name, c.cid,
cc.name as cc_name,
cug.market_id market_id,
cug.f_price, cug.f_url, cug.goods_id, cug.f_discount,
ci.name imgname, ci.dir imgdir, ci.cache_dir,
ub.tarif,
m.redirect_partner_id, m2.partner_url, m.flag_partner, m.id mid, m.flag_show, m.url
FROM
a04001_new.uos_rel_market urm
LEFT JOIN a04001_new.uos_new uos ON ( urm.uos_id = uos.id )
LEFT JOIN a04004_market.catalog_users_goods cug ON ( urm.markets_id = cug.market_id AND cug.f_active = 1 )
LEFT JOIN a04004_market.markets m ON ( m.id = cug.market_id )
LEFT JOIN a04004_market.markets m2 ON m.redirect_partner_id = m2.id
LEFT JOIN a04004_market.users_balance ub ON ( ub.market_id = cug.market_id )
LEFT JOIN a04004_market.catalog c ON ( c.id = cug.goods_id )
LEFT JOIN a04004_market.catalog_category cc ON (cc.id = c.cid)
LEFT JOIN a04004_market.catalog_images ci ON ( ci.goods_id = cug.goods_id AND ci.ismain = 1 )
LEFT JOIN a04004_market.catalog_fields_values cfv ON ( cfv.goods_id = cug.goods_id AND cfv.field_id = 108 )
LEFT JOIN a04004_market.catalog_handbook_makes cm ON ( cfv.value_id = cm.id )
WHERE urm.uos_id = 788
AND cm.id is not null
AND ci.dir is not null
AND m.banned = 0 AND m.f_ignor = 0 AND ci.goods_id!=0 AND ci.ismain=1 AND cug.f_active=1 AND cug.is_approve!=1
AND cug.f_price is not null
AND cug.isboard = 0
AND cug.market_id NOT IN (102,138)
AND ub.summa > 0
AND m.flag_show 0
ORDER BY RAND()
LIMIT 12
SELECT
uos.id uos_id, uos.name uos_name,
cm.id as cm_id, cm.name brand,
c.id, c.id c_id, c.name c_name, c.cid,
cc.name as cc_name,
cug.market_id market_id,
cug.f_price, cug.f_url, cug.goods_id, cug.f_discount,
ci.name imgname, ci.dir imgdir, ci.cache_dir,
ub.tarif,
m.redirect_partner_id, m2.partner_url, m.flag_partner, m.id mid, m.flag_show, m.url
FROM
a04001_new.uos_new uos,
a04001_new.uos_rel_cat urc
LEFT JOIN a04004_market.catalog c ON ( c.cid = urc.category_id )
LEFT JOIN a04004_market.catalog_category cc ON (cc.id = c.cid)
LEFT JOIN a04004_market.catalog_users_goods cug ON ( c.id = cug.goods_id )
LEFT JOIN a04004_market.markets m ON ( m.id = cug.market_id )
LEFT JOIN a04004_market.markets m2 ON m.redirect_partner_id = m2.id
LEFT JOIN a04004_market.users_balance ub ON ( m.id = ub.market_id )
LEFT JOIN a04004_market.catalog_fields_values cfv ON ( cfv.goods_id = cug.goods_id AND cfv.field_id = 108 )
LEFT JOIN a04004_market.catalog_handbook_makes cm ON ( cfv.value_id = cm.id )
LEFT JOIN a04004_market.catalog_images ci ON ( ci.goods_id = cug.goods_id AND ci.ismain = 1 )
WHERE
uos.id = 788
AND
uos.id = urc.uos_id
AND m.banned = 0 AND m.f_ignor = 0 AND ci.goods_id!=0 AND ci.ismain=1 AND cug.f_active=1 AND cug.is_approve!=1
AND cug.isboard = 0
AND cug.is_approve > 1
AND cug.f_show = 1
AND m.f_ignor = 0
AND m.banned = 0
AND m.id NOT IN (102,138)
AND ub.summa+ub.bonus > 0
AND
cm.id is not null
AND m.flag_show 0
ORDER BY RAND()
LIMIT 12
SELECT `photos`.* FROM `photos` WHERE (types_id = '18') AND (resource_id = '15683')
SELECT
mp.*, mtr.users_id as subscribe
FROM
msgpost as mp
left join msgtrack as mtr on (mtr.users_id = 0 and mtr.msgpost_id = mp.id)
WHERE
mp.resource_id = 15683 and mp.msgtopic_id = 13
SELECT `msg_text`.* FROM `msg_text` WHERE (msgpost_id = '43790') ORDER BY `msg_date` ASC
SELECT `msg_text`.* FROM `msg_text` WHERE (msgpost_id = '43790') AND (parent_id = 0) LIMIT 1
SELECT `mtxt`.*, `mp`.`name` AS `postName`, `mt`.`id` AS `topicId`, `u`.`user_first_name` AS `authorName` FROM `msg_text` AS `mtxt`
LEFT JOIN `msgpost` AS `mp` ON mp.id=mtxt.msgpost_id
LEFT JOIN `msgtopic` AS `mt` ON mt.id=mp.msgtopic_id
LEFT JOIN `a04004_meta`.`users` AS `u` ON u.id=mtxt.users_id WHERE (mtxt.msgpost_id = '43790') ORDER BY `mtxt`.`owner_id` desc, `mtxt`.`level` ASC, `mtxt`.`msg_date` ASC
SELECT role_id
FROM acl_roles_users
WHERE user_id = 0
SELECT *
FROM pages_head
WHERE url = '/articles/conception/chuvstvo-stilya-v-odezhde-morgan'
Executed 23 queries in 0,27733683586121 seconds
Average query length: 0,012058123298313 seconds
Queries per second: 82,931644938469
Longest query length: 0,26614499092102
Longest query:
SELECT *
FROM a04004_market.IP_TO_COUNTRY
WHERE IP_FROM = inet_aton( '212.2.159.34' )
LIMIT 1
