Database connection
SET `time_zone` = '+03:00'
SELECT * FROM cms_events WHERE `is_enabled` = 1 ORDER BY ordering ASC
SELECT i.id as `id`, i.is_enabled as `is_enabled`, i.options as `options`, i.name as `name`, i.slug as `slug`
FROM cms_controllers i
LIMIT 1000
UPDATE cms_users i SET `device` = 'desktop' WHERE (i.id = '0')
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (i.group_id IN ('1'))
LIMIT 1000
SELECT i.*
FROM cms_content_types i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
LIMIT 1000
SELECT i.*
FROM cms_awards_medals i
LIMIT 1000
SELECT i.*
FROM cms_awards_ranks i
SELECT i.*
FROM cms_widgets_pages i
LIMIT 1000
SELECT i.*, IF(t.id IS NULL AND i.is_approved < 1, 1, NULL) as `is_draft`, t.is_new_item, f.title as `folder_title`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.date_log as `user_date_log`, u.is_deleted as `user_is_deleted`, u.groups as `user_groups`, u.avatar as `user_avatar`, u.privacy_options as `user_privacy_options`
FROM cms_con_market i
LEFT JOIN cms_moderators_tasks as t ON t.item_id = i.id AND t.ctype_name = 'market'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.slug = '756-atomic-heart-gold-edition')
LIMIT 1
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'market')
LIMIT 1000
SELECT i.*, c.title as `child_title`, c.labels as `child_labels`, c.name as `child_ctype_name`
FROM cms_content_relations i
LEFT JOIN cms_content_types as c ON c.id = i.child_ctype_id AND i.target_controller = 'content'
WHERE (i.ctype_id = '13')
ORDER BY i.ordering asc
SELECT i.*, i.values as `default`
FROM cms_con_market_fields i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '690569532628')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '692363625706')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '705688201648')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '706721944727')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '690569532628') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '690569532628')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '690569532628')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '692363625706') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '692363625706')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '692363625706')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '705688201648') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '705688201648')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '705688201648')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '706721944727') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '706721944727')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '706721944727')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_digital') AND (i.type = 'fourth')
LIMIT 1
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_digital') AND (i.type = 'second')
LIMIT 1
SELECT i.*
FROM cms_typograph_presets i
WHERE (i.id = '1')
LIMIT 1
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_pod')
ORDER BY i.id asc
LIMIT 1000
SELECT i.id as `id`
FROM cms_users i
WHERE (i.is_admin = '1')
LIMIT 1000
SELECT i.*
FROM cms_users i
WHERE (i.id IN ('3037','4943','5916','5813','4056','3707','2658','369','1043','6145','4048','4045','4314','5547','2285','807','2137','985','863','3817','152','5981','1302','1124','679','2461','2776','2245','3722','2651','4685','3110','196','4320','3951','5183','3780','2423','1764','5896','4756','7','3748','2192','5345','1700','3292','1446','3693','240','1768','281','169','3777','1270','2384','5694','69','448','488','1951','4844','1712','4778','2920','4651','3160','541','4331','1029','2449','1582','326','864','800','5959','611','4349','4481','2298','1991','3309','5016','5018','1492','2486','1435','895','5032','2520','1048','3326','1098','4322','2735','5843','751','793','5499','3106','4067','4576','2990','2367','2732','1642','3116','1120','764','3973','4810','1848','1548','4312','5182','2969','3949','4865','5371','1160','3369','4137','4355','1253','1964','4835','4738','2304','687','1195','1811','2252','5308','4202','4831','5420','5402','20','3926','2483','5247','5517','4752','5370','4875','2680','3402','4388','2642','2823','1144','421','2406','5295','1359','5225','2868','4577','934','5317','5007','5344','5324','1374','1388','4480','5292','4714','787','4260','5280','4468','5290','676','1012','4734','4840','3379','1523','3394','4666','5128','2431','4558','4309','356','1719','4525','1551','1630','3802','1431','3806','655','1983','64','1894','3120','2599','1559','3754','908','1114','21','3901','4703','2464','1049','4679','4895','739','2621','651','115','4217','1946','5275','2191','2886','1214','3999','3868','3702','4677','2139','1816','1398','5171','4773','533','157','3494','742','708','2928','4954','4296','4251','1434','258','1470','2035','3043','3176','4097','1459','614','996','1178','734','5142','1010','4829','3258','521','2441','713','2121','81','3339','1643','3024','2051','3324','682','4277','1040','1018','2073','5237','1458','4823','1508','2569','1208','4713','2122','327','407','5031','4580','906','3265','1590','625','2168','1189','5224','2438','4221','527','1265','4254','756','2416','1829','571','1325','3718','665','2560','558','3742','4419','3542','1675','1817','5180','4426','1151','5','3403','1499','460','1382','3975','146','3938','2818','4992','2503','479','557','4451'))
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '3037')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4943')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5916')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5813')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4056')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '3707')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '2658')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '369')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1043')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '6145')
LIMIT 1000
SELECT i.*
FROM cms_con_market i
WHERE (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1') AND (i.is_deleted IS NULL) AND ((i.date_pub < '2023-07-28 12:55:00') OR ((i.date_pub = '2023-07-28 12:55:00') AND (i.id < '756') ) )
ORDER BY i.date_pub desc, i.id desc
LIMIT 1
SELECT i.*
FROM cms_con_market i
WHERE (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1') AND (i.is_deleted IS NULL) AND ((i.date_pub > '2023-07-28 12:55:00') OR ((i.date_pub = '2023-07-28 12:55:00') AND (i.id > '756') ) )
ORDER BY i.date_pub asc, i.id asc
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.user_hash = '93b3c6b900')
LIMIT 1
SELECT i.*
FROM cms_cart_orders i
WHERE (i.user_hash = '93b3c6b900')
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.order_id IS NULL) AND (i.user_hash = '93b3c6b900')
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '690569532628')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '692363625706')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '705688201648')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '706721944727')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '690569532628') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '690569532628')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '690569532628')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '692363625706') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '692363625706')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '692363625706')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '705688201648') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '705688201648')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '705688201648')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '706721944727') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '706721944727')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '706721944727')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_digital') AND (i.type = 'fourth')
LIMIT 1
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_digital') AND (i.type = 'second')
LIMIT 1
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '756') AND (i.fname = 'tabl_pod')
ORDER BY i.id asc
LIMIT 1000
SELECT i.id as `id`
FROM cms_users i
WHERE (i.is_admin = '1')
LIMIT 1000
SELECT i.*
FROM cms_users i
WHERE (i.id IN ('3037','4943','5916','5813','4056','3707','2658','369','1043','6145','4048','4045','4314','5547','2285','807','2137','985','863','3817','152','5981','1302','1124','679','2461','2776','2245','3722','2651','4685','3110','196','4320','3951','5183','3780','2423','1764','5896','4756','7','3748','2192','5345','1700','3292','1446','3693','240','1768','281','169','3777','1270','2384','5694','69','448','488','1951','4844','1712','4778','2920','4651','3160','541','4331','1029','2449','1582','326','864','800','5959','611','4349','4481','2298','1991','3309','5016','5018','1492','2486','1435','895','5032','2520','1048','3326','1098','4322','2735','5843','751','793','5499','3106','4067','4576','2990','2367','2732','1642','3116','1120','764','3973','4810','1848','1548','4312','5182','2969','3949','4865','5371','1160','3369','4137','4355','1253','1964','4835','4738','2304','687','1195','1811','2252','5308','4202','4831','5420','5402','20','3926','2483','5247','5517','4752','5370','4875','2680','3402','4388','2642','2823','1144','421','2406','5295','1359','5225','2868','4577','934','5317','5007','5344','5324','1374','1388','4480','5292','4714','787','4260','5280','4468','5290','676','1012','4734','4840','3379','1523','3394','4666','5128','2431','4558','4309','356','1719','4525','1551','1630','3802','1431','3806','655','1983','64','1894','3120','2599','1559','3754','908','1114','21','3901','4703','2464','1049','4679','4895','739','2621','651','115','4217','1946','5275','2191','2886','1214','3999','3868','3702','4677','2139','1816','1398','5171','4773','533','157','3494','742','708','2928','4954','4296','4251','1434','258','1470','2035','3043','3176','4097','1459','614','996','1178','734','5142','1010','4829','3258','521','2441','713','2121','81','3339','1643','3024','2051','3324','682','4277','1040','1018','2073','5237','1458','4823','1508','2569','1208','4713','2122','327','407','5031','4580','906','3265','1590','625','2168','1189','5224','2438','4221','527','1265','4254','756','2416','1829','571','1325','3718','665','2560','558','3742','4419','3542','1675','1817','5180','4426','1151','5','3403','1499','460','1382','3975','146','3938','2818','4992','2503','479','557','4451'))
LIMIT 1000
SELECT i.*
FROM cms_imini_attaches i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'market') AND (i.target_id = '756')
ORDER BY i.target_controller asc, i.target_subject asc, i.target_id asc, i.target_field asc
LIMIT 1000
SELECT i.*
FROM cms_billing_paid_fields i
WHERE (i.ctype_id = '13')
LIMIT 1000
SELECT i.*
FROM cms_con_market_cats i
WHERE (i.id = '1')
LIMIT 1
SELECT i.*
FROM cms_con_market_cats i
WHERE (i.ns_left <= '1') AND (i.ns_right >= '14') AND (i.ns_level <= '0') AND (i.ns_level > '0')
ORDER BY i.ns_left
SELECT i.*, w.controller as `controller`, w.name as `name`, wb.*, i.id as `id`
FROM cms_widgets_bind_pages i
INNER JOIN cms_widgets_bind as wb ON wb.id = i.bind_id
INNER JOIN cms_widgets as w ON w.id = wb.widget_id
WHERE (i.page_id IN ('0','186','188')) AND (i.template = 'psxclub') AND (i.is_enabled = '1')
ORDER BY i.position, i.ordering
LIMIT 1000
SELECT i.*, menu.name as `menu_name`, COUNT(childs.id) as `childs_count`
FROM cms_menu_items i
LEFT JOIN cms_menu as menu ON menu.id = i.menu_id
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id AND childs.is_enabled = 1
WHERE (i.is_enabled = '1')
GROUP BY i.id
ORDER BY i.ordering asc
LIMIT 1000
SELECT COUNT( i.id) as `count`
FROM cms_con_board i
WHERE (i.user_id = '0') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub >= '1')
SELECT i.*
FROM cms_con_board_cats i
WHERE (i.is_hidden IS NULL) AND (i.parent_id > '0')
ORDER BY i.ns_left
LIMIT 1000
SELECT i.*
FROM cms_con_articles_cats i
WHERE (i.is_hidden IS NULL) AND (i.parent_id > '0')
ORDER BY i.ns_left
LIMIT 1000
SELECT i.*, r.nested_position as `nested_position`, r.parent_id as `parent_id`, r.title as `row_title`, r.options as `row_options`, r.class as `row_class`, r.tag as `row_tag`
FROM cms_layout_cols i
INNER JOIN cms_layout_rows as r ON r.id = i.row_id
WHERE (r.template = 'psxclub')
ORDER BY r.ordering asc, i.ordering asc
LIMIT 1000