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
Ankauf und Inzahlungnahme von Corvettes und Exoten...in Mörfelden-Walldorf
Autowerkstatt & Tuning aus Meisterhand...in Miltenberg
Steron Cars bietet Ihnen: Technik, Service, Blech, Elektrik, Ersatzteile, H Kenn...in Eisenberg
Lugauer KFZ-Meisterbetrieb Spezialbetrieb für Automatikgetriebe...in München
n unserer Werkstatt bieten wir eine abwechslungsreiche Auswahl an hochwertigen u...in Dettighofen
Fachgeschäft und Online-Shop für Car-HiFi (Lautsprecher und Subwoofer), Naviga...in Saarbrücken
Wir sind ein junges Unternehmen und legen großen Wert auf ein direktes, vertrau...in Regensburg
Ihr Tacho-Spezialist mit dem guten Service...in Wehretal
Reparatur amerikanischer V2-Aggregate insbesondere Pan, Shovel, Evo Instandsetz...in Köln
Miss PeppeR - American-Food Lovers/Drinks...in Paderborn
TUNERSHOP - Tuning, Aluminiumfelgen, Alufelgen, Fahrwerke, TUEV Eintragungen u...in Naila
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": 1702224795,
"last": 1702224795,
"now": 1702224795
},
"token": "Bp2la3bhdOTl37O2ZwKrBCW8f3gGPPVc"
},
"registry": {
"com_jbusinessdirectory": {
"search_plz": {
"ordercol": "postalCode"
}
}
},
"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
}
}
}
SELECT `data`
FROM `jqfh5_session`
WHERE `session_id` = X'6236646463383034393962653664633761663565353739343235383339303435'
| 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'6236646463383034393962653664633761663565353739343235383339303435'
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'6236646463383034393962653664633761663565353739343235383339303435', 1, 1702224795, 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 = ''
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\":\"2e45309ed577ecf0e2d0c8a1a7bedd28\"}'
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_companies
where state=1
and postalCode like '8%'
order by postalCode desc
LIMIT 0, 20
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_companies | NULL | ref | idx_state | idx_state | 2 | const | 743 | 11.11 | Using index condition; Using where; filesort wurde genutzt |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jbusinessdirectory/models/search_plz.php:124 |
| 12 | JBusinessDirectoryModelSearch_plz->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search_plz/view.html.php:34 |
| 10 | JBusinessDirectoryViewSearch_plz->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 id, name
FROM jqfh5_jbusinessdirectory_categories
where 1
| 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 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jbusinessdirectory/models/search_plz.php:161 |
| 12 | JBusinessDirectoryModelSearch_plz->getCategoryName() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search_plz/view.html.php:36 |
| 10 | JBusinessDirectoryViewSearch_plz->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 COUNT(id)
FROM jqfh5_jbusinessdirectory_companies
where state=1
and postalCode like '8%'
order by postalCode desc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_companies | NULL | ref | idx_state | idx_state | 2 | const | 743 | 11.11 | Using where |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_jbusinessdirectory/models/search_plz.php:146 |
| 13 | JBusinessDirectoryModelSearch_plz->getTotal() | JROOT/components/com_jbusinessdirectory/models/search_plz.php:195 |
| 12 | JBusinessDirectoryModelSearch_plz->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jbusinessdirectory/views/search_plz/view.html.php:37 |
| 10 | JBusinessDirectoryViewSearch_plz->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_plz/tmpl/default.php:16 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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_plz/tmpl/default.php:16 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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 mainSubcategory
FROM jqfh5_jbusinessdirectory_companies
WHERE id=810
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_companies | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_jbusinessdirectory/router.php:369 |
| 22 | JbusinessdirectoryRouter->getCompCatId() | JROOT/components/com_jbusinessdirectory/router.php:53 |
| 21 | JbusinessdirectoryRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:50 |
| 14 | buildLink() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:108 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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 name
FROM jqfh5_jbusinessdirectory_categories
WHERE id=92
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_jbusinessdirectory/router.php:336 |
| 22 | JbusinessdirectoryRouter->getCatAlias() | JROOT/components/com_jbusinessdirectory/router.php:54 |
| 21 | JbusinessdirectoryRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:50 |
| 14 | buildLink() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:108 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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 name
FROM jqfh5_jbusinessdirectory_companies
WHERE id=810
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_companies | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_jbusinessdirectory/router.php:352 |
| 22 | JbusinessdirectoryRouter->getCompAlias() | JROOT/components/com_jbusinessdirectory/router.php:59 |
| 21 | JbusinessdirectoryRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:50 |
| 14 | buildLink() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:108 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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 mainSubcategory
FROM jqfh5_jbusinessdirectory_companies
WHERE id=867
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_companies | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_jbusinessdirectory/router.php:369 |
| 22 | JbusinessdirectoryRouter->getCompCatId() | JROOT/components/com_jbusinessdirectory/router.php:53 |
| 21 | JbusinessdirectoryRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:50 |
| 14 | buildLink() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:108 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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 name
FROM jqfh5_jbusinessdirectory_categories
WHERE id=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jqfh5_jbusinessdirectory_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| # | Caller | File and line number |
|---|---|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 23 | JDatabaseDriver->loadResult() | JROOT/components/com_jbusinessdirectory/router.php:336 |
| 22 | JbusinessdirectoryRouter->getCatAlias() | JROOT/components/com_jbusinessdirectory/router.php:54 |
| 21 | JbusinessdirectoryRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:50 |
| 14 | buildLink() | JROOT/components/com_jbusinessdirectory/views/search_plz/tmpl/default.php:108 |
| 13 | include JROOT/components/com_jbusinessdirectory/views/search_plz/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_plz/view.html.php:46 |
| 10 | JBusinessDirectoryViewSearch_plz->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 | </