Feinwuchten, Stroker Kits, FE Specialty, Shortblocks...in Kretz
Die Car Parts Agency hilft bei der Beschaffung und Bestimmung von einfachen S...in Roding
Von der Fahrzeugpflege, über unsere KFZ-Fachwerkstatt, bis hin zur professionel...in Eberdingen
![]() |
Feinwuchten, Stroker Kits, FE Specialty, Shortblocks...in Kretz
US-Car Werkstatt und Handel spezialisiert auf Oldtimer...in Pfaffenhofen an der Roth
Weltweiter Import von Ersatzteilen inkl. Zoll Abwicklung Service und Kundendie...in Wittislingen
Seit über 25 Jahren sind wir auf amerikanische Autos und Teile spezialisiert. U...in Bad Abbach
WER AUFHÖRT, BESSER ZU WERDEN, HAT AUFGEHÖRT, GUT ZU SEIN....in Dasing
33 Jahre Erfahrung mit US-Cars, Oldtimern und Exoten...in Weilheim in Oberbayern
Unser oberstes Gebot sind zufriedene Kunden. Freundlichkeit und Verlässlichkei...in Leopoldsdorf bei Wien
Von der Fahrzeugpflege, über unsere KFZ-Fachwerkstatt, bis hin zur professionel...in Eberdingen
CUSTOM CARS & CUSTOM CAMPER Bei LAPPI AUTOMOBILE dreht sich alles um Sie als un...in Enns
Der gute Service auch nach dem Kauf! Reparaturen ohne Terminabsprache eigene...in Billerbeck
KR-MOTORS – KFZ - Autowerkstatt in Höchstadt...in Höchstadt
Sie suchen einen vertrauensvollen und zuverlässigen Ansprechpartner, wenn es um...in Gera
Oldtimer Vermietung Unsere Oldtimer können Sie für Ihren individuellen Einsat...in Pastetten
IHRE ERSTE ADRESSE FÜR CHEVROLET, CORVETTE, CADILLAC, DODGE UND RAM...in Horgau
Ihre Autowerkstatt in Schwentinental Wolff's Revier Autoservice mit Biss...in Schwentinental
Wenn es um die Instandsetzung oder Wartung Ihres amerikanischen Oldtimers oder P...in Rudelzhausen
Wir beschäftigen uns seit 1982 ausschließlich mit klassischen Fahrzeugen. Unse...in Aschaffenburg
NEU: Erstmals können jetzt auch die Weiswandreifen für Oldtimer,Youngtimer,Mot...in Dachau
Ein Treffen mit James Dean am Tresen, mit Freunden vor der Juke Box oder geselli...in Bochum
Bei uspartsonline.de handelt es sich um eine reine Internetfirma ohne Ladengesc...in Hamburg
Wir kümmern uns um Ihr Auto - langfristig Holm Oldtimer-Restauration Waldkirch...in Waldkirch
Sind sie auf der Suche nach einem Werkstattservice für Ihr klassisches Fahrzeug...in Dresden
Wittislingen Adlkofen Alzenau Amerang Aschaffenburg Aschheim Augsburg Bad Tölz Bindlach/Berg Bobingen Cham Coburg Dachau Dasing Dettelbach Dittelbrunn Donaustauf Eching Eggolsheim Eisenberg Elchingen Erding Floß Freising Friedberg Fürth Furth im Wald Garching Gebenbach Großostheim Günzburg Gunzenhausen Haundorf Hausen Herrsching Hettenshausen Höchstadt Hof Hofstetten Hohenbrunn Holzkirchen Horgau Hösbach Illertissen Ismaning Kallmünz Kaufbeuren Kempten Kirchheim Kirchheim bei München Kitzingen Königsbrunn Konradsreuth Kösslarn Landsberg am Lech Landshut Mammendorf Marktheidenfeld Marktoberdorf Mering Miltenberg Moosburg an der Isar Moosinning Moosstetten Möttingen München Münster Naila Neu-Ulm Neumarkt-Sankt Veit Neunkirchen am Brand Neusäß Nürnberg Oberhaid Obermeitingen Oberschleißheim Olching Ottobrunn Pastetten Perkam Pettstadt Pfaffenhofen an der Roth Pilsting Pipinsried Puchheim Putzbrunn Pyrbaum Regensburg Regenstauf Reisbach Roding Röllbach Rudelzhausen Schierling Schlüsselfeld Schnaittenbach Senden Simbach Simmershofen Syrgenstein Unterbachern Untersteinach Waal Wechingen Weilheim in Oberbayern Westendorf Wildflecken Windach Wörth an der Isar Würzburg Zolling ...
Hamburg ...
Bad Schwartau Barsbüttel Bönningsted Dörphof Eggebek Glinde Heide Heikendorf Hennstedt Henstedt-Ulzburg Hohenlockstedt Kaltenkirchen Kiel Kronshagen Lensahn Lübeck Moorrege Nahe Neumünster Norderstedt Schenefeld Schwentinental Sieverstedt Wees Wentorf bei Hamburg Winsen ...
Allmannsweier Backnang Bad Friedrichshall Bad Saulgau Bad Waldsee Baden-Baden Bietigheim-Bissingen Böblingen Brackenheim Bühl Burgstetten Calw Dettenhausen Dettighofen Dettingen unter Teck Eberdingen Egenhausen Eggenstein-Leopoldshafen Endingen am Kaiserstuhl Engen Fellbach Freiburg Gaggenau Giengen Grünkraut Grünsfeld Gutach im Breisgau Heilbronn Herbrechtingen Hockenheim Ilsfeld Jettingen Kämpfelbach Karlsruhe Kirchheim unter Teck Klettgau Laichingen Laichingen / Suppingen Lauda-Königshofen Leinfelden-Echterdingen Mannheim Mössingen Oberndorf am Neckar Ohmden Oppenweiler Ostfildern Pforzheim Pleidelsheim Rammingen Reutlingen Ruppertshofen Sasbach Schönaich Schriesheim Sigmaringen Sindelfingen Sinsheim Stockach Stuttgart Tauberbischofsheim Tübingen Tuttlingen Ulm Unterkirnach Villingen-Schwenningen Waghäusel Waiblingen Waldkirch Weilheim an der Teck Weinstadt Welzheim Wendlingen Winnenden ...
Berlin Werneuchen ...
Abtsteinach Angelburg Babenhausen Bad Camberg Bad Homburg vor der Höhe Bad Vilbel Bensheim Darmstadt Dietzenbach Erlensee Frankenberg (Eder) Frankfurt / Main Frankfurt am Main Friedberg (Hessen) Friedrichsdorf Gernsheim Grävenwiesbach Grebenhain Griesheim Hadamar Hanau Hofheim-Wallau Idstein Karben Kassel Kronberg Lauterbach (Hessen) Lich Linsengericht Mengerskirchen Mörfelden-Walldorf Münster Neu-Isenburg Niedenstein Niederdorfelden Oberursel (Taunus) Ortenberg Petersberg Schotten Sinn Wehretal Wiesbaden Witzenhausen ...
Algermissen Apen Aurich Bissendorf Bockenem Bramsche Braunschweig Celle Delmenhorst Duderstadt Edemissen Emmerthal Emstek Garbsen Gehrden Gödenstorf Goslar Göttingen Hagen im Bremischen Hannover Hasbergen Hatten Hemmingen Isenbüttel Lauenau Lingen (Ems) Melle Neu Wulmstorf Neustadt am Rübenberge Osnabrück Raddestorf Salzgitter Sande Sehnde Sittensen Staufenberg Sulingen Syke Twist Uchte Wardenburg Wedemark Westergellersen Wietzendorf Wilhelmshaven Wolfsburg Wunstorf ...
Freienbach ...
Aachen Alsdorf Bad Salzuflen Bergheim Bergisch Gladbach Bergkamen Bielefeld Billerbeck Bochum Bonn Bornheim Bottrop Castrop-Rauxel Dinslaken Dormagen Dortmund Drensteinfurt Duisburg Düren Düsseldorf Emmerich am Rhein Engelskirchen Eschweiler Essen Euskirchen Gelsenkirchen Gladbeck Grevenbroich Hagen Herford Herne Herten Herzogenrath Jüchen Köln Königswinter Krefeld Lage Leichlingen (Rheinland) Lohmar Löhne Marsberg Moers Mülheim an der Ruhr Oberhausen Oerlinghausen Olfen Overath Paderborn Peterslahr Remscheid Rheinbach Rosendahl Schöppingen Schwalmtal Selm Senden Solingen Sprockhövel Steinheim Unna Velbert Verl Waldbröl Wegberg Weilerswist Werdohl Wesel Wiehl Wilnsdorf Wuppertal ...
Brunn Crivitz Groß Molzahn Güstrow Rostock Schwerin Sternberg Stralsund Warnemünde Wismar ...
Beelitz Cottbus Eberswalde Elsterwerda Frankfurt (Oder) Guben Lauchhammer Nauen Neuenhagen Potsdam Pritzwalk Rathenow Stahnsdorf Werneuchen Woltersdorf ...
Bitterfeld-Wolfen Dessau-Roßlau Halle Halle (Saale) Heiligenthal Lutherstadt Wittenberg Lützen Magdeburg Oebisfelde ...
Bad Berka Erfurt Fischbach/Rhön Gera Gotha Nordhausen Rudolstadt Saubach Schleid Schwabhausen Thonhausen Weinbergen ...
Algermissen Altenberg Apen Auerbach/Vogtland Aurich Berthelsdorf Bissendorf Bitterfeld-Wolfen Bockenem Bramsche Braunschweig Celle Chemnitz Delmenhorst Dessau-Roßlau Dresden Duderstadt Edemissen Emmerthal Emstek Garbsen Gehrden Gödenstorf Goslar Göttingen Grimma Hagen im Bremischen Halle Halle (Saale) Hannover Hasbergen Hatten Heiligenthal Hemmingen Isenbüttel Kamenz Lauenau Leipzig Lichtenau Lingen (Ems) Lutherstadt Wittenberg Lützen Magdeburg Meerane Meißen Melle Nauberg Neu Wulmstorf Neustadt am Rübenberge Nossen Oebisfelde Osnabrück Ostritz Ottendorf - Okrilla Pirna Raddestorf Radebeul Salzgitter Sande Sehnde Sittensen Staufenberg Strehla Sulingen Syke Twist Uchte Wardenburg Wedemark Weinböhla Werdau Westergellersen Wietzendorf Wilhelmshaven Wolfsburg Wunstorf Zeithain Zwenkau Zwickau ...
Bad Neuenahr-Ahrweiler Bitburg Hachenburg Jockgrim Klein-Winternheim Koblenz Kostheim Kretz Lahnstein Neustadt / Wstr. Neustadt an der Weinstraße Neuwied Offenbach an der Queich Saulheim Speicher Undenheim Zell ...
Neunkirchen Neustadt Saarbrücken Sulzbach/Saar Völklingen ...
Basel ...
Giebenach ...
Eschenbach Wittenbach ...
Untergiblen ...
Ulm ...
Pfäffikon ...
Naumburg ...
Hilden ...
Enns ...
Bad Abbach ...
{ "__default": { "session": { "counter": 1, "timer": { "start": 1702228465, "last": 1702228465, "now": 1702228465 } }, "registry": { "com_jbusinessdirectory": { "search": { "ordercol": null } } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "citySearch": "Schl\u00fcsselfeld" } }
SELECT `data`
FROM `jqfh5_session`
WHERE `session_id` = X'6266343065393634343133613764353433663134373833336536613666326135'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `jqfh5_session`
WHERE `session_id` = X'6266343065393634343133613764353433663134373833336536613666326135'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `jqfh5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6266343065393634343133613764353433663134373833336536613666326135', 1, 1702228465, 0, '', 0)
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jqfh5_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_extensions | NULL | ref | extension | extension | 82 | const | 33 | 1.00 | Using where |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `jqfh5_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM jqfh5_usergroups AS a
LEFT JOIN jqfh5_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jqfh5_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_extensions | NULL | ref | extension | extension | 82 | const | 176 | 0.40 | Using index condition; Using where; filesort wurde genutzt |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `enabled`
FROM `jqfh5_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:71 |
7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 jqfh5_menu AS m
LEFT JOIN jqfh5_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 1 | 5.00 | Using index condition; Using where; filesort wurde genutzt |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.m.component_id | 1 | 100.00 | Using where |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `jqfh5_jbusinessdirectory_companies` c
inner join ( select *, REPLACE(name,'-',' ') as companyName
FROM `jqfh5_jbusinessdirectory_companies`) bc
on bc.id = c.id
WHERE companyName = 'Schluesselfeld.html'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 753 | 100.00 | NULL |
1 | SIMPLE | jqfh5_jbusinessdirectory_companies | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.c.id | 1 | 100.00 | Using where |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/plugins/system/urltranslator/urltranslator.php:54 |
8 | plgSystemUrlTranslator->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jqfh5_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `jqfh5_extensions`
SET `params` = '{\"mediaversion\":\"9531ed2795ea8a4d9b4d83088dbc4af1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | jqfh5_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jqfh5_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_languages | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | 50.00 | Using where; filesort wurde genutzt |
# | Caller | File and line number |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM jqfh5_template_styles as s
LEFT JOIN jqfh5_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | 100.00 | NULL |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | usr_web1030_2.s.template,const | 1 | 5.00 | Using index condition; Using where |
# | Caller | File and line number |
---|---|---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT default_frontend_language
FROM jqfh5_jbusinessdirectory_applicationsettings
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_jbusinessdirectory_applicationsettings | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
7 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:55 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jqfh5_jbusinessdirectory_applicationsettings fas
inner join jqfh5_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join jqfh5_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fas | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | df | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
16 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:186 |
15 | getApplicationSettings() | JROOT/components/com_jbusinessdirectory/models/search.php:58 |
14 | JBusinessDirectoryModelSearch->__construct() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() | JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45 |
12 | Joomla\CMS\MVC\Factory\LegacyFactory->createModel() | JROOT/libraries/src/MVC/Controller/BaseController.php:559 |
11 | Joomla\CMS\MVC\Controller\BaseController->createModel() | JROOT/libraries/src/MVC/Controller/BaseController.php:728 |
10 | Joomla\CMS\MVC\Controller\BaseController->getModel() | JROOT/libraries/src/MVC/Controller/BaseController.php:616 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jqfh5_jbusinessdirectory_applicationsettings fas
inner join jqfh5_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join jqfh5_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fas | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | df | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:191 |
15 | getApplicationSettings() | JROOT/components/com_jbusinessdirectory/models/search.php:58 |
14 | JBusinessDirectoryModelSearch->__construct() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() | JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45 |
12 | Joomla\CMS\MVC\Factory\LegacyFactory->createModel() | JROOT/libraries/src/MVC/Controller/BaseController.php:559 |
11 | Joomla\CMS\MVC\Controller\BaseController->createModel() | JROOT/libraries/src/MVC/Controller/BaseController.php:728 |
10 | Joomla\CMS\MVC\Controller\BaseController->getModel() | JROOT/libraries/src/MVC/Controller/BaseController.php:616 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `jqfh5_jbusinessdirectory_companies`
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
16 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:31 |
15 | JTableCompany->__construct() | JROOT/libraries/src/Table/Table.php:328 |
14 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_jbusinessdirectory/models/search.php:75 |
13 | JBusinessDirectoryModelSearch->getTable() | JROOT/components/com_jbusinessdirectory/models/search.php:181 |
12 | JBusinessDirectoryModelSearch->getCompaniesByNameAndCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:32 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, if(FIND_IN_SET('featured_companies',features) ,1,0) as featured
from ( select cp.*, cp.name as companyName,cp.id as companyId1, cn.country_name as countryName,ct.name as typeName, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(DISTINCT cg.name separator '#') as categoryNames, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.id as mainCategoryId
from jqfh5_jbusinessdirectory_companies cp
left join jqfh5_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join jqfh5_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join jqfh5_jbusinessdirectory_categories bc
on bc.id=cp.mainSubcategory
left join jqfh5_jbusinessdirectory_countries cn
on cp.countryId=cn.country_id
left join jqfh5_jbusinessdirectory_company_types ct
on cp.typeId=ct.id
left join jqfh5_jbusinessdirectory_invoices inv
on inv.company_id=cp.id
left join jqfh5_jbusinessdirectory_packages p
on (inv.package_id=p.id ) or (p.id=cp.package_id
and p.price=0)
left join jqfh5_jbusinessdirectory_package_fields pf
on p.id=pf.package_id
where 1
and ((inv.state= 1
and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id
and p.days = 0))) or p.price=0)
and cp.city = 'Schlüsselfeld'
and cp.state=1
and cp.aproved = 2
group by cp.id
order by cp.name ) as slec
left join jqfh5_jbusinessdirectory_company_ratings cra
on cra.companyId=companyId1
group by companyId1
order by featured desc, companyName
LIMIT 0, 20
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | <derived2> | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 551570 | 100.00 | Using temporary; filesort wurde genutzt |
1 | PRIMARY | cra | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1088 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
2 | DERIVED | cp | NULL | ref | PRIMARY,idx_state,idx_approved,idx_package | idx_state | 2 | const | 743 | 9.97 | Using where; Using temporary; filesort wurde genutzt |
2 | DERIVED | cc | NULL | ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cp.id | 10 | 100.00 | Using index |
2 | DERIVED | cg | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cc.categoryId | 1 | 100.00 | NULL |
2 | DERIVED | bc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cp.mainSubcategory | 1 | 100.00 | NULL |
2 | DERIVED | cn | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cp.countryId | 1 | 100.00 | NULL |
2 | DERIVED | ct | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cp.typeId | 1 | 100.00 | NULL |
2 | DERIVED | inv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 21 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
2 | DERIVED | p | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 40.74 | Range checked for each record (index map: 0x1) |
2 | DERIVED | pf | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 29 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:237 |
13 | JTableCompany->getCompaniesByNameAndCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:195 |
12 | JBusinessDirectoryModelSearch->getCompaniesByNameAndCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:32 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select *
from jqfh5_jbusinessdirectory_categories
order by parentId,name
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jqfh5_jbusinessdirectory_categories | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 20 | 100.00 | filesort wurde genutzt |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:40 |
14 | JBusinessDirectorCategoryLib->getAllCategories() | JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:26 |
13 | JBusinessDirectorCategoryLib->getCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:215 |
12 | JBusinessDirectoryModelSearch->getSeachFilter() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select cp.id
from jqfh5_jbusinessdirectory_companies cp
left join jqfh5_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join jqfh5_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join jqfh5_jbusinessdirectory_invoices inv
on inv.company_id=cp.id
left join jqfh5_jbusinessdirectory_packages p
on (inv.package_id=p.id ) or (p.id=cp.package_id
and p.price=0)
where 1
and (cp.city like '%Schlüsselfeld%')
and cc.categoryId in ( 4,89,87,88)
and ((inv.state= 1
and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id
and p.days = 0))) or p.price=0)
and cp.state=1
and cp.aproved=2
group by cp.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cc | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 1002 | 40.00 | Using where; Using index; Using temporary; filesort wurde genutzt |
1 | SIMPLE | cg | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cc.categoryId | 1 | 100.00 | Using index |
1 | SIMPLE | cp | NULL | eq_ref | PRIMARY,idx_state,idx_approved,idx_package | PRIMARY | 4 | usr_web1030_2.cc.companyId | 1 | 10.93 | Using where |
1 | SIMPLE | inv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 21 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | p | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 40.74 | Range checked for each record (index map: 0x1) |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
14 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:304 |
13 | JTableCompany->getTotalCompaniesByNameAndCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:249 |
12 | JBusinessDirectoryModelSearch->getSeachFilter() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select cp.id
from jqfh5_jbusinessdirectory_companies cp
left join jqfh5_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join jqfh5_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join jqfh5_jbusinessdirectory_invoices inv
on inv.company_id=cp.id
left join jqfh5_jbusinessdirectory_packages p
on (inv.package_id=p.id ) or (p.id=cp.package_id
and p.price=0)
where 1
and (cp.city like '%Schlüsselfeld%')
and cc.categoryId in ( 90,91,3)
and ((inv.state= 1
and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id
and p.days = 0))) or p.price=0)
and cp.state=1
and cp.aproved=2
group by cp.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cc | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 1002 | 30.00 | Using where; Using index; Using temporary; filesort wurde genutzt |
1 | SIMPLE | cg | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cc.categoryId | 1 | 100.00 | Using index |
1 | SIMPLE | cp | NULL | eq_ref | PRIMARY,idx_state,idx_approved,idx_package | PRIMARY | 4 | usr_web1030_2.cc.companyId | 1 | 10.93 | Using where |
1 | SIMPLE | inv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 21 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | p | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 40.74 | Range checked for each record (index map: 0x1) |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
14 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:304 |
13 | JTableCompany->getTotalCompaniesByNameAndCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:249 |
12 | JBusinessDirectoryModelSearch->getSeachFilter() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select cp.id
from jqfh5_jbusinessdirectory_companies cp
left join jqfh5_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join jqfh5_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join jqfh5_jbusinessdirectory_invoices inv
on inv.company_id=cp.id
left join jqfh5_jbusinessdirectory_packages p
on (inv.package_id=p.id ) or (p.id=cp.package_id
and p.price=0)
where 1
and (cp.city like '%Schlüsselfeld%')
and cc.categoryId in ( 97,86,85,2)
and ((inv.state= 1
and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id
and p.days = 0))) or p.price=0)
and cp.state=1
and cp.aproved=2
group by cp.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cc | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 1002 | 40.00 | Using where; Using index; Using temporary; filesort wurde genutzt |
1 | SIMPLE | cg | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cc.categoryId | 1 | 100.00 | Using index |
1 | SIMPLE | cp | NULL | eq_ref | PRIMARY,idx_state,idx_approved,idx_package | PRIMARY | 4 | usr_web1030_2.cc.companyId | 1 | 10.93 | Using where |
1 | SIMPLE | inv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 21 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | p | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 40.74 | Range checked for each record (index map: 0x1) |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
14 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:304 |
13 | JTableCompany->getTotalCompaniesByNameAndCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:249 |
12 | JBusinessDirectoryModelSearch->getSeachFilter() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select cp.id
from jqfh5_jbusinessdirectory_companies cp
left join jqfh5_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join jqfh5_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join jqfh5_jbusinessdirectory_invoices inv
on inv.company_id=cp.id
left join jqfh5_jbusinessdirectory_packages p
on (inv.package_id=p.id ) or (p.id=cp.package_id
and p.price=0)
where 1
and (cp.city like '%Schlüsselfeld%')
and cc.categoryId in ( 93,92,1)
and ((inv.state= 1
and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id
and p.days = 0))) or p.price=0)
and cp.state=1
and cp.aproved=2
group by cp.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cc | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 1002 | 30.00 | Using where; Using index; Using temporary; filesort wurde genutzt |
1 | SIMPLE | cg | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cc.categoryId | 1 | 100.00 | Using index |
1 | SIMPLE | cp | NULL | eq_ref | PRIMARY,idx_state,idx_approved,idx_package | PRIMARY | 4 | usr_web1030_2.cc.companyId | 1 | 10.93 | Using where |
1 | SIMPLE | inv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 21 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | p | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 40.74 | Range checked for each record (index map: 0x1) |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
14 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:304 |
13 | JTableCompany->getTotalCompaniesByNameAndCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:249 |
12 | JBusinessDirectoryModelSearch->getSeachFilter() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
select cp.id
from jqfh5_jbusinessdirectory_companies cp
left join jqfh5_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join jqfh5_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join jqfh5_jbusinessdirectory_invoices inv
on inv.company_id=cp.id
left join jqfh5_jbusinessdirectory_packages p
on (inv.package_id=p.id ) or (p.id=cp.package_id
and p.price=0)
where 1
and (cp.city like '%Schlüsselfeld%')
and ((inv.state= 1
and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id
and p.days = 0))) or p.price=0)
and cp.state=1
and cp.aproved=2
group by cp.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cp | NULL | ref | PRIMARY,idx_state,idx_approved,idx_package | idx_state | 2 | const | 743 | 11.08 | Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | cc | NULL | ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cp.id | 10 | 100.00 | Using index |
1 | SIMPLE | cg | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web1030_2.cc.categoryId | 1 | 100.00 | Using index |
1 | SIMPLE | p | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 100.00 | Using join buffer (Block Nested Loop) |
1 | SIMPLE | inv | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 21 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
15 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:304 |
14 | JTableCompany->getTotalCompaniesByNameAndCategories() | JROOT/components/com_jbusinessdirectory/models/search.php:145 |
13 | JBusinessDirectoryModelSearch->getTotalCompaniesByNameAndCategory() | JROOT/components/com_jbusinessdirectory/models/search.php:161 |
12 | JBusinessDirectoryModelSearch->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:51 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jqfh5_jbusinessdirectory_applicationsettings fas
inner join jqfh5_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join jqfh5_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fas | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | df | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
15 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:186 |
14 | getApplicationSettings() | JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:14 |
13 | include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:55 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jqfh5_jbusinessdirectory_applicationsettings fas
inner join jqfh5_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join jqfh5_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fas | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | df | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:191 |
14 | getApplicationSettings() | JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:14 |
13 | include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:55 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jqfh5_jbusinessdirectory_applicationsettings fas
inner join jqfh5_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join jqfh5_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fas | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | df | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
17 | JDatabase->query() | JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:186 |
16 | getApplicationSettings() | JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:400 |
15 | JUtil::getApplicationSettings() | JROOT/components/com_jbusinessdirectory/include/companies-grid-view.php:13 |
14 | require_once JROOT/components/com_jbusinessdirectory/include/companies-grid-view.php | JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:199 |
13 | include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jbusinessdirectory/views/search/view.html.php:55 |
10 | JBusinessDirectoryViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jbusinessdirectory/controller.php:29 |
8 | JBusinessDirectoryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76 |
6 | require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |