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

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

1. SELECT `data`
  FROM `e8sm7_session`
  WHERE `session_id` = 'kbqae48ghki8i7kvgeej1st0r4'
2. SELECT `session_id`
  FROM `e8sm7_session`
  WHERE `session_id` = 'kbqae48ghki8i7kvgeej1st0r4'
  LIMIT 0, 1
3. INSERT INTO `e8sm7_session` (`session_id`, `client_id`, `time`)
  VALUES ('kbqae48ghki8i7kvgeej1st0r4', 0, '1610976524')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. 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
6. SELECT id, rules
  FROM `e8sm7_viewlevels`
7. 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
8. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
9. SELECT `enabled`
  FROM `e8sm7_extensions`
  WHERE `element` = 'com_akeeba'
  AND `type` = 'component'
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
11. 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
12. SELECT *
  FROM e8sm7_languages
  WHERE published=1
  ORDER BY ordering ASC
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 a.rules
  FROM e8sm7_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
15. 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
16. SELECT *
  FROM e8sm7_rsform_config
17. 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 13:28:45')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-18 13:28:45')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 526 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
18. SELECT *
  FROM e8sm7_acymailing_config
19. SELECT *
  FROM e8sm7_acymailing_list
  WHERE type = 'list'
  ORDER BY ordering ASC
20. SELECT *
  FROM `e8sm7_acymailing_fields` as a
  WHERE a.`published` = 1
  ORDER BY a.`ordering` ASC
21. 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 13:28:45' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-18 13:28:45' )
  AND i.catid IN(14)
  ORDER BY i.id DESC
  LIMIT 0, 3
22. 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 13:28:45' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-18 13:28:45' )
  AND i.catid IN(15)
  ORDER BY i.id DESC
  LIMIT 0, 1
23. SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_ipricecalc'
24. select *
  from e8sm7_iprice_curr
  where published=1
25. select *
  from e8sm7_iprice_pricefields
  where published=1
  ORDER BY ordering
26. 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
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
28. SHOW FULL COLUMNS
  FROM `e8sm7_iprice_sections`
29. SHOW FULL COLUMNS
  FROM `e8sm7_users`
30. SELECT *
  FROM `e8sm7_users`
  WHERE `id` = 763
31. 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
32. SELECT `description`, `gender`
  FROM e8sm7_k2_users
  WHERE userID=763
  LIMIT 0, 1
33. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM e8sm7_k2_users
  WHERE userID=763
34. select *
  from e8sm7_revslider_sliders
  where id=1
35. select *
  from e8sm7_revslider_slides
  where slider_id=1
  order by slide_order
36. select *
  from e8sm7_revslider_layer_animations
37. select *
  from e8sm7_revslider_layer_animations
38. select *
  from e8sm7_revslider_layer_animations
39. select *
  from e8sm7_revslider_layer_animations
40. SELECT `enabled`
  FROM `e8sm7_extensions`
  WHERE `element` = 'com_akeeba'
  AND `type` = 'component'
41. UPDATE `e8sm7_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610976524;s:18:\"session.timer.last\";i:1610976524;s:17:\"session.timer.now\";i:1610976524;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\":2:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}s:14:\"com_ipricecalc\";O:8:\"stdClass\":5:{s:10:\"plugparams\";N;s:15:\"currproductsurl\";s:29:\"http://sibgals.com/my-account\";s:7:\"pparams\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":195:{s:13:\"manageruserid\";s:3:\"764\";s:4:\"curr\";s:3:\"RUR\";s:10:\"finishtext\";s:29:\"Заказ отправлен\";s:10:\"showprices\";s:1:\"1\";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:\"1\";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:\"3\";s:19:\"priceshowselectsort\";s:1:\"1\";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:\"1\";s:10:\"showtocart\";s:1:\"1\";s:10:\"showaddall\";s:1:\"1\";s:12:\"showcheckall\";s:1:\"0\";s:13:\"showpagetotal\";s:1:\"1\";s:17:\"showsaveselection\";s:1:\"0\";s:13:\"showmakeorder\";s:1:\"1\";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:21:\"logindescription_show\";s:1:\"1\";s:22:\"logoutdescription_show\";s:1:\"1\";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:21:\"Мой аккаунт\";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:29:\"http://sibgals.com/my-account\";s:7:\"isearch\";N;}}}s:4:\"user\";O:5:\"JUser\":25:{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:13:\"session.token\";s:32:\"c2d61deda7ba7c0e94c0b829cc002860\";}' , `time` = '1610976526'
  WHERE `session_id` = 'kbqae48ghki8i7kvgeej1st0r4'

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

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

1. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM e8sm7_extensions
2. 4 × select *
  from e8sm7_revslider_layer_animation
3. 2 × 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
4. 2 × SELECT `enabled`
  FROM `e8sm7_extensions`
5. 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
6. 1 × SELECT *
  FROM `e8sm7_acymailing_fields` as a
7. 1 × select *
  from e8sm7_iprice_pricefields
8. 1 × SELECT *
  FROM `e8sm7_users`
9. 1 × select *
  from e8sm7_iprice_curr
10. 1 × SELECT `description`, `gender`
  FROM e8sm7_k2_users
11. 1 × select *
  from e8sm7_revslider_slides
12. 1 × select *
  from e8sm7_revslider_sliders
13. 1 × SELECT id, gender, description, image, url, `
  group`, plugins
  FROM e8sm7_k2_users
14. 1 × SELECT *
  FROM e8sm7_acymailing_list
15. 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
16. 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
17. 1 × SELECT folder AS type, element AS name, params
  FROM e8sm7_extensions
18. 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
19. 1 × SELECT id, rules
  FROM `e8sm7_viewlevels
20. 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
21. 1 × SELECT `session_id`
  FROM `e8sm7_session`
22. 1 × SELECT *
  FROM e8sm7_languages
23. 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
24. 1 × SELECT `data`
  FROM `e8sm7_session`
25. 1 × SELECT *
  FROM e8sm7_rsform_confi
26. 1 × SELECT b.rules
  FROM e8sm7_assets AS a
  LEFT JOIN e8sm7_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
27. 1 × SELECT a.rules
  FROM e8sm7_assets AS a
28. 1 × SELECT *
  FROM e8sm7_acymailing_confi

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

1. 1 × UPDATE `e8sm7_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610976524;s:18:\"session.timer.last\";i:1610976524;s:17:\"session.timer.now\";i:1610976524;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\":2:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}s:14:\"com_ipricecalc\";O:8:\"stdClass\":5:{s:10:\"plugparams\";N;s:15:\"currproductsurl\";s:29:\"http://sibgals.com/my-account\";s:7:\"pparams\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":195:{s:13:\"manageruserid\";s:3:\"764\";s:4:\"curr\";s:3:\"RUR\";s:10:\"finishtext\";s:29:\"Заказ отправлен\";s:10:\"showprices\";s:1:\"1\";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:\"1\";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:\"3\";s:19:\"priceshowselectsort\";s:1:\"1\";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:\"1\";s:10:\"showtocart\";s:1:\"1\";s:10:\"showaddall\";s:1:\"1\";s:12:\"showcheckall\";s:1:\"0\";s:13:\"showpagetotal\";s:1:\"1\";s:17:\"showsaveselection\";s:1:\"0\";s:13:\"showmakeorder\";s:1:\"1\";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:21:\"logindescription_show\";s:1:\"1\";s:22:\"logoutdescription_show\";s:1:\"1\";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:21:\"Мой аккаунт\";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:29:\"http://sibgals.com/my-account\";s:7:\"isearch\";N;}}}s:4:\"user\";O:5:\"JUser\":25:{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:13:\"session.token\";s:32:\"c2d61deda7ba7c0e94c0b829cc002860\";}' , `time` = '1610976526'
2. 1 × SHOW FULL COLUMNS
  FROM `e8sm7_users
3. 1 × SHOW FULL COLUMNS
  FROM `e8sm7_iprice_sections
4. 1 × INSERT INTO `e8sm7_session` (`session_id`, `client_id`, `time`)
  VALUES ('kbqae48ghki8i7kvgeej1st0r4', 0, '1610976524'