Von der Fahrzeugpflege, über unsere KFZ-Fachwerkstatt, bis hin zur professionel...in Eberdingen
Die Car Parts Agency hilft bei der Beschaffung und Bestimmung von einfachen S...in Roding
Feinwuchten, Stroker Kits, FE Specialty, Shortblocks...in Kretz
![]() |
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
Der Marktplatz für US-Cars, Oldtimer, Tuning und Racing.
...in RodingDie Werkstatt...in Hagen
Custom Car Center...in Hagen im Bremischen
Freie Werkstatt, Autoteilehandel für Oldtimer, PKW...in Eschweiler
Ein ruhiger Pol in einer aufregenden Metropole. In angenehm ruhiger Lage, umgebe...in Berlin
Reifen namhafter Hersteller für sämtliche Pkw, Lkw und Motorräder. Felgen, Fa...in Bad Vilbel
Ihr Tacho-Spezialist mit dem guten Service...in Wehretal
Auto Radio Shop Fachhandel mit Einbau bei Landsberg. Wir sind die richtige Adres...in Hofstetten
Wir sind spezialisiert auf das Überarbeiten und Instandsetzen von V8 ZylinderkÃ...in Sehnde
Seit über 25 Jahren beschäftigen wir uns mit münzbetätigten Automaten besond...in Löhne
Auf unserer Website sehen Sie viele sehr spezielle und seltene USA Cars, Classic...in Emmerich am Rhein
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 ...
Groß-Enzersdorf Leopoldsdorf bei Wien Limbach Schwechat ...
Basel ...
Giebenach ...
Eschenbach Wittenbach ...
Untergiblen ...
Ulm ...
Pfäffikon ...
Naumburg ...
Hilden ...
Enns ...
Bad Abbach ...
{ "__default": { "session": { "counter": 1, "timer": { "start": 1702165727, "last": 1702165727, "now": 1702165727 } }, "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": "Goslar" } }
SELECT `data`
FROM `jqfh5_session`
WHERE `session_id` = X'6661333363363731346232313062376261613531343633323265336531396361'
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'6661333363363731346232313062376261613531343633323265336531396361'
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'6661333363363731346232313062376261613531343633323265336531396361', 1, 1702165727, 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 = 'Goslar.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\":\"7fe2894e7bf5c5a1bf7feaaa73fd60d7\"}'
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 = 'Goslar'
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 '%Goslar%')
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 '%Goslar%')
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 '%Goslar%')
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 '%Goslar%')
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 '%Goslar%')
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 |