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 = '506-resident-evil-village-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 = '506') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701093536374')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '713977613816')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_users i
WHERE (i.id = '4840')
LIMIT 1
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 = '701093536374') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '701093536374')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701093536374')
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 = '713977613816') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '713977613816')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '713977613816')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_users i
WHERE (i.id = '4840')
LIMIT 1
SELECT date_created
FROM cms_sessions_online i
WHERE (i.user_id = '4840')
LIMIT 1
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4840')
LIMIT 1000
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '506') 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 = '506') 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 = '506') 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 ('4992','777','5414','3160','1049','4844','4202','4840','1559','240','4127','2051','807','5989','21','5131','4312','1582','1372','2776','377','5043','4254','4045','1676','6103','2859','3951','4048','5206','5908','1208','2018','4734','3806','2483','281','557','2464','5227','1508','2384','169','4419','1359','1446','2920','3037','5832','533','5694','3777','3147','4263','4039','1983','793','679','1388','1151','665','541','4220','3110','4331','2746','3292','1552','2922','2367','3024','864','4314','1933','5672','299','117','1018','1782','4634','3277','196','3693','3722','1010','984','4067','1548','4577','687','1459','4756','5171','3944','3402','5439','5286','5371','1714','800','1700','4097','421','5295','2304','787','1313','2886','5225','1848','2449','2376','4666','4346','2651','2818','2503','1492','4511','1380','3043','64','5215','2642','4221','2131','4124','5224','5042','4480','4451','1554','258','2851','4522','3949','1642','1590','5275','448','369','3180','2167','1697','4608','4576','256','5229','5142','1816','1403','2461','3742','5117','146','1901','4678','2012','3868','4369','5210','4426','289','2103','1253','2820','3767','2294','4237','4780','4468','1831','4854','4954','5016','4212','4550','614','3802','4773','4764','5032','4836','4320','4177','1991','3223','4267','4309','4376','4467','764','1097','4998','5128','695','4226','2252','5091','4322','5059','32','4242','3001','603','450','1691','4865','4947','781','2297','1644','1382','466','4650','4979','1246','1434','3353','4726','797','756','3356','4610','4846','4832','1120','2680','151','2906','4713','3445','4664','985','4750','3683','4486','4558','2245','1202','1022','2402','1414','2865','4264','4642','1430','4318','3176','897','2504','1864','1523','2385','1163','626','1117','1553','4461','69','1495','677','407','3360','2752','59','3071','4192','1050','3494','4455','4447','2292','912','3465','4415','1214','2519','4365','2415','1829','3517','3754','4342','4230','4345','445','4103','90','1265','1766','384'))
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4992')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '777')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5414')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '3160')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1049')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4844')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4202')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1559')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '240')
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 < '2022-07-25 10:45:00') OR ((i.date_pub = '2022-07-25 10:45:00') AND (i.id < '506') ) )
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 > '2022-07-25 10:45:00') OR ((i.date_pub = '2022-07-25 10:45:00') AND (i.id > '506') ) )
ORDER BY i.date_pub asc, i.id asc
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.user_hash = 'ed35841719')
LIMIT 1
SELECT i.*
FROM cms_cart_orders i
WHERE (i.user_hash = 'ed35841719')
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.order_id IS NULL) AND (i.user_hash = 'ed35841719')
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '506') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701093536374')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '713977613816')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_users i
WHERE (i.id = '4840')
LIMIT 1
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 = '701093536374') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '701093536374')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701093536374')
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 = '713977613816') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '713977613816')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '713977613816')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_users i
WHERE (i.id = '4840')
LIMIT 1
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '506') 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 = '506') 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 = '506') 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 ('4992','777','5414','3160','1049','4844','4202','4840','1559','240','4127','2051','807','5989','21','5131','4312','1582','1372','2776','377','5043','4254','4045','1676','6103','2859','3951','4048','5206','5908','1208','2018','4734','3806','2483','281','557','2464','5227','1508','2384','169','4419','1359','1446','2920','3037','5832','533','5694','3777','3147','4263','4039','1983','793','679','1388','1151','665','541','4220','3110','4331','2746','3292','1552','2922','2367','3024','864','4314','1933','5672','299','117','1018','1782','4634','3277','196','3693','3722','1010','984','4067','1548','4577','687','1459','4756','5171','3944','3402','5439','5286','5371','1714','800','1700','4097','421','5295','2304','787','1313','2886','5225','1848','2449','2376','4666','4346','2651','2818','2503','1492','4511','1380','3043','64','5215','2642','4221','2131','4124','5224','5042','4480','4451','1554','258','2851','4522','3949','1642','1590','5275','448','369','3180','2167','1697','4608','4576','256','5229','5142','1816','1403','2461','3742','5117','146','1901','4678','2012','3868','4369','5210','4426','289','2103','1253','2820','3767','2294','4237','4780','4468','1831','4854','4954','5016','4212','4550','614','3802','4773','4764','5032','4836','4320','4177','1991','3223','4267','4309','4376','4467','764','1097','4998','5128','695','4226','2252','5091','4322','5059','32','4242','3001','603','450','1691','4865','4947','781','2297','1644','1382','466','4650','4979','1246','1434','3353','4726','797','756','3356','4610','4846','4832','1120','2680','151','2906','4713','3445','4664','985','4750','3683','4486','4558','2245','1202','1022','2402','1414','2865','4264','4642','1430','4318','3176','897','2504','1864','1523','2385','1163','626','1117','1553','4461','69','1495','677','407','3360','2752','59','3071','4192','1050','3494','4455','4447','2292','912','3465','4415','1214','2519','4365','2415','1829','3517','3754','4342','4230','4345','445','4103','90','1265','1766','384'))
LIMIT 1000
SELECT i.*
FROM cms_imini_attaches i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'market') AND (i.target_id = '506')
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