Консоль отладки Joomla!

53 SQL-запросов зафиксировано

1. SELECT `data`
  FROM `e8sm7_session`
  WHERE `session_id` = 's4avou3b5vm1im7esd8d200k11'
2. DELETE
  FROM `e8sm7_session`
  WHERE `time` < '1610970617'
3. SELECT `session_id`
  FROM `e8sm7_session`
  WHERE `session_id` = 's4avou3b5vm1im7esd8d200k11'
  LIMIT 0, 1
4. INSERT INTO `e8sm7_session` (`session_id`, `client_id`, `time`)
  VALUES ('s4avou3b5vm1im7esd8d200k11', 0, '1610974217')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM e8sm7_usergroups AS a
  LEFT JOIN e8sm7_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `e8sm7_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM e8sm7_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT `enabled`
  FROM `e8sm7_extensions`
  WHERE `element` = 'com_akeeba'
  AND `type` = 'component'
11. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
12. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM e8sm7_menu AS m
  LEFT JOIN e8sm7_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
13. SELECT id, home, template, s.params
  FROM e8sm7_template_styles as s
  LEFT JOIN e8sm7_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
14. SELECT *
  FROM e8sm7_languages
  WHERE published=1
  ORDER BY ordering ASC
15. SELECT a.rules
  FROM e8sm7_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
16. SELECT b.rules
  FROM e8sm7_assets AS a
  LEFT JOIN e8sm7_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.id = 1)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
17. SELECT b.rules
  FROM e8sm7_assets AS a
  LEFT JOIN e8sm7_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
18. SELECT id
  FROM e8sm7_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
19. SELECT *
  FROM e8sm7_k2_items
  WHERE id=34
  LIMIT 0, 1
20. SHOW FULL COLUMNS
  FROM `e8sm7_k2_categories`
21. SELECT *
  FROM e8sm7_k2_categories
  WHERE id = '14'
22. SELECT *
  FROM e8sm7_k2_attachments
  WHERE itemID=34
23. SELECT COUNT(*)
  FROM e8sm7_k2_comments
  WHERE itemID=34
  AND published=1
24. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_ipricecalc'
25. select *
  from e8sm7_iprice_curr
  where published=1
26. select *
  from e8sm7_iprice_pricefields
  where published=1
  ORDER BY ordering
27. SELECT ipi.id as key1, ipc.id as key2, ips.id as key3,ips.name as section, ips.alias as secalias, ips.discid as secdiscid, ipc.discid as catdiscid, ipc.name as category, ipc.alias as catalias, ips.formulaprice as secformulaprice, ips.formulaweight as secformulaweight, ips.inputfields as secinputfields, ips.customfields as seccustfields, ips.pricefields as secpricefields, ipc.formulaprice as catformulaprice, ipc.formulaweight as catformulaweight, ipc.inputfields as catinputfields, ipc.customfields as catcustfields, ipc.pricefields as catpricefields, ipc.dropdown as catdropdown, ipc.totalcost as catcost, ipc.ismultiple as ismultiple, ipc.salestax as catsalestax, ips.salestax as secsalestax, ips.userdiscid1 as secdiscid1, ips.userdiscid2 as secdiscid2, ips.userdiscid3 as secdiscid3, ips.userdiscid4 as secdiscid4, ips.userdiscid5 as secdiscid5 , ipc.userdiscid1 as catdiscid1, ipc.userdiscid2 as catdiscid2, ipc.userdiscid3 as catdiscid3, ipc.userdiscid4 as catdiscid4, ipc.userdiscid5 as catdiscid5 , 0 as count, ipi.* ,0 AS count
  FROM e8sm7_iprice_item AS ipi
  INNER JOIN e8sm7_iprice_categories AS ipc
  ON ipi.catid = ipc.id
  INNER JOIN e8sm7_iprice_sections AS ips
  ON ipi.secid = ips.id
  WHERE ipi.published = 1
  and ipc.published = 1
  and ips.published = 1
  and ipi.forcart=0
  ORDER BY ips.ordering,ipc.ordering,ipi.ordering
  LIMIT 0, 5
28. SELECT ipi.id as key1, ipc.id as key2, ips.id as key3,ips.name as section, ips.alias as secalias, ips.discid as secdiscid, ipc.discid as catdiscid, ipc.name as category, ipc.alias as catalias, ips.formulaprice as secformulaprice, ips.formulaweight as secformulaweight, ips.inputfields as secinputfields, ips.customfields as seccustfields, ips.pricefields as secpricefields, ipc.formulaprice as catformulaprice, ipc.formulaweight as catformulaweight, ipc.inputfields as catinputfields, ipc.customfields as catcustfields, ipc.pricefields as catpricefields, ipc.dropdown as catdropdown, ipc.totalcost as catcost, ipc.ismultiple as ismultiple, ipc.salestax as catsalestax, ips.salestax as secsalestax, ips.userdiscid1 as secdiscid1, ips.userdiscid2 as secdiscid2, ips.userdiscid3 as secdiscid3, ips.userdiscid4 as secdiscid4, ips.userdiscid5 as secdiscid5 , ipc.userdiscid1 as catdiscid1, ipc.userdiscid2 as catdiscid2, ipc.userdiscid3 as catdiscid3, ipc.userdiscid4 as catdiscid4, ipc.userdiscid5 as catdiscid5 , 0 as count, ipi.* ,0 AS count
  FROM e8sm7_iprice_item AS ipi
  INNER JOIN e8sm7_iprice_categories AS ipc
  ON ipi.catid = ipc.id
  INNER JOIN e8sm7_iprice_sections AS ips
  ON ipi.secid = ips.id
  WHERE ipi.published = 1
  and ipc.published = 1
  and ips.published = 1
  and ipi.forcart=0
  ORDER BY ips.ordering,ipc.ordering,ipi.ordering
29. SHOW FULL COLUMNS
  FROM `e8sm7_iprice_sections`
30. SHOW FULL COLUMNS
  FROM `e8sm7_k2_items`
31. UPDATE e8sm7_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '34'
32. SELECT *
  FROM e8sm7_rsform_config
33. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM e8sm7_modules AS m
  LEFT JOIN e8sm7_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN e8sm7_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-18 12:50:17')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-18 12:50:17')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 435 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
34. SELECT *
  FROM e8sm7_acymailing_config
35. SELECT *
  FROM e8sm7_acymailing_list
  WHERE type = 'list'
  ORDER BY ordering ASC
36. SELECT *
  FROM `e8sm7_acymailing_fields` as a
  WHERE a.`published` = 1
  ORDER BY a.`ordering` ASC
37. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM e8sm7_k2_items as i RIGHT JOIN e8sm7_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-18 12:50:17' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-18 12:50:17' )
  AND i.catid IN(14)
  ORDER BY i.id DESC
  LIMIT 0, 3
38. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM e8sm7_k2_items as i RIGHT JOIN e8sm7_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-18 12:50:17' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-18 12:50:17' )
  AND i.catid IN(15)
  ORDER BY i.id DESC
  LIMIT 0, 1
39. SELECT ipi.id as key1, ipc.id as key2, ips.id as key3,ips.name as section, ips.alias as secalias, ips.discid as secdiscid, ipc.discid as catdiscid, ipc.name as category, ipc.alias as catalias, ips.formulaprice as secformulaprice, ips.formulaweight as secformulaweight, ips.inputfields as secinputfields, ips.customfields as seccustfields, ips.pricefields as secpricefields, ipc.formulaprice as catformulaprice, ipc.formulaweight as catformulaweight, ipc.inputfields as catinputfields, ipc.customfields as catcustfields, ipc.pricefields as catpricefields, ipc.dropdown as catdropdown, ipc.totalcost as catcost, ipc.ismultiple as ismultiple, ipc.salestax as catsalestax, ips.salestax as secsalestax, ips.userdiscid1 as secdiscid1, ips.userdiscid2 as secdiscid2, ips.userdiscid3 as secdiscid3, ips.userdiscid4 as secdiscid4, ips.userdiscid5 as secdiscid5 , ipc.userdiscid1 as catdiscid1, ipc.userdiscid2 as catdiscid2, ipc.userdiscid3 as catdiscid3, ipc.userdiscid4 as catdiscid4, ipc.userdiscid5 as catdiscid5 , 0 as count, ipi.* ,0 AS count
  FROM e8sm7_iprice_item AS ipi
  INNER JOIN e8sm7_iprice_categories AS ipc
  ON ipi.catid = ipc.id
  INNER JOIN e8sm7_iprice_sections AS ips
  ON ipi.secid = ips.id
  WHERE ipi.published = 1
  and ipc.published = 1
  and ips.published = 1
  and ipi.forcart=0
  ORDER BY ips.ordering,ipc.ordering,ipi.ordering
  LIMIT 0, 40
40. SELECT ipi.id as key1, ipc.id as key2, ips.id as key3,ips.name as section, ips.alias as secalias, ips.discid as secdiscid, ipc.discid as catdiscid, ipc.name as category, ipc.alias as catalias, ips.formulaprice as secformulaprice, ips.formulaweight as secformulaweight, ips.inputfields as secinputfields, ips.customfields as seccustfields, ips.pricefields as secpricefields, ipc.formulaprice as catformulaprice, ipc.formulaweight as catformulaweight, ipc.inputfields as catinputfields, ipc.customfields as catcustfields, ipc.pricefields as catpricefields, ipc.dropdown as catdropdown, ipc.totalcost as catcost, ipc.ismultiple as ismultiple, ipc.salestax as catsalestax, ips.salestax as secsalestax, ips.userdiscid1 as secdiscid1, ips.userdiscid2 as secdiscid2, ips.userdiscid3 as secdiscid3, ips.userdiscid4 as secdiscid4, ips.userdiscid5 as secdiscid5 , ipc.userdiscid1 as catdiscid1, ipc.userdiscid2 as catdiscid2, ipc.userdiscid3 as catdiscid3, ipc.userdiscid4 as catdiscid4, ipc.userdiscid5 as catdiscid5 , 0 as count, ipi.* ,0 AS count
  FROM e8sm7_iprice_item AS ipi
  INNER JOIN e8sm7_iprice_categories AS ipc
  ON ipi.catid = ipc.id
  INNER JOIN e8sm7_iprice_sections AS ips
  ON ipi.secid = ips.id
  WHERE ipi.published = 1
  and ipc.published = 1
  and ips.published = 1
  and ipi.forcart=0
  ORDER BY ips.ordering,ipc.ordering,ipi.ordering
41. SHOW FULL COLUMNS
  FROM `e8sm7_users`
42. SELECT *
  FROM `e8sm7_users`
  WHERE `id` = 763
43. SELECT `g`.`id`,`g`.`title`
  FROM `e8sm7_usergroups` AS g
  INNER JOIN `e8sm7_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 763
44. SELECT `description`, `gender`
  FROM e8sm7_k2_users
  WHERE userID=763
  LIMIT 0, 1
45. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM e8sm7_k2_users
  WHERE userID=763
46. select *
  from e8sm7_revslider_sliders
  where id=1
47. select *
  from e8sm7_revslider_slides
  where slider_id=1
  order by slide_order
48. select *
  from e8sm7_revslider_layer_animations
49. select *
  from e8sm7_revslider_layer_animations
50. select *
  from e8sm7_revslider_layer_animations
51. select *
  from e8sm7_revslider_layer_animations
52. SELECT `enabled`
  FROM `e8sm7_extensions`
  WHERE `element` = 'com_akeeba'
  AND `type` = 'component'
53. UPDATE `e8sm7_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610974217;s:18:\"session.timer.last\";i:1610974217;s:17:\"session.timer.now\";i:1610974217;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_ipricecalc\";O:8:\"stdClass\":5:{s:10:\"plugparams\";N;s:15:\"currproductsurl\";s:19:\"http://sibgals.com/\";s:7:\"pparams\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":193:{s:13:\"manageruserid\";s:3:\"764\";s:4:\"curr\";s:3:\"RUR\";s:10:\"finishtext\";s:29:\"Заказ отправлен\";s:10:\"showprices\";s:1:\"0\";s:17:\"zeropricecontract\";s:1:\"1\";s:7:\"defview\";s:1:\"0\";s:7:\"defsort\";s:0:\"\";s:10:\"defsortdir\";s:4:\"desc\";s:15:\"usestrongfilter\";s:1:\"0\";s:14:\"showcurrselect\";s:1:\"0\";s:16:\"showcatinsection\";s:1:\"1\";s:9:\"usepaging\";s:1:\"1\";s:11:\"showpagenum\";s:1:\"1\";s:10:\"numperpage\";s:2:\"40\";s:19:\"numperpageforseccat\";s:2:\"10\";s:7:\"warning\";s:0:\"\";s:12:\"addtocartqty\";s:1:\"0\";s:6:\"minqty\";s:1:\"0\";s:6:\"maxqty\";s:1:\"0\";s:7:\"stepqty\";s:1:\"1\";s:10:\"qtyenabled\";s:1:\"1\";s:13:\"qtylistvalues\";s:0:\"\";s:11:\"isaddtocart\";s:1:\"0\";s:10:\"enableajax\";s:1:\"1\";s:13:\"allowzeroitem\";s:1:\"1\";s:14:\"denyoutofstock\";s:1:\"0\";s:9:\"showavail\";s:1:\"3\";s:10:\"instocklow\";s:3:\"100\";s:11:\"newitemdays\";s:0:\"\";s:17:\"forceregistration\";s:1:\"0\";s:10:\"allowguest\";s:1:\"1\";s:15:\"showbreadcrumbs\";s:1:\"0\";s:11:\"maxfilesize\";s:0:\"\";s:11:\"enableredir\";s:1:\"0\";s:8:\"redirurl\";s:0:\"\";s:10:\"usecaptcha\";s:1:\"0\";s:15:\"usecaptchaorder\";s:1:\"1\";s:16:\"usecbintegration\";s:1:\"0\";s:17:\"excelexportfields\";a:1:{i:0;s:0:\"\";}s:10:\"decimalsep\";s:1:\".\";s:11:\"thousandsep\";s:1:\" \";s:10:\"weightunit\";s:2:\"kg\";s:12:\"weighdecimal\";s:1:\"2\";s:12:\"capacityunit\";s:0:\"\";s:11:\"simpleprice\";s:1:\"1\";s:7:\"usetabs\";s:1:\"0\";s:8:\"showisec\";s:1:\"1\";s:12:\"showisecdesc\";s:1:\"0\";s:8:\"showicat\";s:1:\"0\";s:12:\"showicatdesc\";s:1:\"0\";s:11:\"displaydesc\";s:1:\"0\";s:19:\"priceshowselectsort\";s:1:\"0\";s:19:\"priceshowselectview\";s:1:\"0\";s:15:\"showexcelexport\";s:1:\"0\";s:16:\"showheaderfilter\";s:1:\"0\";s:14:\"namefiltertype\";s:1:\"0\";s:9:\"iconphoto\";s:1:\"0\";s:10:\"showselect\";s:1:\"0\";s:10:\"showtocart\";s:1:\"0\";s:10:\"showaddall\";s:1:\"0\";s:12:\"showcheckall\";s:1:\"0\";s:13:\"showpagetotal\";s:1:\"0\";s:17:\"showsaveselection\";s:1:\"0\";s:13:\"showmakeorder\";s:1:\"0\";s:11:\"ithumbwidth\";s:0:\"\";s:12:\"ithumbheight\";s:0:\"\";s:11:\"deftemplate\";s:5:\"cart2\";s:17:\"catshowselectsort\";s:1:\"1\";s:17:\"catshowselectview\";s:1:\"1\";s:11:\"catshowicat\";s:1:\"1\";s:13:\"catshowtocart\";s:1:\"1\";s:13:\"catshowselect\";s:1:\"1\";s:15:\"showdropdowncat\";s:1:\"0\";s:18:\"showdescriptioncat\";s:1:\"1\";s:16:\"showcharactercat\";s:1:\"0\";s:14:\"showcommentcat\";s:1:\"0\";s:13:\"showunitprice\";s:1:\"0\";s:15:\"createimagelink\";s:1:\"1\";s:13:\"itemuselayout\";s:4:\"tabs\";s:15:\"itemusecomments\";s:1:\"0\";s:12:\"itemshowicat\";s:1:\"1\";s:14:\"itemshowselect\";s:1:\"1\";s:14:\"itemshowtocart\";s:1:\"1\";s:14:\"cartheadertext\";s:0:\"\";s:12:\"cartheaderid\";s:0:\"\";s:18:\"disableorderamount\";s:1:\"0\";s:11:\"showcompare\";s:1:\"0\";s:21:\"showsavechangesbutton\";s:1:\"1\";s:15:\"cartdisplaydesc\";s:1:\"2\";s:12:\"cartshowisec\";s:1:\"0\";s:12:\"cartshowicat\";s:1:\"0\";s:27:\"cartshowtotalbeforediscount\";s:1:\"0\";s:21:\"cartshowtotaldiscount\";s:1:\"0\";s:26:\"cartshowtotalafterdiscount\";s:1:\"0\";s:20:\"cartshowtotalwthttax\";s:1:\"0\";s:16:\"cartshowtotaltax\";s:1:\"0\";s:19:\"cartshowweighttotal\";s:1:\"0\";s:21:\"cartshowcapacitytotal\";s:1:\"0\";s:10:\"pruducturl\";s:0:\"\";s:12:\"isymboldelim\";s:1:\"/\";s:12:\"copyinfoprev\";s:1:\"1\";s:13:\"showorderdesc\";s:1:\"1\";s:13:\"showorderisec\";s:1:\"0\";s:13:\"showordericat\";s:1:\"0\";s:28:\"ordershowtotalbeforediscount\";s:1:\"0\";s:22:\"ordershowtotaldiscount\";s:1:\"0\";s:27:\"ordershowtotalafterdiscount\";s:1:\"0\";s:21:\"ordershowtotalwthttax\";s:1:\"0\";s:20:\"ordershowweighttotal\";s:1:\"0\";s:22:\"ordershowcapacitytotal\";s:1:\"0\";s:12:\"saveorderxml\";s:1:\"0\";s:7:\"xmlpath\";s:0:\"\";s:14:\"attachorderxml\";s:1:\"0\";s:10:\"attachbill\";s:1:\"0\";s:8:\"billview\";s:1:\"0\";s:12:\"emailsubject\";s:0:\"\";s:13:\"orderheaderid\";s:0:\"\";s:11:\"ordertextid\";s:0:\"\";s:13:\"orderfooterid\";s:0:\"\";s:13:\"sendordercust\";s:1:\"1\";s:14:\"sendordermanag\";s:1:\"1\";s:14:\"sendnotifycust\";s:1:\"1\";s:15:\"sendnotifymanag\";s:1:\"1\";s:13:\"decstockstate\";s:1:\"0\";s:13:\"incstockstate\";s:2:\"99\";s:12:\"allowpdfbill\";s:1:\"1\";s:12:\"allowactions\";s:1:\"1\";s:9:\"croporfit\";s:1:\"1\";s:7:\"ieffect\";s:1:\"2\";s:14:\"numgallerycols\";s:1:\"2\";s:15:\"smallthumbwidth\";s:0:\"\";s:16:\"smallthumbheight\";s:0:\"\";s:16:\"mediumthumbwidth\";s:0:\"\";s:17:\"mediumthumbheight\";s:0:\"\";s:15:\"largethumbwidth\";s:0:\"\";s:16:\"largethumbheight\";s:0:\"\";s:10:\"usepayment\";s:1:\"0\";s:10:\"successurl\";s:0:\"\";s:7:\"failurl\";s:0:\"\";s:13:\"globaltaxrate\";s:0:\"\";s:7:\"taxmode\";s:1:\"0\";s:10:\"globaldisc\";s:1:\"0\";s:9:\"userdisc1\";s:1:\"0\";s:9:\"userdisc2\";s:1:\"0\";s:9:\"userdisc3\";s:1:\"0\";s:9:\"userdisc4\";s:1:\"0\";s:9:\"userdisc5\";s:1:\"0\";s:11:\"cumuldiscid\";s:1:\"0\";s:10:\"bonusratio\";s:0:\"\";s:14:\"bonusroundrate\";s:0:\"\";s:14:\"importfilename\";s:10:\"index.html\";s:11:\"importscode\";s:0:\"\";s:13:\"celldelimiter\";s:1:\";\";s:13:\"textdelimiter\";s:1:\"\"\";s:12:\"eoldelimiter\";s:2:\"\\n\";s:15:\"importhasheader\";s:1:\"0\";s:9:\"removeall\";s:1:\"0\";s:17:\"usepricecsscolors\";s:1:\"1\";s:9:\"textcolor\";s:0:\"\";s:9:\"backcolor\";s:0:\"\";s:17:\"itemevenbackcolor\";s:0:\"\";s:16:\"itemoddbackcolor\";s:0:\"\";s:13:\"disctextcolor\";s:0:\"\";s:16:\"sectiontextcolor\";s:0:\"\";s:14:\"sectionbkcolor\";s:0:\"\";s:17:\"categorytextcolor\";s:0:\"\";s:15:\"categorybkcolor\";s:0:\"\";s:15:\"headertextcolor\";s:0:\"\";s:13:\"headerbkcolor\";s:0:\"\";s:14:\"totaltextcolor\";s:0:\"\";s:12:\"totalbkcolor\";s:0:\"\";s:13:\"desctextcolor\";s:0:\"\";s:11:\"descbkcolor\";s:0:\"\";s:12:\"delimbkcolor\";s:0:\"\";s:14:\"startfadecolor\";s:7:\"#fb9393\";s:12:\"endfadecolor\";s:7:\"#fdfdfd\";s:9:\"menu_text\";i:1;s:17:\"show_page_heading\";i:0;s:6:\"secure\";i:0;s:15:\"show_item_title\";s:1:\"1\";s:17:\"custom_item_color\";s:1:\"0\";s:10:\"item_color\";s:7:\"#666666\";s:9:\"sub_width\";s:3:\"200\";s:10:\"sub_margin\";s:1:\"5\";s:11:\"sub_padding\";s:1:\"5\";s:13:\"create_column\";s:1:\"0\";s:11:\"load_module\";s:1:\"0\";s:12:\"module_style\";s:4:\"none\";s:10:\"page_title\";s:14:\"Главная\";s:16:\"page_description\";s:0:\"\";s:11:\"page_rights\";s:0:\"\";s:6:\"robots\";s:0:\"\";s:8:\"payments\";a:1:{i:0;s:0:\"\";}}}s:11:\"cartbackurl\";s:19:\"http://sibgals.com/\";s:7:\"isearch\";N;}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:13:\"session.token\";s:32:\"02efecf8d5e858342b4e71ea9130f182\";s:16:\"com_mailto.links\";a:1:{s:40:\"a16f0c771a166e16b0db3f400ed408597c4b4146\";O:8:\"stdClass\":2:{s:4:\"link\";s:19:\"http://sibgals.com/\";s:6:\"expiry\";i:1610974217;}}}' , `time` = '1610974218'
  WHERE `session_id` = 's4avou3b5vm1im7esd8d200k11'

41 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

1. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
2. 4 × SELECT ipi.id as key1, ipc.id as key2, ips.id as key3,ips.name as section, ips.alias as secalias, ips.discid as secdiscid, ipc.discid as catdiscid, ipc.name as category, ipc.alias as catalias, ips.formulaprice as secformulaprice, ips.formulaweight as secformulaweight, ips.inputfields as secinputfields, ips.customfields as seccustfields, ips.pricefields as secpricefields, ipc.formulaprice as catformulaprice, ipc.formulaweight as catformulaweight, ipc.inputfields as catinputfields, ipc.customfields as catcustfields, ipc.pricefields as catpricefields, ipc.dropdown as catdropdown, ipc.totalcost as catcost, ipc.ismultiple as ismultiple, ipc.salestax as catsalestax, ips.salestax as secsalestax, ips.userdiscid1 as secdiscid1, ips.userdiscid2 as secdiscid2, ips.userdiscid3 as secdiscid3, ips.userdiscid4 as secdiscid4, ips.userdiscid5 as secdiscid5 , ipc.userdiscid1 as catdiscid1, ipc.userdiscid2 as catdiscid2, ipc.userdiscid3 as catdiscid3, ipc.userdiscid4 as catdiscid4, ipc.userdiscid5 as catdiscid5 , 0 as count, ipi.* ,0 AS count
  FROM e8sm7_iprice_item AS ipi
  INNER JOIN e8sm7_iprice_categories AS ipc
  ON ipi.catid = ipc.id
  INNER JOIN e8sm7_iprice_sections AS ips
  ON ipi.secid = ips.id
3. 4 × select *
  from e8sm7_revslider_layer_animation
4. 2 × SELECT `enabled`
  FROM `e8sm7_extensions`
5. 2 × SELECT b.rules
  FROM e8sm7_assets AS a
  LEFT JOIN e8sm7_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
6. 2 × SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM e8sm7_k2_items as i RIGHT JOIN e8sm7_k2_categories c
  ON c.id = i.catid
7. 1 × SELECT *
  FROM `e8sm7_acymailing_fields` as a
8. 1 × SELECT *
  FROM e8sm7_acymailing_list
9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM e8sm7_modules AS m
  LEFT JOIN e8sm7_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN e8sm7_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
10. 1 × SELECT *
  FROM e8sm7_rsform_confi
11. 1 × SELECT *
  FROM e8sm7_acymailing_confi
12. 1 × SELECT `g`.`id`,`g`.`title`
  FROM `e8sm7_usergroups` AS g
  INNER JOIN `e8sm7_user_usergroup_map` AS m
  ON m.group_id = g.id
13. 1 × select *
  from e8sm7_revslider_sliders
14. 1 × select *
  from e8sm7_revslider_slides
15. 1 × SELECT id, gender, description, image, url, `
  group`, plugins
  FROM e8sm7_k2_users
16. 1 × SELECT `description`, `gender`
  FROM e8sm7_k2_users
17. 1 × select *
  from e8sm7_iprice_pricefields
18. 1 × SELECT *
  FROM `e8sm7_users`
19. 1 × SELECT COUNT(*)
  FROM e8sm7_k2_comments
20. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM e8sm7_menu AS m
  LEFT JOIN e8sm7_extensions AS e
  ON m.component_id = e.extension_id
21. 1 × SELECT id, home, template, s.params
  FROM e8sm7_template_styles as s
  LEFT JOIN e8sm7_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
22. 1 × SELECT folder AS type, element AS name, params
  FROM e8sm7_extensions
23. 1 × SELECT id, rules
  FROM `e8sm7_viewlevels
24. 1 × SELECT `session_id`
  FROM `e8sm7_session`
25. 1 × SELECT b.id
  FROM e8sm7_usergroups AS a
  LEFT JOIN e8sm7_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
26. 1 × SELECT *
  FROM e8sm7_languages
27. 1 × SELECT a.rules
  FROM e8sm7_assets AS a
28. 1 × SELECT *
  FROM e8sm7_k2_attachments
29. 1 × SELECT `data`
  FROM `e8sm7_session`
30. 1 × SELECT *
  FROM e8sm7_k2_categories
31. 1 × SELECT *
  FROM e8sm7_k2_items
32. 1 × SELECT id
  FROM e8sm7_k2_categories
33. 1 × select *
  from e8sm7_iprice_curr

Прочие SQL-запросы:

1. 1 × UPDATE e8sm7_k2_items
  SET `hits` = (`hits` + 1)
2. 1 × SHOW FULL COLUMNS
  FROM `e8sm7_users
3. 1 × UPDATE `e8sm7_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610974217;s:18:\"session.timer.last\";i:1610974217;s:17:\"session.timer.now\";i:1610974217;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_ipricecalc\";O:8:\"stdClass\":5:{s:10:\"plugparams\";N;s:15:\"currproductsurl\";s:19:\"http://sibgals.com/\";s:7:\"pparams\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":193:{s:13:\"manageruserid\";s:3:\"764\";s:4:\"curr\";s:3:\"RUR\";s:10:\"finishtext\";s:29:\"Заказ отправлен\";s:10:\"showprices\";s:1:\"0\";s:17:\"zeropricecontract\";s:1:\"1\";s:7:\"defview\";s:1:\"0\";s:7:\"defsort\";s:0:\"\";s:10:\"defsortdir\";s:4:\"desc\";s:15:\"usestrongfilter\";s:1:\"0\";s:14:\"showcurrselect\";s:1:\"0\";s:16:\"showcatinsection\";s:1:\"1\";s:9:\"usepaging\";s:1:\"1\";s:11:\"showpagenum\";s:1:\"1\";s:10:\"numperpage\";s:2:\"40\";s:19:\"numperpageforseccat\";s:2:\"10\";s:7:\"warning\";s:0:\"\";s:12:\"addtocartqty\";s:1:\"0\";s:6:\"minqty\";s:1:\"0\";s:6:\"maxqty\";s:1:\"0\";s:7:\"stepqty\";s:1:\"1\";s:10:\"qtyenabled\";s:1:\"1\";s:13:\"qtylistvalues\";s:0:\"\";s:11:\"isaddtocart\";s:1:\"0\";s:10:\"enableajax\";s:1:\"1\";s:13:\"allowzeroitem\";s:1:\"1\";s:14:\"denyoutofstock\";s:1:\"0\";s:9:\"showavail\";s:1:\"3\";s:10:\"instocklow\";s:3:\"100\";s:11:\"newitemdays\";s:0:\"\";s:17:\"forceregistration\";s:1:\"0\";s:10:\"allowguest\";s:1:\"1\";s:15:\"showbreadcrumbs\";s:1:\"0\";s:11:\"maxfilesize\";s:0:\"\";s:11:\"enableredir\";s:1:\"0\";s:8:\"redirurl\";s:0:\"\";s:10:\"usecaptcha\";s:1:\"0\";s:15:\"usecaptchaorder\";s:1:\"1\";s:16:\"usecbintegration\";s:1:\"0\";s:17:\"excelexportfields\";a:1:{i:0;s:0:\"\";}s:10:\"decimalsep\";s:1:\".\";s:11:\"thousandsep\";s:1:\" \";s:10:\"weightunit\";s:2:\"kg\";s:12:\"weighdecimal\";s:1:\"2\";s:12:\"capacityunit\";s:0:\"\";s:11:\"simpleprice\";s:1:\"1\";s:7:\"usetabs\";s:1:\"0\";s:8:\"showisec\";s:1:\"1\";s:12:\"showisecdesc\";s:1:\"0\";s:8:\"showicat\";s:1:\"0\";s:12:\"showicatdesc\";s:1:\"0\";s:11:\"displaydesc\";s:1:\"0\";s:19:\"priceshowselectsort\";s:1:\"0\";s:19:\"priceshowselectview\";s:1:\"0\";s:15:\"showexcelexport\";s:1:\"0\";s:16:\"showheaderfilter\";s:1:\"0\";s:14:\"namefiltertype\";s:1:\"0\";s:9:\"iconphoto\";s:1:\"0\";s:10:\"showselect\";s:1:\"0\";s:10:\"showtocart\";s:1:\"0\";s:10:\"showaddall\";s:1:\"0\";s:12:\"showcheckall\";s:1:\"0\";s:13:\"showpagetotal\";s:1:\"0\";s:17:\"showsaveselection\";s:1:\"0\";s:13:\"showmakeorder\";s:1:\"0\";s:11:\"ithumbwidth\";s:0:\"\";s:12:\"ithumbheight\";s:0:\"\";s:11:\"deftemplate\";s:5:\"cart2\";s:17:\"catshowselectsort\";s:1:\"1\";s:17:\"catshowselectview\";s:1:\"1\";s:11:\"catshowicat\";s:1:\"1\";s:13:\"catshowtocart\";s:1:\"1\";s:13:\"catshowselect\";s:1:\"1\";s:15:\"showdropdowncat\";s:1:\"0\";s:18:\"showdescriptioncat\";s:1:\"1\";s:16:\"showcharactercat\";s:1:\"0\";s:14:\"showcommentcat\";s:1:\"0\";s:13:\"showunitprice\";s:1:\"0\";s:15:\"createimagelink\";s:1:\"1\";s:13:\"itemuselayout\";s:4:\"tabs\";s:15:\"itemusecomments\";s:1:\"0\";s:12:\"itemshowicat\";s:1:\"1\";s:14:\"itemshowselect\";s:1:\"1\";s:14:\"itemshowtocart\";s:1:\"1\";s:14:\"cartheadertext\";s:0:\"\";s:12:\"cartheaderid\";s:0:\"\";s:18:\"disableorderamount\";s:1:\"0\";s:11:\"showcompare\";s:1:\"0\";s:21:\"showsavechangesbutton\";s:1:\"1\";s:15:\"cartdisplaydesc\";s:1:\"2\";s:12:\"cartshowisec\";s:1:\"0\";s:12:\"cartshowicat\";s:1:\"0\";s:27:\"cartshowtotalbeforediscount\";s:1:\"0\";s:21:\"cartshowtotaldiscount\";s:1:\"0\";s:26:\"cartshowtotalafterdiscount\";s:1:\"0\";s:20:\"cartshowtotalwthttax\";s:1:\"0\";s:16:\"cartshowtotaltax\";s:1:\"0\";s:19:\"cartshowweighttotal\";s:1:\"0\";s:21:\"cartshowcapacitytotal\";s:1:\"0\";s:10:\"pruducturl\";s:0:\"\";s:12:\"isymboldelim\";s:1:\"/\";s:12:\"copyinfoprev\";s:1:\"1\";s:13:\"showorderdesc\";s:1:\"1\";s:13:\"showorderisec\";s:1:\"0\";s:13:\"showordericat\";s:1:\"0\";s:28:\"ordershowtotalbeforediscount\";s:1:\"0\";s:22:\"ordershowtotaldiscount\";s:1:\"0\";s:27:\"ordershowtotalafterdiscount\";s:1:\"0\";s:21:\"ordershowtotalwthttax\";s:1:\"0\";s:20:\"ordershowweighttotal\";s:1:\"0\";s:22:\"ordershowcapacitytotal\";s:1:\"0\";s:12:\"saveorderxml\";s:1:\"0\";s:7:\"xmlpath\";s:0:\"\";s:14:\"attachorderxml\";s:1:\"0\";s:10:\"attachbill\";s:1:\"0\";s:8:\"billview\";s:1:\"0\";s:12:\"emailsubject\";s:0:\"\";s:13:\"orderheaderid\";s:0:\"\";s:11:\"ordertextid\";s:0:\"\";s:13:\"orderfooterid\";s:0:\"\";s:13:\"sendordercust\";s:1:\"1\";s:14:\"sendordermanag\";s:1:\"1\";s:14:\"sendnotifycust\";s:1:\"1\";s:15:\"sendnotifymanag\";s:1:\"1\";s:13:\"decstockstate\";s:1:\"0\";s:13:\"incstockstate\";s:2:\"99\";s:12:\"allowpdfbill\";s:1:\"1\";s:12:\"allowactions\";s:1:\"1\";s:9:\"croporfit\";s:1:\"1\";s:7:\"ieffect\";s:1:\"2\";s:14:\"numgallerycols\";s:1:\"2\";s:15:\"smallthumbwidth\";s:0:\"\";s:16:\"smallthumbheight\";s:0:\"\";s:16:\"mediumthumbwidth\";s:0:\"\";s:17:\"mediumthumbheight\";s:0:\"\";s:15:\"largethumbwidth\";s:0:\"\";s:16:\"largethumbheight\";s:0:\"\";s:10:\"usepayment\";s:1:\"0\";s:10:\"successurl\";s:0:\"\";s:7:\"failurl\";s:0:\"\";s:13:\"globaltaxrate\";s:0:\"\";s:7:\"taxmode\";s:1:\"0\";s:10:\"globaldisc\";s:1:\"0\";s:9:\"userdisc1\";s:1:\"0\";s:9:\"userdisc2\";s:1:\"0\";s:9:\"userdisc3\";s:1:\"0\";s:9:\"userdisc4\";s:1:\"0\";s:9:\"userdisc5\";s:1:\"0\";s:11:\"cumuldiscid\";s:1:\"0\";s:10:\"bonusratio\";s:0:\"\";s:14:\"bonusroundrate\";s:0:\"\";s:14:\"importfilename\";s:10:\"index.html\";s:11:\"importscode\";s:0:\"\";s:13:\"celldelimiter\";s:1:\";\";s:13:\"textdelimiter\";s:1:\"\"\";s:12:\"eoldelimiter\";s:2:\"\\n\";s:15:\"importhasheader\";s:1:\"0\";s:9:\"removeall\";s:1:\"0\";s:17:\"usepricecsscolors\";s:1:\"1\";s:9:\"textcolor\";s:0:\"\";s:9:\"backcolor\";s:0:\"\";s:17:\"itemevenbackcolor\";s:0:\"\";s:16:\"itemoddbackcolor\";s:0:\"\";s:13:\"disctextcolor\";s:0:\"\";s:16:\"sectiontextcolor\";s:0:\"\";s:14:\"sectionbkcolor\";s:0:\"\";s:17:\"categorytextcolor\";s:0:\"\";s:15:\"categorybkcolor\";s:0:\"\";s:15:\"headertextcolor\";s:0:\"\";s:13:\"headerbkcolor\";s:0:\"\";s:14:\"totaltextcolor\";s:0:\"\";s:12:\"totalbkcolor\";s:0:\"\";s:13:\"desctextcolor\";s:0:\"\";s:11:\"descbkcolor\";s:0:\"\";s:12:\"delimbkcolor\";s:0:\"\";s:14:\"startfadecolor\";s:7:\"#fb9393\";s:12:\"endfadecolor\";s:7:\"#fdfdfd\";s:9:\"menu_text\";i:1;s:17:\"show_page_heading\";i:0;s:6:\"secure\";i:0;s:15:\"show_item_title\";s:1:\"1\";s:17:\"custom_item_color\";s:1:\"0\";s:10:\"item_color\";s:7:\"#666666\";s:9:\"sub_width\";s:3:\"200\";s:10:\"sub_margin\";s:1:\"5\";s:11:\"sub_padding\";s:1:\"5\";s:13:\"create_column\";s:1:\"0\";s:11:\"load_module\";s:1:\"0\";s:12:\"module_style\";s:4:\"none\";s:10:\"page_title\";s:14:\"Главная\";s:16:\"page_description\";s:0:\"\";s:11:\"page_rights\";s:0:\"\";s:6:\"robots\";s:0:\"\";s:8:\"payments\";a:1:{i:0;s:0:\"\";}}}s:11:\"cartbackurl\";s:19:\"http://sibgals.com/\";s:7:\"isearch\";N;}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:13:\"session.token\";s:32:\"02efecf8d5e858342b4e71ea9130f182\";s:16:\"com_mailto.links\";a:1:{s:40:\"a16f0c771a166e16b0db3f400ed408597c4b4146\";O:8:\"stdClass\":2:{s:4:\"link\";s:19:\"http://sibgals.com/\";s:6:\"expiry\";i:1610974217;}}}' , `time` = '1610974218'
4. 1 × SHOW FULL COLUMNS
  FROM `e8sm7_k2_items
5. 1 × SHOW FULL COLUMNS
  FROM `e8sm7_iprice_sections
6. 1 × INSERT INTO `e8sm7_session` (`session_id`, `client_id`, `time`)
  VALUES ('s4avou3b5vm1im7esd8d200k11', 0, '1610974217'
7. 1 × SHOW FULL COLUMNS
  FROM `e8sm7_k2_categories
8. 1 × DELETE
  FROM `e8sm7_session`