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 = '694-assassin-s-creed-mirage-deluxe-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 = '694') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696428391160')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696634427268')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696671150326')
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 = '696428391160') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '696428391160')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696428391160')
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 = '696634427268') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '696634427268')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696634427268')
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 = '696671150326') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '696671150326')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696671150326')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '694') 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 = '694') 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 = '694') 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 ('4067','174','1872','5272','2776','3037','5131','2391','4048','1155','1559','2252','1164','3008','807','5225','5247','1666','1700','281','5896','1029','1951','5813','3777','4856','4331','2103','4529','5778','3806','793','4468','1265','2018','2384','1429','2835','4829','3176','2449','4312','4979','2920','5501','5096','1178','2131','3397','3225','1195','4143','3728','934','5417','5402','157','5371','4480','26','1582','1114','1983','4734','3471','3973','4124','1514','3707','4525','1526','1492','4589','756','1359','3494','4097','4678','3363','841','3327','2574','2646','2990','5029','4844','481','1848','5195','5042','662','289','3934','3292','1458','3718','5324','1246','984','2051','3868','2376','4045','1643','5142','3802','1562','4756','4177','2598','5295','448','4049','3324','4664','1380','2836','3748','4725','4618','4003','4770','527','8','4371','1764','479','541','5083','577','734','2145','4349','624','1847','2749','1719','1642','3326','2824','521','2520','369','388','996','75','5299','1936','606','908','1382','2067','3901','1048','1551','144','4550','5078','815','3279','3106','1630','3110','687','2679','468','1189','3360','1459','4610','4666','4256','1586','4309','5','2191','676','2323','149','1693','3817','2304','4576','1817','2719','3205','1883','1208','1712','764','240','4251','1043','2367','2976','5179','1270','1590','4350','142','3780','3951','1193','1714','5036','2763','4947','5224','1767','2981','425','1852','1151','2208','377','558','679','2818','4','4314','2154','1049','4419','713','491','3683','5000','639','1808','4254','4461','1434','2569','2483','4441','2823','4677','4961','2928','5032','3309','1829','1523','1018','665','3702','3722','4902','750','3542','5234','64','4868','1294','1552','131','1934','4811','1946','4805','2996','2699','4978','4602','2298','4698','1986','4992','3071','1760','2365','1831','571','3474','3043','4940','5107','329','5169','4322','2012','5261','407','3258','590','1697','5254','2032','5153','136','2137','5232','4098','1214','4230','2510','184','1565','1302','1446','3904','90','1037','1815','3742','243','5194','2406','5084','4662','5055','2121','373','4203','4452','460','350','4397','1010','5209','4426','2428','4650','5117','3620','5010','1599','5051','2886','4308','5040','1403','5183','2820','4564','21','1508','1452','4225','4244','2649','711','757','4434','5152','117','1388','2461','2929','1634','1397','4221','1553','146','3223','4320','4608','1732','2658','3120','694'))
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4067')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '174')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1872')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5272')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '2776')
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 = '5131')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '2391')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4048')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1155')
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-05-25 01:00:00') OR ((i.date_pub = '2023-05-25 01:00:00') AND (i.id < '694') ) )
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-05-25 01:00:00') OR ((i.date_pub = '2023-05-25 01:00:00') AND (i.id > '694') ) )
ORDER BY i.date_pub asc, i.id asc
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.user_hash = '00991b7af3')
LIMIT 1
SELECT i.*
FROM cms_cart_orders i
WHERE (i.user_hash = '00991b7af3')
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.order_id IS NULL) AND (i.user_hash = '00991b7af3')
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '694') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696428391160')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696634427268')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696671150326')
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 = '696428391160') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '696428391160')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696428391160')
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 = '696634427268') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '696634427268')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696634427268')
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 = '696671150326') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '696671150326')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '696671150326')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '694') 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 = '694') 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 = '694') 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 ('4067','174','1872','5272','2776','3037','5131','2391','4048','1155','1559','2252','1164','3008','807','5225','5247','1666','1700','281','5896','1029','1951','5813','3777','4856','4331','2103','4529','5778','3806','793','4468','1265','2018','2384','1429','2835','4829','3176','2449','4312','4979','2920','5501','5096','1178','2131','3397','3225','1195','4143','3728','934','5417','5402','157','5371','4480','26','1582','1114','1983','4734','3471','3973','4124','1514','3707','4525','1526','1492','4589','756','1359','3494','4097','4678','3363','841','3327','2574','2646','2990','5029','4844','481','1848','5195','5042','662','289','3934','3292','1458','3718','5324','1246','984','2051','3868','2376','4045','1643','5142','3802','1562','4756','4177','2598','5295','448','4049','3324','4664','1380','2836','3748','4725','4618','4003','4770','527','8','4371','1764','479','541','5083','577','734','2145','4349','624','1847','2749','1719','1642','3326','2824','521','2520','369','388','996','75','5299','1936','606','908','1382','2067','3901','1048','1551','144','4550','5078','815','3279','3106','1630','3110','687','2679','468','1189','3360','1459','4610','4666','4256','1586','4309','5','2191','676','2323','149','1693','3817','2304','4576','1817','2719','3205','1883','1208','1712','764','240','4251','1043','2367','2976','5179','1270','1590','4350','142','3780','3951','1193','1714','5036','2763','4947','5224','1767','2981','425','1852','1151','2208','377','558','679','2818','4','4314','2154','1049','4419','713','491','3683','5000','639','1808','4254','4461','1434','2569','2483','4441','2823','4677','4961','2928','5032','3309','1829','1523','1018','665','3702','3722','4902','750','3542','5234','64','4868','1294','1552','131','1934','4811','1946','4805','2996','2699','4978','4602','2298','4698','1986','4992','3071','1760','2365','1831','571','3474','3043','4940','5107','329','5169','4322','2012','5261','407','3258','590','1697','5254','2032','5153','136','2137','5232','4098','1214','4230','2510','184','1565','1302','1446','3904','90','1037','1815','3742','243','5194','2406','5084','4662','5055','2121','373','4203','4452','460','350','4397','1010','5209','4426','2428','4650','5117','3620','5010','1599','5051','2886','4308','5040','1403','5183','2820','4564','21','1508','1452','4225','4244','2649','711','757','4434','5152','117','1388','2461','2929','1634','1397','4221','1553','146','3223','4320','4608','1732','2658','3120','694'))
LIMIT 1000
SELECT i.*
FROM cms_imini_attaches i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'market') AND (i.target_id = '694')
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