SELECT ID_module FROM kcm1_modules WHERE type = 'shop'
9.608268737793E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_active'
0.00011396408081055

SELECT de as text FROM kcm1_stringtable WHERE name = ?
0.0001070499420166

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_sidecart'
0.00011610984802246

SELECT de as text FROM kcm1_stringtable WHERE name = ?
0.00010204315185547

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_showmenu'
9.918212890625E-5

SELECT de as text FROM kcm1_stringtable WHERE name = ?
0.00010299682617188

SELECT * FROM kcm1_mod_shopaccountgroups WHERE standard = 1
0.00013399124145508

SELECT * FROM kcm1_mod_shopaccountgroups WHERE standard = 1
0.00010800361633301

SELECT * FROM kcm1_mod_shoporders WHERE ID_order = '-1'
0.00027298927307129

SELECT * FROM kcm1_mod_shoptotaltypes LEFT JOIN kcm1_mod_shoptotals ON ID_totaltype = totaltype_ID AND kcm1_mod_shoptotals.order_ID = '-1'
0.0003359317779541

SELECT *, (item_price * (1 + item_tax)) as item_pricetax FROM kcm1_mod_shoporderitems, kcm1_mod_shopunits WHERE order_ID = '-1' AND item_unit_ID = ID_unit ORDER BY item_division_ID ASC, ID_orderitem ASC
0.00027990341186523

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_assortment_startpage'
0.00012016296386719

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
0.00011515617370605

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
7.4148178100586E-5

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.5074691772461E-5

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.1975250244141E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_category1'
0.00011205673217773

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_category2'
9.6797943115234E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_category3'
0.00010180473327637

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_category4'
9.2983245849609E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_category5'
9.4890594482422E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_category6'
0.00011491775512695

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_page1'
0.00014400482177734

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_page2'
0.00012397766113281

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_page3'
0.00010108947753906

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_page4'
9.7036361694336E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_page5'
9.7036361694336E-5

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_menu_page6'
0.00014591217041016

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_search'
0.00010490417480469

SELECT de as text FROM kcm1_stringtable WHERE name = ?
0.00011086463928223

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = 0 AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00015401840209961

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '3' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00012898445129395

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
6.1988830566406E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
0.00010800361633301

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '5' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00011897087097168

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
4.9114227294922E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
0.0001220703125

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '10' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00011205673217773

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.1021575927734E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
9.608268737793E-5

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '9' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00010585784912109

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.0067901611328E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
0.00010991096496582

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '6' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00012707710266113

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.1975250244141E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
9.9897384643555E-5

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '2' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00011110305786133

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.1975250244141E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
0.00010108947753906

SELECT * FROM kcm1_mod_shop WHERE module_ID = '7' AND parent_ID = '7' AND status > 0 AND division_only = 0 ORDER BY order_ID ASC
0.00011587142944336

SELECT s.*, parent_ID FROM kcm1_pages, kcm1_stringtable s WHERE ID_page = '' AND url_fragment = name
5.1021575927734E-5

SELECT en as text FROM kcm1_stringtable WHERE name = ?
0.00010299682617188

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '3' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.00049901008605957

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '5' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.00040721893310547

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '10' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.00022006034851074

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '9' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.00018405914306641

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '6' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.00018119812011719

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '2' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.0001528263092041

SELECT COUNT(p.ID_product) FROM kcm1_mod_shopproducts p LEFT JOIN kcm1_mod_shopproductdisables d ON product_ID = ID_product AND (accountgroup_ID = '1') WHERE category_ID = '7' AND parent_ID = 0 AND status_product = 1 AND disable IS NULL ORDER BY order_ID ASC
0.00016689300537109

SELECT * FROM kcm1_module_options WHERE module_ID = '7' AND option_name = 'shop_assortment_level1'
0.00011897087097168

  • Assortment
  • SELECT * FROM kcm1_site_options WHERE option_name = 'search_color'
    9.2029571533203E-5

Shop-Menu
SELECT * FROM kcm1_socialmedia WHERE status_socialmedia > 0 AND type NOT IN ('email','print') ORDER BY ID_socialmedia ASC
0.0001981258392334

SELECT * FROM kcm1_socialmedia WHERE (status_share > 0) OR (status_socialmedia = 1 AND type = 'print') ORDER BY ID_socialmedia ASC
0.00011396408081055