{ "__default": { "session": { "counter": 1, "timer": { "start": 1714103577, "last": 1714103577, "now": 1714103577 }, "client": { "forwarded": "18.221.53.5" }, "token": "2NrA0WnZ7LwCqRuhotm5hrL7rlSUhacr" }, "registry": {}, "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 }, "from_dest": null, "to_dest": null, "booking_type": null, "address_from": null, "address_from_lat": null, "address_from_lng": null, "address_to": null, "address_to_lat": null, "address_to_lng": null, "pickup_poi": null, "dropoff_poi": null, "route_category_fld": null, "route_category": null, "route_category_dropoff_fld": null, "route_category_dropoff": null, "route_from": null, "route_to": null, "route_from_fld": null, "route_to_fld": null, "route_swapped": null, "fixed_route_id": null, "hourly_hr": null, "hourly_min": null, "shuttle_pickup_category_fld": null, "shuttle_pickup_catid": null, "shuttle_pickup": null, "shuttle_pickup_poi": null, "shuttle_dropoff_category_fld": null, "shuttle_dropoff_catid": null, "shuttle_dropoff": null, "shuttle_dropoff_poi": null, "shuttletime": null, "shuttle_route_id": null, "shuttle_passengers": null, "date1": null, "time1": null, "date2": null, "time2": null, "timestr1": null, "timestr2": null, "dropoff_date": null, "dropoff_time": null, "dropoff_date_time_str": null, "distance": null, "duration": null, "duration_seconds": null, "message": null, "begin": null, "end": null, "temp1": null, "temp2": null, "lat_long_from": null, "lat_long_to": null, "waypoints": null, "waypoints_lat": null, "waypoints_lng": null, "waypoints_stop_duration": null, "title": null, "name": null, "surname": null, "email": null, "phone": null, "receive_sms": null, "returnjurney": null, "return_wait_hr": null, "return_wait_discount": null, "price": null, "prepay": null, "flat_cost": null, "percentage_cost": null, "percentage_vat": null, "selected_extras": null, "total_extra_price": null, "return_extra_price": null, "poi_additional_charges": null, "first_extra_price": null, "passengers": null, "infantseats": null, "chseats": null, "boosterseats": null, "suitcases": null, "selpassengers": null, "selsuitcases": null, "selinfantseats": null, "selchildseats": null, "selboosterseats": null, "selluggage": null, "selcarry": null, "vehicle_id": null, "vehicletype": null, "tb_paymentmethod_id": null, "payment_post_data": null, "PickupAddr1": null, "PickupAddr4": null, "order_copy_users": null, "gratuity_amt": null, "gratuity_amttype": null, "gratuity_percent_value": null, "admin_wizard": null, "shared_rides_seat": null, "shared_parent_oid": null, "next_datetime_str": null, "second_purchase_percentage": null, "wait_time_flat_charge": null, "cartype": null, "base_pickup_distance": null, "base_pickup_duration": null, "base_pickup_price": null, "base_pickup_price_calc": null, "dropoff_base_distance": null, "dropoff_base_duration": null, "dropoff_base_price": null, "dropoff_base_price_calc": null, "carbasepricesdata": null, "tour_id": null, "tour_title": null, "tour_period": null, "tour_pickup_poi": null, "tour_pickup_zone_id": null, "tour_pickup_address": null, "tour_pickup_address_lat": null, "tour_pickup_address_lng": null, "tour_pickup_location": null, "TBFCompanyConfig": { "distance_unit": "mile", "restrict_time": ".5", "date_format": "dd-mm-yy", "datepicker_type": "jquery", "time_format": "24hr", "load_current_date": "1", "show_address_tab": "1", "show_from_poi": "1", "show_from_address": "1", "show_to_poi": "1", "show_to_address": "1", "show_offers_tab": "1", "enable_route_swap": "0", "show_poi_categories": "1", "show_hourly_tab": "0", "show_daily_hire": "0", "show_shuttles_tab": "0", "show_poi_categories_shuttle": "0", "show_shared_rides_tab": "1", "show_tours_tab": "0", "default_tab": "address", "default_adult_seat": "1", "show_passengers_select": "1", "show_suitcase_select": "1", "invoice_title": "taxi_booking", "enable_captcha": "1", "combine_car_type": "1", "display_car_types": "1", "show_cartype_list": "0", "load_all_cars": 0, "booking_cancellation_allowed": "0", "booking_cancellation_prior_hrs": 0, "company_id": 37, "show_price": "1", "auto_approve_free_order": "0", "debug_price_calculation": "1", "roundup_price": "whole", "cost_per_call": "0", "minmil": "1", "minprice": "2.75", "show_infant_select": "0", "infant_seat_price": "5", "show_child_select": "0", "child_seat_price": "5", "show_booster_select": "0", "booster_seat_price": "", "currency": "GBP", "currency_symbol": "£", "price_per_unit_distance": "1.5", "enable_charge_per_min": "1", "charge_per_min": ".25", "show_return_option": "1", "discount": "0", "show_return_extras": "1", "wait_time_return_discount": "0", "price_calculation_cumulative": "0", "enable_gratuity": "0", "enable_gratuity_flat": "1", "distance_prices": [], "cumulative_distance_prices": [], "return_discounts": [], "gratuities": [], "api_key": "", "api_server_key": "", "api_client_id": "", "api_client_signature": "", "gmap_api_avoids": [ "tolls" ], "enable_stops": "1", "show_stop_poi": "1", "show_stop_address": "1", "max_stop_time": "4", "stop_duration_interval": "5", "stops_charge_per_min": ".15", "optimize_stops": "1", "booking_company_name": "A1LUX", "company_privacy_policy_url": "https://google.com", "company_logo": "images/tbsaas/logo/a1lux/drivenot.jpg", "is_logo_changed": "0", "booking_notification_email": "norrie@a1lux.co.uk", "base_timezone": "Europe/London", "default_country": [ "222" ], "default_city": "cumnock", "frontend_map_center": "company_location", "contact_calling_code": "44", "contact_phone": "7720344065", "operation_area_vertices": "[[55.56553246285937,-4.813085469726502],[55.53212680676458,-4.715581807617127],[55.48935725023424,-4.700475606445252],[55.446541208848245,-4.693609151367127],[55.39276075838841,-4.708715352539002],[55.195134595430446,-5.139757070068299],[54.92082711377657,-5.263181600097596],[54.85259865071311,-5.044742497924744],[54.973868577730244,-4.848276052001893],[55.30296385752506,-4.41139784765619],[55.380669568214124,-4.179654988769471],[55.356476095551244,-3.895727071289002],[55.44615175881097,-4.06258192968744],[55.50005399628183,-3.8892039389647834],[55.58804583142145,-3.770757588867127],[55.53931530406777,-3.918729695800721],[55.577567076061214,-3.8771876425780647],[55.59202314498038,-3.863969716552674],[55.61888370403897,-3.8782176108397834],[55.65037535332159,-3.992715749267518],[55.65395895175695,-4.115453633789002],[55.74131648519245,-4.08129301977533],[55.739335450774405,-4.178195867065369],[55.7978301967938,-4.114037427429139],[55.92554629886123,-4.2558726401366584],[55.918957636705294,-4.5862349600829475],[55.73339174412621,-4.974275502685487],[55.65976949530732,-4.879690083984315]]", "pickup_in_area": "0", "dropoff_in_area": "0", "pickup_dropoff_in_area": "0", "base_lat": "55.461451", "base_long": "-4.269699", "calculate_base_pickup": "1", "base_pickup_special_routes": "price_time", "base_pickup_price_type": "distance", "base_pickup_price": ".50", "milage_charging_base_pickup": "3", "calculate_dropoff_base": "0", "base_dropoff_special_routes": "price_time", "dropoff_base_price_type": "distance", "dropoff_base_price": "0", "milage_charging_dropoff_base": "0", "time_after_each_booking": "0", "email_whitelist_added": "1", "additional_emails": "", "send_order_copy": "0", "send_drivers_upcoming_reminders": "1", "send_customers_upcoming_reminders": "1", "send_admins_upcoming_reminders": "1", "use_smtp": "1", "smtpauth": "1", "smtpsecure": "ssl", "smtpport": "465", "smtpuser": "norrie@a1lux.co.uk", "smtppass": "5l83sqrfUSKsWUxb586wOXAxpbCR/cQKu0aBgJxxgJo=", "smtphost": "smtp.ukservers.net", "header_logo": "", "header_info": { "en-GB": "<div style=\"text-align: center;\"><span style=\"font-size: 12pt;\">Thank you for booking your transport with us.<br /></span>\u00a0<span style=\"font-size: 12pt;\">\u00a0All details as requested are listed below any additions to the itinerary below will result in the whole hire being metered and any discount applied will be lost.<br /><br /></span></div>\r\n<div style=\"text-align: center;\"><span style=\"font-size: 18pt; background-color: #ffffff; color: #ff0000;\">Please check<em><strong> ALL</strong></em> the details below\u00a0and call 01290 430099 straight away if there are any errors.<br /><br />mistakes if not sorted before your hire <em><strong>will</strong></em> incur additional charges if not rectified.</span></div>" }, "contact_info": { "en-GB": "<p><br /><br /><br /></p>\r\n<p><span style=\"font-size: 12pt;\">call 01290430099 to confirm your hire 48 hours before you travel.</span>\u00a0</p>\r\n<p><br />As with all transport we are only able to meet your booking times if we are not delayed by events outwith our control, \u00a0we will always try\u00a0to be on time, however if we are delayed by events not within our control we will contact you and let you know what time your vehicle will turn up. \u00a0we also reserve the right to substitute other vehicles that can accommodate the amount of people you are carrying. \u00a0<br /><br /><span style=\"font-size: 12pt; background-color: #ff9900;\">Airport returns.\u00a0</span><br />please supply us with details of your return flights including departure airport, flight number and expected arrival time. \u00a0delays in flights are a regular\u00a0event, please dont worry we can track your flight and still collect you on time. \u00a0<br /><br /><span style=\"text-decoration: underline;\"><strong>If you supply us with the wrong Information we will charge you the full price of a 1 way transfer from your chosen airport, and is subject to availability.</strong></span></p>\r\n<p>\u00a0</p>\r\n<p>Please do do not reply to this email as it comes from an un monitored email address. \u00a0If you wish to email me please use norrie@a1lux.co.uk</p>\r\n<p style=\"text-align: left;\">Norrie Donis</p>\r\n<p style=\"text-align: left;\">a1lux minibuses<br /><a href=\"http://www.a1lux.co.uk\" rel=\"alternate\">www.a1lux.co.uk</a></p>" }, "use_terms": "0", "terms_conditions": { "it-IT": "", "en-GB": "", "fr-FR": "" }, "booking_form_design": "design2", "booking_form_bgcolor": "#006599", "booking_form_active_tab_color": "#006599", "booking_form_inactive_tab_color": "#1aa1bf", "booking_form_header_tabs_fontcolor": "#ffffff", "booking_form_fontcolor": "#ffffff", "booking_form_boxcolor": "#2d2d2d", "booking_form_boxes_fontcolor": "#ffffff", "other_steps_bgcolor": "#ffffff", "other_steps_fontcolor": "#999999", "booking_form_btncolor": "#1aa1bf", "bg_color_opacity": "1", "highlights_color": "#1aa1bf", "highlights_color_opacity": "1", "shared_rides_calendar_bgcolor": "#ffffff", "shared_rides_calendar_fontcolor": "#000000", "shared_rides_calendar_linkscolor": "#ff0000", "frontend_cars_default_display": "grid", "show_booking_summary_step2": "1", "show_grid_list_block_step2": "1", "show_time_selection": "1", "show_trip_duration_distance": "1", "login_exit_url": "", "booking_form_url": "", "frontend_fields_vertical_gap": "15", "frontend_bottom_totals_position": "right", "show_checkout_details": "1", "show_map_address": "1", "show_map_offers": "1", "show_map_shuttles": "0", "show_map_in_popup_only": 1, "show_map_on_desktop": 0, "show_map_on_mobile": 0, "map_height": "450", "map_zoom": "10", "dir_height": "0", "order_thanks_show_upcoming_events": "1", "send_user_sms": "1", "clickatell_api_id": "3554397", "clickatell_api_username": "a1luxtravel", "clickatell_api_password": "Ayeready99", "sms_default_country": "222", "country_calling_code": "", "clickatell_sender_id": "a1lux", "new_order_admin_notification_type": "notification", "clickatell_api_version": "old", "orders_default_sorting": "a.datetime1 desc", "send_sms_option_selected": 0, "offer_next_available_time": 1, "shared_rides_infant_seat_discount_enabled": 0, "shared_rides_infant_seat_discount_amount": 0, "shared_rides_child_seat_discount_enabled": 0, "shared_rides_child_seat_discount_amount": 0, "shared_rides_booster_seat_discount_enabled": 0, "shared_rides_booster_seat_discount_amount": 0, "fixed_fares_infant_seat_discount_enabled": 0, "fixed_fares_infant_seat_discount_amount": 0, "fixed_fares_child_seat_discount_enabled": 0, "fixed_fares_child_seat_discount_amount": 0, "fixed_fares_booster_seat_discount_enabled": 0, "fixed_fares_booster_seat_discount_amount": 0, "send_order_pdf_link": 1, "orders_default_list_limit": 20, "new_order_default_status": 1, "new_order_customer_notification_type": "notification", "email_pdf_show_dropoff_datetime": 0, "show_price_driver": 1, "send_sms_order_status_change": 0, "show_country_codes": 1, "show_min_dropdown": 1, "install_app_btn_bg_color": "#066706", "install_app_btn_font_color": "#ffffff", "install_app_btn_font_size": 13, "install_app_btn_border_color": "#ffffff", "install_app_btn_border_radius": 3, "google_analytics_code": "", "facebook_pixel_code": "", "enable_aboutus": 0, "enable_ourfleet": 0, "trial_subscriber": 1, "has_paid_subscr_own_api_keys": 1 }, "tbsaas_company_id": 37, "TBFCompanyObject": { "id": "37", "title": "A1LUX", "alias": "a1lux", "base_url": "http://booking.drivenot.com/company/a1lux", "short_url": "http://goo.gl/9N5BeM", "short_url_https": "https://goo.gl/6KU3iD", "booking_company_name": "A1LUX", "booking_notification_email": "norrie@a1lux.co.uk", "default_country": "222", "default_city": "cumnock", "base_timezone": "Europe/London", "company_logo": "images/tbsaas/logo/a1lux/drivenot.jpg", "contact_calling_code": "44", "contact_phone": "7720344065", "text": "", "drivenot_integrated": "1", "created": "2015-07-22 14:55:40", "created_by": "0", "modified": "2017-08-21 05:00:58", "modified_by": "0", "published": "0", "ordering": "0", "checked_out": "0", "checked_out_time": "0000-00-00 00:00:00", "default_language": "en-GB", "first_warning_sent_date": "2018-06-26 08:57:37", "last_warning_sent_date": "0000-00-00 00:00:00", "car_min_passenger": null, "car_max_passenger": null, "car_min_suitcase": null, "car_max_suitcase": null, "car_max_booster": null, "car_max_child": null, "car_max_infant": null, "default_location_lat": null, "default_location_lng": null, "isCompanyBookNowBtnEnabled": null }, "booking_form_design": "design2" } }
SELECT `data`
FROM `zlaw_session`
WHERE `session_id` = X'6b6d61346a766139746170633634716f75647232763774393866'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_session | const | PRIMARY | PRIMARY | 194 | const | 1 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 1.92 ms |
Preparing | 0.03 ms |
Executing | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | 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 `zlaw_session`
WHERE `session_id` = X'6b6d61346a766139746170633634716f75647232763774393866'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.09 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Executing | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | 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 `zlaw_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6b6d61346a766139746170633634716f75647232763774393866', 1, 1714103577, 0, '', 0)
Status | Duration |
---|---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init for update | 0.02 ms |
Update | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
Update | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 3.25 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | 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 `zlaw_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_extensions | ref | extension | extension | 82 | const | 56 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.11 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 3.52 ms |
End of update loop | 0.04 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | 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 `zlaw_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | 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 zlaw_usergroups AS a
LEFT JOIN zlaw_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.06 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.09 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | 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 zlaw_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_extensions | ref | extension | extension | 82 | const | 291 | Using index condition; Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 1.27 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | 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 `value`
FROM `zlaw_admintools_storage`
WHERE `key` = 'cparams'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_admintools_storage | const | PRIMARY | PRIMARY | 402 | const | 1 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.11 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_admintools/models/storage.php:99 |
10 | AdmintoolsModelStorage->load() | JROOT/administrator/components/com_admintools/models/storage.php:49 |
9 | AdmintoolsModelStorage->getValue() | JROOT/plugins/system/admintools/admintools/main.php:289 |
8 | plgSystemAdmintools->workaroundIP() | JROOT/plugins/system/admintools/admintools/main.php:81 |
7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
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 *
FROM `zlaw_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_admintools_wafexceptions | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
10 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/admintools/admintools/main.php:526 |
9 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT/plugins/system/admintools/admintools/main.php:447 |
8 | plgSystemAdmintools->loadWAFExceptions() | JROOT/plugins/system/admintools/admintools/main.php:90 |
7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
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 *
FROM zlaw_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_languages | ALL | idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.21 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
8 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:66 |
7 | PlgSystemTBFLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
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 `element`,`name`,`client_id`,`extension_id`
FROM `zlaw_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_extensions | ref | extension | extension | 82 | const | 24 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.05 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.20 ms |
End of update loop | 0.01 ms |
Query end | 0.04 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
9 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/administrator/components/com_languages/helpers/multilangstatus.php:100 |
8 | MultilangstatusHelper::getSitelangs() | JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:77 |
7 | PlgSystemTBFLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
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 |
SHOW VARIABLES LIKE "collation_database"
Status | Duration |
---|---|
Starting | 0.15 ms |
Opening tables | 0.08 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Filling schema table | 1.23 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/libraries/joomla/database/driver/mysqli.php:345 |
11 | JDatabaseDriverMysqli->getCollation() | JROOT/plugins/system/admintools/feature/utf8mb4.php:28 |
10 | AtsystemFeatureUtf8mb4->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:685 |
9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:118 |
8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
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 *
FROM `zlaw_admintools_ipautoban`
WHERE `ip` = '18.221.53.5'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.01 ms |
Executing | 0.12 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/plugins/system/admintools/feature/autoipfiltering.php:32 |
10 | AtsystemFeatureAutoipfiltering->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:685 |
9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:118 |
8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
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 *
FROM `zlaw_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('')
AND `view` IN('')
AND `task` IN('')
GROUP BY `query`
ORDER BY `query` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_admintools_wafblacklists | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using temporary; Using filesort |
Status | Duration |
---|---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.02 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/admintools/feature/wafblacklist.php:65 |
10 | AtsystemFeatureWafblacklist->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:685 |
9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:118 |
8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
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 zlaw_menu AS m
LEFT JOIN zlaw_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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 744 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.18 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.04 ms |
Creating sort index | 1.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:104 |
8 | PlgSystemTBFLanguageFilter->onAfterInitialise() | 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:668 |
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 id
FROM zlaw_affiliate_tracker_accounts
WHERE id = 0
AND publish = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Executing | 0.11 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:45 |
8 | plgSystemAffiliate_tracker->onAfterInitialise() | 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:668 |
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 `manifest_cache`
FROM `zlaw_extensions`
WHERE `type` = 'component'
AND `name` = 'com_ats'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_extensions | ref | extension | extension | 82 | const | 56 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.10 ms |
Optimizing | 0.03 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.36 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/libraries/fof30/Container/Container.php:787 |
11 | FOF30\Container\Container->getDefaultMediaVersion() | JROOT/libraries/fof30/Container/Container.php:675 |
10 | FOF30\Container\Container->__construct() | JROOT/libraries/fof30/Container/Container.php:159 |
9 | FOF30\Container\Container::makeInstance() | JROOT/libraries/fof30/Container/Container.php:140 |
8 | FOF30\Container\Container::getInstance() | JROOT/components/com_ats/router.php:16 |
7 | require_once JROOT/components/com_ats/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
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 `manifest_cache`
FROM `zlaw_extensions`
WHERE `type` = 'component'
AND `name` = 'com_ats'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_extensions | ref | extension | extension | 82 | const | 56 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.36 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/libraries/fof30/Container/Container.php:787 |
11 | FOF30\Container\Container->getDefaultMediaVersion() | JROOT/libraries/fof30/Container/Container.php:675 |
10 | FOF30\Container\Container->__construct() | JROOT/libraries/fof30/Container/Container.php:290 |
9 | FOF30\Container\Container::makeInstance() | JROOT/libraries/fof30/Container/Container.php:140 |
8 | FOF30\Container\Container::getInstance() | JROOT/components/com_ats/router.php:16 |
7 | require_once JROOT/components/com_ats/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
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 `zlaw_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.14 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.12 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.17 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | 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 `zlaw_extensions`
SET `params` = '{\"mediaversion\":\"6dbef69b8a6e14d7704810d2b621ca82\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init for update | 0.09 ms |
Updating | 0.07 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 3.61 ms |
Closing tables | 0.04 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | 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 id, home, template, s.params
FROM zlaw_template_styles as s
LEFT JOIN zlaw_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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | appcrbgnfx.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.09 ms |
Executing | 0.01 ms |
Sending data | 0.22 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | 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 text
FROM zlaw_tbsaas_configs
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_configs | ref | idx_company | idx_company | 4 | const | 9 |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.22 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.04 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.04 ms |
Statistics | 2.18 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
Sending data | 1.03 ms |
End of update loop | 0.02 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/classes/booking.helper.php:3081 |
10 | booking_helper::config() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:54 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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,user_id,name,email,phone,language,app_authorization_token
FROM zlaw_tbsaas_users
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_users | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12158 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.02 ms |
Opening tables | 2.15 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.12 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 91.72 ms |
End of update loop | 0.06 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/company.helper.php:493 |
11 | company_helper::getCompanyMainAdmin() | JROOT/components/com_tbsaas/classes/booking.helper.php:3185 |
10 | booking_helper::config() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:54 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 TABLES
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Checking permissions | 0.92 ms |
Executing | 0.01 ms |
Sending data | 0.33 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
24 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
23 | JDatabaseDriverMysqli->getTableList() | JROOT/libraries/f0f/database/driver/joomla.php:251 |
22 | F0FDatabaseDriverJoomla->getTableList() | JROOT/libraries/f0f/table/table.php:2070 |
21 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
20 | F0FTable->__construct() | JROOT/administrator/components/com_akeebasubs/tables/subscription.php:21 |
19 | AkeebasubsTableSubscription->__construct() | JROOT/libraries/f0f/table/table.php:433 |
18 | F0FTable::getAnInstance() | JROOT/libraries/f0f/model/model.php:2037 |
17 | F0FModel->_createTable() | JROOT/libraries/f0f/model/model.php:1994 |
16 | F0FModel->getTable() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:214 |
15 | AkeebasubsModelSubscriptions->_buildQueryColumns() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:635 |
14 | AkeebasubsModelSubscriptions->buildQuery() | JROOT/libraries/f0f/model/model.php:1219 |
13 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1204 |
12 | F0FModel->getList() | JROOT/components/com_tbsaas/classes/user.helper.php:719 |
11 | TBUserhelper::checkAkeebaSubscriptionIsPaid() | JROOT/components/com_tbsaas/classes/booking.helper.php:3187 |
10 | booking_helper::config() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:54 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 `zlaw_akeebasubs_subscriptions`
Status | Duration |
---|---|
Starting | 0.06 ms |
Checking permissions | 0.02 ms |
Closing tables | 0.01 ms |
Opening tables | 0.41 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.02 ms |
Opening tables | 3.10 ms |
After opening tables | 0.02 ms |
Checking permissions | 0.24 ms |
Closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.10 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.17 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/database/driver/joomla.php:229 |
22 | F0FDatabaseDriverJoomla->getTableColumns() | JROOT/libraries/f0f/table/table.php:2155 |
21 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
20 | F0FTable->__construct() | JROOT/administrator/components/com_akeebasubs/tables/subscription.php:21 |
19 | AkeebasubsTableSubscription->__construct() | JROOT/libraries/f0f/table/table.php:433 |
18 | F0FTable::getAnInstance() | JROOT/libraries/f0f/model/model.php:2037 |
17 | F0FModel->_createTable() | JROOT/libraries/f0f/model/model.php:1994 |
16 | F0FModel->getTable() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:214 |
15 | AkeebasubsModelSubscriptions->_buildQueryColumns() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:635 |
14 | AkeebasubsModelSubscriptions->buildQuery() | JROOT/libraries/f0f/model/model.php:1219 |
13 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1204 |
12 | F0FModel->getList() | JROOT/components/com_tbsaas/classes/user.helper.php:719 |
11 | TBUserhelper::checkAkeebaSubscriptionIsPaid() | JROOT/components/com_tbsaas/classes/booking.helper.php:3187 |
10 | booking_helper::config() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:54 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `zlaw_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `zlaw_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `zlaw_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `zlaw_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`user_id` = '761'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | tbl | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1987 | Using where; Using temporary; Using filesort |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | a | const | joomlauser | joomlauser | 8 | const | 1 | |
1 | SIMPLE | l | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.20 ms |
Checking permissions | 0.03 ms |
Opening tables | 8.61 ms |
After opening tables | 0.05 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.26 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Init | 0.13 ms |
Optimizing | 0.06 ms |
Statistics | 0.14 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.13 ms |
Sorting result | 0.04 ms |
Executing | 0.01 ms |
Sending data | 20.78 ms |
Creating sort index | 0.13 ms |
Removing tmp table | 0.12 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/database/driver/joomla.php:321 |
15 | F0FDatabaseDriverJoomla->loadObjectList() | JROOT/libraries/f0f/model/model.php:1953 |
14 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1225 |
13 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1204 |
12 | F0FModel->getList() | JROOT/components/com_tbsaas/classes/user.helper.php:719 |
11 | TBUserhelper::checkAkeebaSubscriptionIsPaid() | JROOT/components/com_tbsaas/classes/booking.helper.php:3187 |
10 | booking_helper::config() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:54 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 *, 0 AS isCompanyBookNowBtnEnabled
FROM zlaw_tbsaas_companies
WHERE id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_companies | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.09 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.10 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/booking.helper.php:5108 |
10 | booking_helper::getTBCompany() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:55 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 state
FROM `zlaw_tbsaas_company_bookbtns`
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_bookbtns | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.05 ms |
Checking permissions | 0.01 ms |
Opening tables | 3.58 ms |
After opening tables | 0.05 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.05 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.61 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
End of update loop | 0.02 ms |
Query end | 0.06 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3835 |
11 | company_helper::isCompanyBookNowBtnEnabled() | JROOT/components/com_tbsaas/classes/booking.helper.php:5111 |
10 | booking_helper::getTBCompany() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:55 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 state
FROM `zlaw_tbsaas_company_bookbtns`
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_bookbtns | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.09 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3835 |
11 | company_helper::isCompanyBookNowBtnEnabled() | JROOT/components/com_tbsaas/classes/booking.helper.php:5125 |
10 | booking_helper::getTBCompany() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:55 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 btn_text, btn_bg_color, btn_font_color, btn_width, btn_height, show_btn_border, btn_border_color, show_btn_border_radius, btn_border_radius, btn_fontsize, state
FROM `zlaw_tbsaas_company_bookbtns`
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_bookbtns | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.04 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/company.helper.php:3847 |
10 | company_helper::getCompanyBookNowBtnStyle() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:57 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 zlaw_tbsaas_cars
WHERE company_id = 37
AND published = 1
AND is_shared = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_cars | ref | idx_company | idx_company | 4 | const | 12 | Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.45 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.12 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.56 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 6.17 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/booking.helper.php:4525 |
10 | booking_helper::has_any_shared_car() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:166 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 zlaw_tbsaas_orders
WHERE company_id = 37
AND is_shared = 1
AND state != "0"
AND (booking_type = "address" OR booking_type = "offers")
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_orders | ref | idx_company,idx_state | idx_company | 4 | const | 13 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.79 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.16 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 1.00 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 6.49 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/booking.helper.php:4541 |
10 | booking_helper::has_any_shared_car() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:166 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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,title,payment_plugin_id,payment_params,payment_element
FROM zlaw_tbsaas_paymentmethods
WHERE payment_element IN ("invoicelater", "squareup")
AND company_id = 37
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_paymentmethods | ref | idx_company | idx_company | 4 | const | 7 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 2.66 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.09 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 1.14 ms |
Preparing | 0.07 ms |
Executing | 0.01 ms |
Sending data | 2.23 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/classes/company.helper.php:3727 |
10 | company_helper::getPaymentPluginsMethod() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:170 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 zlaw_tbsaas_routes
WHERE company_id = 37
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_routes | ref | idx_company | idx_company | 4 | const | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
Checking permissions | 0.01 ms |
Opening tables | 2.55 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.06 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 1.29 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 1.28 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3087 |
10 | company_helper::hasAnyFixedRoute() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:184 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 DISTINCT(route_from)
FROM zlaw_tbsaas_routes
WHERE company_id = 37
AND pickup_type = "poi"
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_routes | ref | idx_company | idx_company | 4 | const | 1 | Using where; Using temporary |
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
Removing tmp table | 0.02 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/classes/company.helper.php:3437 |
11 | company_helper::getRoutePickupPoints() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:368 |
10 | TbsaasViewTbsaas->_buildEditLists() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:199 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 poi.id, poi.title, poi.text, poi.lat, poi.long, poi.show_on_pickup, poi.show_on_dropoff, poi.show_on_offers_pickup, poi.show_on_offers_dropoff, poi_cat.image,poi_cat.title AS cattitle
FROM zlaw_tbsaas_points AS poi
LEFT JOIN zlaw_tbsaas_poicats AS poi_cat
ON poi_cat.id = poi.catid
WHERE poi.published = 1
AND poi.company_id = 37
AND (poi.language = "*" OR poi.language = "en-GB")
ORDER BY poi.title ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | poi | ref | idx_company | idx_company | 4 | const | 11 | Using where; Using filesort |
1 | SIMPLE | poi_cat | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.poi.catid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
Checking permissions | 0.02 ms |
Opening tables | 4.09 ms |
After opening tables | 0.04 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.09 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.04 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 1.62 ms |
Preparing | 0.09 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 3.01 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:387 |
10 | TbsaasViewTbsaas->_buildEditLists() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:199 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 DISTINCT poi.title, poi.id, poi_cat.id AS catid, poi_cat.title AS cattitle, poi_cat.image AS cat_image, poi_cat.language AS cat_language
FROM zlaw_tbsaas_points AS poi
LEFT JOIN zlaw_tbsaas_poicats AS poi_cat
ON poi_cat.id = poi.catid
LEFT JOIN zlaw_tbsaas_routes AS r
ON poi.id = r.route_from
WHERE r.published = 1
AND r.company_id = 37
AND poi.published = 1
AND poi.show_on_offers_pickup = 1
AND (poi.language = "*" OR poi.language = "en-GB")
ORDER BY poi_cat.title ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ref | idx_company | idx_company | 4 | const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | poi | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.r.route_from | 1 | Using where |
1 | SIMPLE | poi_cat | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.poi.catid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.28 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.10 ms |
Creating sort index | 0.10 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:477 |
10 | TbsaasViewTbsaas->_buildEditLists() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:199 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 DISTINCT poi.title, poi.id, poi_cat.id AS catid, poi_cat.title AS cattitle, poi_cat.image AS cat_image, poi_cat.language AS cat_language
FROM zlaw_tbsaas_points AS poi
LEFT JOIN zlaw_tbsaas_poicats AS poi_cat
ON poi_cat.id = poi.catid
LEFT JOIN zlaw_tbsaas_routes AS r
ON poi.id = r.route_to
WHERE r.published = 1
AND r.company_id = 37
AND poi.published = 1
AND poi.show_on_offers_dropoff = 1
AND (poi.language = "*" OR poi.language = "en-GB")
AND r.route_from = '0'
ORDER BY poi_cat.title ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ref | idx_company | idx_company | 4 | const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | poi | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.r.route_to | 1 | Using where |
1 | SIMPLE | poi_cat | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.poi.catid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.17 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.06 ms |
Creating sort index | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:506 |
10 | TbsaasViewTbsaas->_buildEditLists() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:199 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 zlaw_tbsaas_countries
WHERE country_id = 222
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_countries | const | PRIMARY | PRIMARY | 2 | const | 1 |
Status | Duration |
---|---|
Starting | 0.05 ms |
Checking permissions | 0.01 ms |
Opening tables | 3.02 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.06 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.56 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.11 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/company.helper.php:2574 |
10 | company_helper::getCountryById() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:206 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 zlaw_tbsaas_countries
WHERE country_id IN (222)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_countries | const | PRIMARY | PRIMARY | 2 | const | 1 |
Status | Duration |
---|---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/classes/company.helper.php:2594 |
10 | company_helper::getCountryByIds() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:210 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM zlaw_modules AS m
LEFT JOIN zlaw_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN zlaw_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | published,newsfeeds,idx_language | published | 1 | const | 21 | Using index condition; Using where; Using filesort |
1 | SIMPLE | am | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.m.id | 1 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | appcrbgnfx.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.21 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.98 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.09 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 1.40 ms |
Preparing | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 3.91 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:361 |
18 | plgSystemAdvancedModuleHelper->getModuleList() | JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:126 |
17 | plgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
16 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
15 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:366 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
13 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:272 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 m.menutype
FROM zlaw_menu AS m
WHERE m.id = 307
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.14 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
22 | JDatabaseDriver->loadResult() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:80 |
21 | nnFrameworkAssignmentsMenu->getMenuType() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:28 |
20 | nnFrameworkAssignmentsMenu->passMenu() | JROOT/plugins/system/nnframework/helpers/assignments.php:344 |
19 | nnFrameworkAssignmentsHelper->passAllByType() | JROOT/plugins/system/nnframework/helpers/assignments.php:289 |
18 | nnFrameworkAssignmentsHelper->passAll() | JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176 |
17 | plgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
16 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
15 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:366 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
13 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:272 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 t.parent_id
FROM zlaw_menu as t
WHERE t.id = 307
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.04 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.07 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/plugins/system/nnframework/helpers/assignment.php:168 |
22 | nnFrameworkAssignment->getParentIds() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65 |
21 | nnFrameworkAssignmentsMenu->getMenuParentIds() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47 |
20 | nnFrameworkAssignmentsMenu->passMenu() | JROOT/plugins/system/nnframework/helpers/assignments.php:344 |
19 | nnFrameworkAssignmentsHelper->passAllByType() | JROOT/plugins/system/nnframework/helpers/assignments.php:289 |
18 | nnFrameworkAssignmentsHelper->passAll() | JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176 |
17 | plgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
16 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
15 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:366 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
13 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:272 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 t.parent_id
FROM zlaw_menu as t
WHERE t.id = 402
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/plugins/system/nnframework/helpers/assignment.php:168 |
22 | nnFrameworkAssignment->getParentIds() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65 |
21 | nnFrameworkAssignmentsMenu->getMenuParentIds() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47 |
20 | nnFrameworkAssignmentsMenu->passMenu() | JROOT/plugins/system/nnframework/helpers/assignments.php:344 |
19 | nnFrameworkAssignmentsHelper->passAllByType() | JROOT/plugins/system/nnframework/helpers/assignments.php:289 |
18 | nnFrameworkAssignmentsHelper->passAll() | JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176 |
17 | plgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
16 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
15 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:366 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
13 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:272 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 t.parent_id
FROM zlaw_menu as t
WHERE t.id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/plugins/system/nnframework/helpers/assignment.php:168 |
22 | nnFrameworkAssignment->getParentIds() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65 |
21 | nnFrameworkAssignmentsMenu->getMenuParentIds() | JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47 |
20 | nnFrameworkAssignmentsMenu->passMenu() | JROOT/plugins/system/nnframework/helpers/assignments.php:344 |
19 | nnFrameworkAssignmentsHelper->passAllByType() | JROOT/plugins/system/nnframework/helpers/assignments.php:289 |
18 | nnFrameworkAssignmentsHelper->passAll() | JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:176 |
17 | plgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT/libraries/joomla/event/dispatcher.php:165 |
16 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
15 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Helper/ModuleHelper.php:366 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
13 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:272 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 state
FROM `zlaw_tbsaas_company_bookbtns`
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_bookbtns | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.14 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3835 |
17 | company_helper::isCompanyBookNowBtnEnabled() | JROOT/components/com_tbsaas/classes/booking.helper.php:5125 |
16 | booking_helper::getTBCompany() | JROOT/templates/sportsmaterial/html/mod_languages/default.php:38 |
15 | require JROOT/templates/sportsmaterial/html/mod_languages/default.php | JROOT/modules/mod_languages/mod_languages.php:20 |
14 | include JROOT/modules/mod_languages/mod_languages.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:274 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 lang_code,installed,published
FROM zlaw_tbsaas_company_langs
WHERE company_id = 37
AND lang_code IN ("de-DE", "zh-CN", "pt-BR", "is-IS", "en-US", "nl-NL", "en-GB", "es-ES", "fr-FR", "it-IT", "ro-RO", "ru-RU")
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_langs | ref | idx_company | idx_company | 4 | const | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.01 ms |
Opening tables | 1.48 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.13 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.03 ms |
Statistics | 1.11 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.81 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_tbsaas/helpers/tbsaas.php:538 |
16 | TbsaasHelper::getCompanyLanguage() | JROOT/templates/sportsmaterial/html/mod_languages/default.php:66 |
15 | require JROOT/templates/sportsmaterial/html/mod_languages/default.php | JROOT/modules/mod_languages/mod_languages.php:20 |
14 | include JROOT/modules/mod_languages/mod_languages.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:274 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 country_id, country_name, country_2_code, calling_code
FROM zlaw_tbsaas_countries
WHERE calling_code != ''
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_countries | ALL | idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 246 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.64 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.71 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/helpers/sms_helper.php:230 |
13 | sms_helper::get_country_codes() | JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php:1752 |
12 | include JROOT/components/com_tbsaas/views/tbsaas/tmpl/default_three.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:339 |
9 | TbsaasViewTbsaas->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_tbsaas/tbsaas.php:58 |
6 | require_once JROOT/components/com_tbsaas/tbsaas.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 language,id
FROM `zlaw_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_menu | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 744 | Using where |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.09 ms |
Preparing | 0.09 ms |
Executing | 0.01 ms |
Sending data | 0.36 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
9 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/administrator/components/com_languages/helpers/multilangstatus.php:125 |
8 | MultilangstatusHelper::getHomepages() | JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:708 |
7 | PlgSystemTBFLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
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 text
FROM zlaw_tbsaas_configs
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_configs | ref | idx_company | idx_company | 4 | const | 9 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.13 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/components/com_tbsaas/classes/booking.helper.php:3081 |
8 | booking_helper::config() | JROOT/templates/sportsmaterial/component.php:54 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id,user_id,name,email,phone,language,app_authorization_token
FROM zlaw_tbsaas_users
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_users | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12158 | Using where |
Status | Duration |
---|---|
Starting | 0.08 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 6.80 ms |
End of update loop | 0.04 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
10 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/company.helper.php:493 |
9 | company_helper::getCompanyMainAdmin() | JROOT/components/com_tbsaas/classes/booking.helper.php:3185 |
8 | booking_helper::config() | JROOT/templates/sportsmaterial/component.php:54 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `zlaw_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `zlaw_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `zlaw_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `zlaw_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`user_id` = '761'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | tbl | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1987 | Using where; Using temporary; Using filesort |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | a | const | joomlauser | joomlauser | 8 | const | 1 | |
1 | SIMPLE | l | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.17 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.08 ms |
Optimizing | 0.04 ms |
Statistics | 0.09 ms |
Preparing | 1.53 ms |
Creating tmp table | 4.04 ms |
Sorting result | 1.52 ms |
Executing | 0.02 ms |
Sending data | 2.83 ms |
Creating sort index | 0.33 ms |
Removing tmp table | 0.15 ms |
Creating sort index | 0.13 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.56 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/database/driver/joomla.php:321 |
13 | F0FDatabaseDriverJoomla->loadObjectList() | JROOT/libraries/f0f/model/model.php:1953 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1225 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1204 |
10 | F0FModel->getList() | JROOT/components/com_tbsaas/classes/user.helper.php:719 |
9 | TBUserhelper::checkAkeebaSubscriptionIsPaid() | JROOT/components/com_tbsaas/classes/booking.helper.php:3187 |
8 | booking_helper::config() | JROOT/templates/sportsmaterial/component.php:54 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *, 0 AS isCompanyBookNowBtnEnabled
FROM zlaw_tbsaas_companies
WHERE id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_companies | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.14 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.19 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/booking.helper.php:5108 |
8 | booking_helper::getTBCompany() | JROOT/templates/sportsmaterial/component.php:55 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT state
FROM `zlaw_tbsaas_company_bookbtns`
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_bookbtns | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.04 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.11 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.14 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3835 |
9 | company_helper::isCompanyBookNowBtnEnabled() | JROOT/components/com_tbsaas/classes/booking.helper.php:5111 |
8 | booking_helper::getTBCompany() | JROOT/templates/sportsmaterial/component.php:55 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT state
FROM `zlaw_tbsaas_company_bookbtns`
WHERE company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_company_bookbtns | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.10 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.18 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3835 |
9 | company_helper::isCompanyBookNowBtnEnabled() | JROOT/components/com_tbsaas/classes/booking.helper.php:5125 |
8 | booking_helper::getTBCompany() | JROOT/templates/sportsmaterial/component.php:55 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.icon_16, a.icon_32, a.icon_48, a.icon_64, a.icon_128, a.icon_144, a.icon_192, a.icon_512
FROM zlaw_tbsaas_company_manifests AS a
WHERE a.company_id = 37
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_company | idx_company | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.02 ms |
Opening tables | 1.94 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.05 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.06 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.67 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 0.14 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.52 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/components/com_tbsaas/classes/web_push.php:472 |
8 | WebPushHelper->getManifestData() | JROOT/templates/sportsmaterial/component.php:155 |
7 | require JROOT/templates/sportsmaterial/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT r.*
FROM zlaw_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'component')
ORDER BY r.ordering, r.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ref | idx_published | idx_published | 1 | const | 3 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.16 ms |
Checking permissions | 0.02 ms |
Opening tables | 2.68 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.06 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 2.08 ms |
Preparing | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.13 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rereplacer/helpers/items.php:52 |
11 | plgSystemReReplacerHelperItems->getItemList() | JROOT/plugins/system/rereplacer/helpers/replace.php:50 |
10 | plgSystemReReplacerHelperReplace->replaceInArea() | JROOT/plugins/system/rereplacer/helpers/replace.php:36 |
9 | plgSystemReReplacerHelperReplace->replaceInAreas() | JROOT/plugins/system/rereplacer/helper.php:102 |
8 | plgSystemReReplacerHelper->onAfterRender() | JROOT/plugins/system/rereplacer/rereplacer.php:60 |
7 | plgSystemReReplacer->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT r.*
FROM zlaw_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'head')
ORDER BY r.ordering, r.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ref | idx_published | idx_published | 1 | const | 3 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.09 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.09 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rereplacer/helpers/items.php:52 |
11 | plgSystemReReplacerHelperItems->getItemList() | JROOT/plugins/system/rereplacer/helpers/replace.php:50 |
10 | plgSystemReReplacerHelperReplace->replaceInArea() | JROOT/plugins/system/rereplacer/helpers/replace.php:37 |
9 | plgSystemReReplacerHelperReplace->replaceInAreas() | JROOT/plugins/system/rereplacer/helper.php:102 |
8 | plgSystemReReplacerHelper->onAfterRender() | JROOT/plugins/system/rereplacer/rereplacer.php:60 |
7 | plgSystemReReplacer->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT r.*
FROM zlaw_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'body')
ORDER BY r.ordering, r.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ref | idx_published | idx_published | 1 | const | 3 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.05 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rereplacer/helpers/items.php:52 |
11 | plgSystemReReplacerHelperItems->getItemList() | JROOT/plugins/system/rereplacer/helpers/replace.php:50 |
10 | plgSystemReReplacerHelperReplace->replaceInArea() | JROOT/plugins/system/rereplacer/helpers/replace.php:38 |
9 | plgSystemReReplacerHelperReplace->replaceInAreas() | JROOT/plugins/system/rereplacer/helper.php:102 |
8 | plgSystemReReplacerHelper->onAfterRender() | JROOT/plugins/system/rereplacer/rereplacer.php:60 |
7 | plgSystemReReplacer->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT r.*
FROM zlaw_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'everywhere')
ORDER BY r.ordering, r.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | r | ref | idx_published | idx_published | 1 | const | 3 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.17 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 0.09 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rereplacer/helpers/items.php:52 |
11 | plgSystemReReplacerHelperItems->getItemList() | JROOT/plugins/system/rereplacer/helpers/replace.php:75 |
10 | plgSystemReReplacerHelperReplace->replaceEverywhere() | JROOT/plugins/system/rereplacer/helpers/replace.php:40 |
9 | plgSystemReReplacerHelperReplace->replaceInAreas() | JROOT/plugins/system/rereplacer/helper.php:102 |
8 | plgSystemReReplacerHelper->onAfterRender() | JROOT/plugins/system/rereplacer/rereplacer.php:60 |
7 | plgSystemReReplacer->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `value`
FROM `zlaw_admintools_storage`
WHERE `key` = 'atoolsjupdatecheck_lastrun'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_admintools_storage | const | PRIMARY | PRIMARY | 402 | const | 1 |
Status | Duration |
---|---|
Starting | 0.05 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/atoolsjupdatecheck/atoolsjupdatecheck.php:78 |
7 | plgSystemAtoolsjupdatecheck->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × SELECT state
FROM `zlaw_tbsaas_company_bookbtns`
4 × SELECT r.*
FROM zlaw_rereplacer AS r
3 × SELECT t.parent_id
FROM zlaw_menu as t
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zlaw_extensions`
2 × SELECT `value`
FROM `zlaw_admintools_storage`
2 × SELECT `manifest_cache`
FROM `zlaw_extensions`
2 × SELECT text
FROM zlaw_tbsaas_configs
2 × SELECT id,user_id,name,email,phone,language,app_authorization_token
FROM zlaw_tbsaas_users
2 × SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `zlaw_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `zlaw_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `zlaw_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `zlaw_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
2 × SELECT *, 0 AS isCompanyBookNowBtnEnabled
FROM zlaw_tbsaas_companies
2 × SELECT *
FROM zlaw_tbsaas_countries
1 × SELECT `data`
FROM `zlaw_session`
1 × SELECT `session_id`
FROM `zlaw_session`
1 × SELECT id, rules
FROM `zlaw_viewlevels
1 × SELECT b.id
FROM zlaw_usergroups AS a
LEFT JOIN zlaw_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zlaw_extensions
1 × SELECT *
FROM `zlaw_admintools_wafexceptions`
1 × SELECT *
FROM zlaw_languages
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `zlaw_extensions`
1 × SELECT *
FROM `zlaw_admintools_ipautoban`
1 × SELECT *
FROM `zlaw_admintools_wafblacklists`
1 × 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 zlaw_menu AS m
LEFT JOIN zlaw_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id
FROM zlaw_affiliate_tracker_accounts
1 × SELECT id, home, template, s.params
FROM zlaw_template_styles as s
LEFT JOIN zlaw_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT btn_text, btn_bg_color, btn_font_color, btn_width, btn_height, show_btn_border, btn_border_color, show_btn_border_radius, btn_border_radius, btn_fontsize, state
FROM `zlaw_tbsaas_company_bookbtns`
1 × SELECT COUNT(id)
FROM zlaw_tbsaas_cars
1 × SELECT COUNT(id)
FROM zlaw_tbsaas_orders
1 × SELECT id,title,payment_plugin_id,payment_params,payment_element
FROM zlaw_tbsaas_paymentmethods
1 × SELECT COUNT(id)
FROM zlaw_tbsaas_routes
1 × SELECT DISTINCT(route_from)
FROM zlaw_tbsaas_routes
1 × SELECT poi.id, poi.title, poi.text, poi.lat, poi.long, poi.show_on_pickup, poi.show_on_dropoff, poi.show_on_offers_pickup, poi.show_on_offers_dropoff, poi_cat.image,poi_cat.title AS cattitle
FROM zlaw_tbsaas_points AS poi
LEFT JOIN zlaw_tbsaas_poicats AS poi_cat
ON poi_cat.id = poi.catid
1 × SELECT DISTINCT poi.title, poi.id, poi_cat.id AS catid, poi_cat.title AS cattitle, poi_cat.image AS cat_image, poi_cat.language AS cat_language
FROM zlaw_tbsaas_points AS poi
LEFT JOIN zlaw_tbsaas_poicats AS poi_cat
ON poi_cat.id = poi.catid
LEFT JOIN zlaw_tbsaas_routes AS r
ON poi.id = r.route_from
1 × SELECT DISTINCT poi.title, poi.id, poi_cat.id AS catid, poi_cat.title AS cattitle, poi_cat.image AS cat_image, poi_cat.language AS cat_language
FROM zlaw_tbsaas_points AS poi
LEFT JOIN zlaw_tbsaas_poicats AS poi_cat
ON poi_cat.id = poi.catid
LEFT JOIN zlaw_tbsaas_routes AS r
ON poi.id = r.route_to
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM zlaw_modules AS m
LEFT JOIN zlaw_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN zlaw_advancedmodules as am
ON am.moduleid = m.id
1 × SELECT m.menutype
FROM zlaw_menu AS m
1 × SELECT lang_code,installed,published
FROM zlaw_tbsaas_company_langs
1 × SELECT country_id, country_name, country_2_code, calling_code
FROM zlaw_tbsaas_countries
1 × SELECT language,id
FROM `zlaw_menu`
1 × SELECT a.icon_16, a.icon_32, a.icon_48, a.icon_64, a.icon_128, a.icon_144, a.icon_192, a.icon_512
FROM zlaw_tbsaas_company_manifests AS a
1 × INSERT INTO `zlaw_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6b6d61346a766139746170633634716f75647232763774393866', 1, 1714103577, 0, '', 0
1 × SHOW VARIABLES LIKE "collation_database
1 × UPDATE `zlaw_extensions`
SET `params` = '{\"mediaversion\":\"6dbef69b8a6e14d7704810d2b621ca82\"}'
1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `zlaw_akeebasubs_subscriptions