Ok, kleiner Fehler meinerseits... Hier das Ergebnis
Code: Alles auswählen
SELECT idartlang AS pk FROM `con_art_lang` WHERE NOW() < datestart AND datestart != '0000-00-00 00:00:00' AND datestart IS NOT NULL AND timemgmt = 1
geladen in 0.00073885917663574 Sekunden
SELECT idartlang AS pk FROM `con_art_lang` WHERE NOW() > datestart AND (NOW() < dateend OR dateend = '0000-00-00 00:00:00') AND online = 0 AND timemgmt = 1
geladen in 0.00038480758666992 Sekunden
SELECT idartlang AS pk FROM `con_art_lang` WHERE NOW() > dateend AND dateend != '0000-00-00 00:00:00' AND timemgmt = 1
geladen in 0.00031089782714844 Sekunden
SELECT idartlang, idart, time_move_cat, time_target_cat, time_online_move FROM `con_art_lang` WHERE NOW() > dateend AND dateend != '0000-00-00 00:00:00' AND timemgmt = 1 AND time_move_cat = 1
geladen in 0.00037097930908203 Sekunden
SELECT idclient FROM con_clients
geladen in 0.00022983551025391 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND (itemtype = 'clientsetting' AND itemid = 1) OR (itemtype = 'idclientslang' AND itemid = 0) OR (itemtype = 'idlang' AND itemid = 0)
geladen in 0.00024509429931641 Sekunden
SELECT * FROM `con_properties` WHERE itemtype = 'idcommunication' AND type = 'todo' AND name = 'reminderdate' AND value < 1406196982 AND value != 0 AND idclient=1
geladen in 0.0006248950958252 Sekunden
SELECT idcatart, idlang, idclient, visited, visitdate FROM con_stat
geladen in 0.00033903121948242 Sekunden
INSERT INTO con_stat_archive (archived, idcatart, idlang, idclient, visited, visitdate) VALUES ( 201406, 2, 1, 1, 0, '')
geladen in 0.089944839477539 Sekunden
INSERT INTO con_stat_archive (archived, idcatart, idlang, idclient, visited, visitdate) VALUES ( 201406, 5, 1, 1, 2, '')
geladen in 0.026283025741577 Sekunden
INSERT INTO con_stat_archive (archived, idcatart, idlang, idclient, visited, visitdate) VALUES ( 201406, 3, 1, 1, 0, '')
geladen in 0.01112699508667 Sekunden
INSERT INTO con_stat_archive (archived, idcatart, idlang, idclient, visited, visitdate) VALUES ( 201406, 4, 1, 1, 0, '')
geladen in 0.010754108428955 Sekunden
DELETE FROM con_stat
geladen in 0.010995149612427 Sekunden
SELECT A.idcatart, B.idclient, C.idlang FROM con_cat_art AS A INNER JOIN con_cat AS B ON A.idcat = B.idcat INNER JOIN con_cat_lang AS C ON A.idcat = C.idcat
geladen in 0.00073003768920898 Sekunden
INSERT INTO con_stat (idcatart, idlang, idclient, visited) VALUES ( 2, 1, 1, '0000-00-00 00:00:00')
geladen in 0.010193109512329 Sekunden
INSERT INTO con_stat (idcatart, idlang, idclient, visited) VALUES ( 5, 1, 1, '0000-00-00 00:00:00')
geladen in 0.010985136032104 Sekunden
INSERT INTO con_stat (idcatart, idlang, idclient, visited) VALUES ( 3, 1, 1, '0000-00-00 00:00:00')
geladen in 0.011039972305298 Sekunden
INSERT INTO con_stat (idcatart, idlang, idclient, visited) VALUES ( 4, 1, 1, '0000-00-00 00:00:00')
geladen in 0.010941982269287 Sekunden
OPTIMIZE TABLE con_actionlog
geladen in 0.13953304290771 Sekunden
OPTIMIZE TABLE con_actions
geladen in 0.15978503227234 Sekunden
OPTIMIZE TABLE con_area
geladen in 0.16660308837891 Sekunden
OPTIMIZE TABLE con_art_lang
geladen in 0.1444239616394 Sekunden
OPTIMIZE TABLE con_art_spec
geladen in 0.11844182014465 Sekunden
OPTIMIZE TABLE con_art
geladen in 0.20350790023804 Sekunden
OPTIMIZE TABLE con_cat_art
geladen in 0.1223828792572 Sekunden
OPTIMIZE TABLE con_cat_lang
geladen in 0.13351202011108 Sekunden
OPTIMIZE TABLE con_cat_tree
geladen in 0.16532397270203 Sekunden
OPTIMIZE TABLE con_cat
geladen in 0.13465690612793 Sekunden
OPTIMIZE TABLE con_clients_lang
geladen in 0.1220109462738 Sekunden
OPTIMIZE TABLE con_clients
geladen in 0.12210607528687 Sekunden
OPTIMIZE TABLE con_code
geladen in 0.18888306617737 Sekunden
OPTIMIZE TABLE con_communications
geladen in 0.11105418205261 Sekunden
OPTIMIZE TABLE con_container_conf
geladen in 0.12212705612183 Sekunden
OPTIMIZE TABLE con_container
geladen in 0.14077997207642 Sekunden
OPTIMIZE TABLE con_content
geladen in 0.17042899131775 Sekunden
OPTIMIZE TABLE con_dbfs
geladen in 0.11834907531738 Sekunden
OPTIMIZE TABLE con_file_information
geladen in 0.12607502937317 Sekunden
OPTIMIZE TABLE con_files
geladen in 0.18904495239258 Sekunden
OPTIMIZE TABLE con_frame_files
geladen in 0.13373589515686 Sekunden
OPTIMIZE TABLE con_frontendgroupmembers
geladen in 0.11804699897766 Sekunden
OPTIMIZE TABLE con_frontendgroups
geladen in 0.12594294548035 Sekunden
OPTIMIZE TABLE con_frontendpermissions
geladen in 0.1556978225708 Sekunden
OPTIMIZE TABLE con_frontendusers
geladen in 0.11826395988464 Sekunden
OPTIMIZE TABLE con_group_prop
geladen in 0.1147940158844 Sekunden
OPTIMIZE TABLE con_groupmembers
geladen in 0.1850278377533 Sekunden
OPTIMIZE TABLE con_groups
geladen in 0.12592506408691 Sekunden
OPTIMIZE TABLE con_inuse
geladen in 0.12216401100159 Sekunden
OPTIMIZE TABLE con_keywords
geladen in 0.11841583251953 Sekunden
OPTIMIZE TABLE con_lang
geladen in 0.17040300369263 Sekunden
OPTIMIZE TABLE con_lay
geladen in 0.13322401046753 Sekunden
OPTIMIZE TABLE con_mail_log
geladen in 0.12217497825623 Sekunden
OPTIMIZE TABLE con_mail_log_success
geladen in 0.12232184410095 Sekunden
OPTIMIZE TABLE con_meta_tag
geladen in 0.21084403991699 Sekunden
OPTIMIZE TABLE con_meta_type
geladen in 0.13322710990906 Sekunden
OPTIMIZE TABLE con_mod_translations
geladen in 0.15347194671631 Sekunden
OPTIMIZE TABLE con_mod
geladen in 0.181645154953 Sekunden
OPTIMIZE TABLE con_nav_main
geladen in 0.13311100006104 Sekunden
OPTIMIZE TABLE con_nav_sub
geladen in 0.13352394104004 Sekunden
OPTIMIZE TABLE con_news_groupmembers
geladen in 0.00031685829162598 Sekunden
OPTIMIZE TABLE con_news_groups
geladen in 0.00021219253540039 Sekunden
OPTIMIZE TABLE con_news_jobs
geladen in 0.00020098686218262 Sekunden
OPTIMIZE TABLE con_news_log
geladen in 0.0001990795135498 Sekunden
OPTIMIZE TABLE con_news_rcp
geladen in 0.00019001960754395 Sekunden
OPTIMIZE TABLE con_news
geladen in 0.00019216537475586 Sekunden
OPTIMIZE TABLE con_online_user
geladen in 0.19413709640503 Sekunden
OPTIMIZE TABLE con_phplib_active_sessions
geladen in 0.0003199577331543 Sekunden
OPTIMIZE TABLE con_user
geladen in 0.13692092895508 Sekunden
OPTIMIZE TABLE con_plugins
geladen in 0.14420390129089 Sekunden
OPTIMIZE TABLE con_plugins_rel
geladen in 0.26275014877319 Sekunden
OPTIMIZE TABLE con_properties
geladen in 0.12685179710388 Sekunden
OPTIMIZE TABLE con_rights
geladen in 0.27840113639832 Sekunden
OPTIMIZE TABLE con_stat_archive
geladen in 0.21026086807251 Sekunden
OPTIMIZE TABLE con_stat_heap_table
geladen in 0.00031805038452148 Sekunden
OPTIMIZE TABLE con_stat
geladen in 0.15098595619202 Sekunden
OPTIMIZE TABLE con_system_prop
geladen in 0.17783117294312 Sekunden
OPTIMIZE TABLE con_template_conf
geladen in 0.13325881958008 Sekunden
OPTIMIZE TABLE con_template
geladen in 0.13749408721924 Sekunden
OPTIMIZE TABLE con_type
geladen in 0.22211098670959 Sekunden
OPTIMIZE TABLE con_upl_meta
geladen in 0.13318204879761 Sekunden
OPTIMIZE TABLE con_upl
geladen in 0.13330078125 Sekunden
OPTIMIZE TABLE con_user_prop
geladen in 0.14441919326782 Sekunden
OPTIMIZE TABLE con_iso_639_2
geladen in 0.17789602279663 Sekunden
OPTIMIZE TABLE con_iso_3166
geladen in 0.1335141658783 Sekunden
OPTIMIZE TABLE con_search_tracking
geladen in 0.12196803092957 Sekunden
OPTIMIZE TABLE con_user
geladen in 0.22233104705811 Sekunden
SELECT pimplugincollection.idplugin FROM `con_plugins` AS pimplugincollection WHERE active = '1' ORDER BY executionorder asc
geladen in 0.00028085708618164 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10020'
geladen in 0.00017976760864258 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10030'
geladen in 0.0001990795135498 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10040'
geladen in 0.00017094612121582 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10050'
geladen in 0.00032210350036621 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10060'
geladen in 0.00023603439331055 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10070'
geladen in 0.00017690658569336 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10080'
geladen in 0.00017309188842773 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10090'
geladen in 0.00020790100097656 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10100'
geladen in 0.00017595291137695 Sekunden
SELECT * FROM `con_plugins` WHERE idplugin = '10110'
geladen in 0.00017499923706055 Sekunden
SELECT * FROM `con_system_prop`
geladen in 0.00079703330993652 Sekunden
SELECT * FROM `con_pi_shorturl` WHERE shorturl = ''
geladen in 0.00016212463378906 Sekunden
SELECT * FROM `con_clients` WHERE idclient = '1'
geladen in 0.00015997886657715 Sekunden
SELECT * FROM `con_properties` WHERE itemid='1' AND itemtype='clientsetting' ORDER BY type, name, value ASC
geladen in 0.00012707710266113 Sekunden
SELECT * FROM `con_lang` WHERE idlang = '1'
geladen in 0.00015997886657715 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idlang' AND itemid = '1' AND type = 'generator' AND name = 'xhtml'
geladen in 0.00050115585327148 Sekunden
SELECT idclientslang FROM con_clients_lang WHERE idclient = '1' AND idlang = '1'
geladen in 0.00015902519226074 Sekunden
SELECT * FROM `con_clients_lang` WHERE idclientslang = '1'
geladen in 0.00011587142944336 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idclientslang' AND itemid = '1' AND type = 'generator' AND name = 'xhtml'
geladen in 0.00036001205444336 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'clientsetting' AND itemid = '1' AND type = 'generator' AND name = 'xhtml'
geladen in 0.00034022331237793 Sekunden
SELECT A.* FROM `con_cat_art` AS A, `con_cat_tree` AS B, `con_cat` AS C, `con_cat_lang` AS D, `con_art_lang` AS E WHERE A.idcat = B.idcat AND B.idcat = C.idcat AND D.startidartlang = E.idartlang AND D.idlang = 1 AND E.idart = A.idart AND E.idlang = 1 AND idclient = 1 ORDER BY idtree ASC LIMIT 1
geladen in 0.00096511840820312 Sekunden
SELECT idartlang FROM `con_art_lang` WHERE idart = 4 AND idlang = 1
geladen in 0.00016403198242188 Sekunden
SELECT * FROM `con_art_lang` WHERE idartlang = '4'
geladen in 0.00014495849609375 Sekunden
SELECT a.idtplcfg FROM `con_cat_lang` AS a , `con_cat_art` AS b WHERE a.idcat=b.idcat AND b.idart=4 AND a.idlang=1 ;
geladen in 0.00040984153747559 Sekunden
SELECT idcatlang AS pk FROM `con_cat_lang` WHERE idcat = 2 AND idlang = 1
geladen in 0.00016593933105469 Sekunden
SELECT * FROM `con_cat_lang` WHERE idcatlang = '2'
geladen in 0.00010514259338379 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'clientsetting' AND itemid = '1' AND type = 'stats' AND name = 'tracking'
geladen in 0.0001518726348877 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idlang' AND itemid = '1' AND type = 'generator' AND name = 'basehref'
geladen in 0.00014400482177734 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idclientslang' AND itemid = '1' AND type = 'generator' AND name = 'basehref'
geladen in 0.00010514259338379 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'clientsetting' AND itemid = '1' AND type = 'generator' AND name = 'basehref'
geladen in 9.0122222900391E-5 Sekunden
SELECT * FROM `con_properties` WHERE itemid='1' AND itemtype='clientsetting' ORDER BY type, name, value ASC
geladen in 0.00016593933105469 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idlang' AND itemid = '1' AND type = 'frontend.no_outputbuffer' AND name = 'idart'
geladen in 0.00015592575073242 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idclientslang' AND itemid = '1' AND type = 'frontend.no_outputbuffer' AND name = 'idart'
geladen in 0.00010514259338379 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'clientsetting' AND itemid = '1' AND type = 'frontend.no_outputbuffer' AND name = 'idart'
geladen in 9.2029571533203E-5 Sekunden
SELECT * FROM `con_cat` WHERE idcat = '2'
geladen in 0.00015497207641602 Sekunden
SELECT * FROM `con_cat` WHERE idcat = '1'
geladen in 0.00011515617370605 Sekunden
SELECT idcatlang AS pk FROM `con_cat_lang` WHERE idcat = 1 AND idlang = 1
geladen in 0.0001068115234375 Sekunden
SELECT * FROM `con_cat_lang` WHERE idcatlang = '1'
geladen in 0.00010013580322266 Sekunden
SELECT b.type, a.typeid, a.value FROM `con_content` AS a, `con_type` AS b WHERE a.idartlang = 4 AND b.idtype = a.idtype ORDER BY a.idtype, a.typeid
geladen in 0.00050210952758789 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idlang' AND itemid = '1' AND type = 'navigation' AND name = 'idcat-home'
geladen in 0.00017094612121582 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'idclientslang' AND itemid = '1' AND type = 'navigation' AND name = 'idcat-home'
geladen in 0.00010585784912109 Sekunden
SELECT * FROM `con_properties` WHERE idclient = 1 AND itemtype = 'clientsetting' AND itemid = '1' AND type = 'navigation' AND name = 'idcat-home'
geladen in 8.8214874267578E-5 Sekunden
SELECT al.idartlang, al.idart, al.idlang as lang, al.urlname, cl.idcatlang, cl.idcat, cl.urlpath, ca.idcatart FROM con_art_lang AS al, con_cat_lang AS cl, con_cat_art AS ca WHERE al.idart = ca.idart AND ca.idcat = cl.idcat AND al.idlang = cl.idlang AND ((cl.idcat = 1 AND cl.idlang = 1 AND cl.startidartlang = al.idartlang))
geladen in 0.00015592575073242 Sekunden
SELECT al.idartlang, al.idart, al.idlang as lang, al.urlname, cl.idcatlang, cl.idcat, cl.urlpath, ca.idcatart FROM con_art_lang AS al, con_cat_lang AS cl, con_cat_art AS ca WHERE al.idart = ca.idart AND ca.idcat = cl.idcat AND al.idlang = cl.idlang AND ((cl.idcat = 1 AND cl.idlang = 1 AND cl.startidartlang = al.idartlang))
geladen in 0.00013303756713867 Sekunden