1
Ride Info
2
Select Vehicle
3
Payment Info
{ "__default": { "session": { "counter": 1, "timer": { "start": 1716129983, "last": 1716129983, "now": 1716129983 }, "client": { "forwarded": "3.144.1.156" }, "token": "z8fa2v0CDu1HTnFqLmVqTxvLL6bcQuFJ" }, "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": "kM", "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": "0", "show_hourly_tab": "1", "show_min_dropdown": "0", "show_daily_hire": "1", "show_shuttles_tab": "1", "show_poi_categories_shuttle": "1", "show_shared_rides_tab": "0", "show_tours_tab": "1", "enable_captcha": "1", "booking_cancellation_allowed": "1", "booking_cancellation_prior_hrs": "0", "restrict_time": "4", "date_format": "mm-dd-yy", "datepicker_type": "jquery", "time_format": "24hr", "load_current_date": "1", "default_tab": "address", "default_adult_seat": "1", "show_passengers_select": "1", "show_suitcase_select": "1", "invoice_title": "booking_drivenot", "combine_car_type": "1", "display_car_types": "1", "show_cartype_list": "1", "load_all_cars": "0", "orders_default_sorting": "a.datetime1 desc", "orders_default_list_limit": "10", "new_order_default_status": "-2", "offer_next_available_time": "1", "show_price": "1", "show_price_driver": "1", "auto_approve_free_order": "1", "debug_price_calculation": "1", "roundup_price": "whole", "cost_per_call": "0", "minmil": "0", "minprice": "0", "show_infant_select": "1", "infant_seat_price": "5", "shared_rides_infant_seat_discount_enabled": "1", "shared_rides_infant_seat_discount_amount": "10", "fixed_fares_infant_seat_discount_enabled": "0", "fixed_fares_infant_seat_discount_amount": "0", "show_child_select": "1", "child_seat_price": "10", "shared_rides_child_seat_discount_enabled": "1", "shared_rides_child_seat_discount_amount": "20", "fixed_fares_child_seat_discount_enabled": "0", "fixed_fares_child_seat_discount_amount": "0", "show_booster_select": "1", "booster_seat_price": "20", "shared_rides_booster_seat_discount_enabled": "1", "shared_rides_booster_seat_discount_amount": "5", "fixed_fares_booster_seat_discount_enabled": "0", "fixed_fares_booster_seat_discount_amount": "0", "enable_general_discount": "0", "general_discount_percentage": 0, "general_discount_scope": "frontend", "currency": "INR", "currency_symbol": "INR", "price_per_unit_distance": "1.5", "enable_charge_per_min": "1", "charge_per_min": "0", "show_return_option": "1", "discount": "0", "show_return_extras": "1", "wait_time_return_discount": "0", "price_calculation_cumulative": "0", "enable_gratuity": "1", "enable_gratuity_flat": "1", "company_id": 15, "distance_prices": [], "cumulative_distance_prices": [], "return_discounts": [], "gratuities": [], "api_key": "AIzaSyCST8vCSkhVdWBebNXZ4HGziISLZSSzZc0", "api_server_key": "AIzaSyCcqqNIplRUlp0NZJU0BAzOKmGvJm0iUIY", "api_client_id": "", "api_client_signature": "", "gmap_api_avoids": [ "ferries" ], "enable_stops": "1", "show_stop_poi": "1", "show_stop_address": "1", "max_stop_time": "2", "stop_duration_interval": "60", "stops_charge_per_min": "0", "optimize_stops": "1", "booking_company_name": "Demo booking and dispatch software", "company_privacy_policy_url": "https://www.google.com", "company_logo": "", "is_logo_changed": "0", "booking_notification_email": "taxibookingpro@gmail.com", "base_timezone": "Europe/London", "default_country": [ "222" ], "default_city": "London", "frontend_map_center": "company_location", "contact_country_id": "222", "contact_calling_code": "44", "contact_phone": "6584932", "operation_area_vertices": "[[51.719014722830885,-1.7521110656250038],[51.552808288863204,-1.6752067687500038],[51.44765695479361,-1.4444938781250038],[51.475036749393354,-1.0325065734375238],[51.632151948120985,-0.7963005187500238],[51.87867847099088,-0.7633415343750238],[52.056358270412666,-1.3016716125000038],[51.99636439071836,-1.6971794250000038]]", "pickup_in_area": "0", "dropoff_in_area": "0", "pickup_dropoff_in_area": "0", "base_lat": "51.64677278409991", "base_long": "-1.0893619770507712", "calculate_base_pickup": "0", "base_pickup_special_routes": "price_time", "base_pickup_price_type": "flat", "base_pickup_price": "10", "milage_charging_base_pickup": "80", "calculate_dropoff_base": "0", "base_dropoff_special_routes": "price_time", "dropoff_base_price_type": "flat", "dropoff_base_price": "10", "milage_charging_dropoff_base": "80", "time_after_each_booking": "30", "email_whitelist_added": "1", "header_logo": "images/tbsaas/emailheader/demo/siamlimologo.png", "enable_custom_invoice_number": "0", "custom_invoice_number_format": "ymdn", "send_order_pdf_link": "1", "send_order_copy": "1", "send_drivers_upcoming_reminders": "1", "send_customers_upcoming_reminders": "1", "send_admins_upcoming_reminders": "1", "email_pdf_show_dropoff_datetime": "1", "additional_emails": "", "use_smtp": "0", "smtpauth": "1", "smtpsecure": "ssl", "smtpport": "465", "smtpuser": "drivenot@taxibookingpro.com", "smtppass": "duyKs81y7mkkxl0wlIxj4oeIlpd3WnOjaO23tlVN9+w=", "smtphost": "secureams21.sgcpanel.com", "header_info": { "pt-BR": "", "nl-NL": "", "en-GB": "", "es-ES": "", "fr-FR": "", "it-IT": "", "ru-RU": "" }, "contact_info": { "pt-BR": "", "nl-NL": "", "en-GB": "", "es-ES": "", "fr-FR": "", "it-IT": "", "ru-RU": "" }, "use_terms": "0", "terms_conditions": { "pt-BR": "", "nl-NL": "Dutch Terms and Conditions", "en-GB": "<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.<a href=\"#\">Link text</a></p>", "es-ES": "Spanish Terms and Conditions", "fr-FR": "French Terms and Conditions", "it-IT": "Italian Terms and Conditions", "ru-RU": "" }, "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": "#ffffff", "booking_form_boxes_fontcolor": "#000000", "other_steps_bgcolor": "#ffffff", "other_steps_fontcolor": "#999999", "booking_form_btncolor": "#1aa1bf", "bg_color_opacity": "1", "highlights_color": "#066706", "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": "https://taxibookingpro.com/demo2", "booking_form_url": "", "frontend_fields_vertical_gap": "10", "frontend_bottom_totals_position": "right", "show_checkout_details": "0", "show_map_address": "1", "show_map_offers": "0", "show_map_shuttles": "0", "show_map_in_popup_only": "0", "show_map_on_desktop": "1", "show_map_on_mobile": "0", "map_height": "400", "map_zoom": "10", "dir_height": "0", "order_thanks_show_upcoming_events": "0", "install_app_btn_bg_color": "#cc3f9d", "install_app_btn_font_color": "#eaff03", "install_app_btn_font_size": "13", "install_app_btn_border_color": "#b8b6b6", "install_app_btn_border_radius": "3", "google_analytics_code": "", "facebook_pixel_code": "", "footer_info": { "pt-BR": "", "nl-NL": "", "en-GB": "<strong>This is Company Footer<br />This is Company Footer<br /></strong>", "es-ES": "", "fr-FR": "", "it-IT": "", "ru-RU": "" }, "show_country_codes": "1", "sms_default_country": "223", "country_calling_code": "1", "send_user_sms": "1", "clickatell_api_version": "new", "clickatell_api_key": "demo", "clickatell_api_id": "", "clickatell_api_username": "demo", "clickatell_api_password": "demo", "clickatell_sender_id": "", "send_sms_option_selected": "0", "send_sms_order_status_change": "1", "sms_bottom_text": { "pt-BR": [ "", "", "" ], "nl-NL": [ "", "", "" ], "en-GB": [ "Waiting Billing info", "", "" ], "es-ES": [ "", "", "" ], "fr-FR": [ "", "", "" ], "it-IT": [ "", "", "" ], "ru-RU": [ "", "", "" ] }, "review_request_subject": { "it-IT": "Please leave a review for your Order at {COMPANY_NAME}", "ru-RU": "Please leave a review for your Order at {COMPANY_NAME}", "en-GB": "Please leave a review for your Order #{REFERENCE_NUMBER} at {COMPANY_NAME}", "fr-FR": "Please leave a review for your Order at {COMPANY_NAME}", "es-ES": "Please leave a review for your Order at {COMPANY_NAME}" }, "review_emailbody": { "it-IT": "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Hi {CUSTOMER_NAME}, how did {COMPANY_NAME} meet your expectations?</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Start by rating it!</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td>{REVIEW_URL}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Order details</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Company: {COMPANY_NAME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Pick up: {PICKUP}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Drop off: {DROPOFF}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Date/Time: {PICKUP_DATETIME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Distance: {TRIP_DISTANCE}*</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Duration: {TRIP_DURATION}*</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Distance and Duration will be added to your profile when you submit the Review.</td>\r\n</tr>\r\n</tbody>\r\n</table>", "ru-RU": "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Hi {CUSTOMER_NAME}, how did {COMPANY_NAME} meet your expectations?</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Start by rating it!</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td>{REVIEW_URL}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Order details</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Company: {COMPANY_NAME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Pick up: {PICKUP}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Drop off: {DROPOFF}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Date/Time: {PICKUP_DATETIME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Distance: {TRIP_DISTANCE}*</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Duration: {TRIP_DURATION}*</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Distance and Duration will be added to your profile when you submit the Review.</td>\r\n</tr>\r\n</tbody>\r\n</table>", "en-GB": "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Hi {CUSTOMER_NAME}, how did {COMPANY_NAME} meet your expectations?</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Start by rating it!</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td>{REVIEW_URL}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Order details</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Company: {COMPANY_NAME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Pick up: {PICKUP}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Drop off: {DROPOFF}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Date/Time: {PICKUP_DATETIME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Distance: {TRIP_DISTANCE}*</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Duration: {TRIP_DURATION}*</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Distance and Duration will be added to your profile when you submit the Review.</td>\r\n</tr>\r\n</tbody>\r\n</table>", "fr-FR": "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Hi {CUSTOMER_NAME}, how did {COMPANY_NAME} meet your expectations?</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Start by rating it!</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td>{REVIEW_URL}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Order details</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Company: {COMPANY_NAME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Pick up: {PICKUP}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Drop off: {DROPOFF}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Date/Time: {PICKUP_DATETIME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Distance: {TRIP_DISTANCE}*</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Duration: {TRIP_DURATION}*</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Distance and Duration will be added to your profile when you submit the Review.</td>\r\n</tr>\r\n</tbody>\r\n</table>", "es-ES": "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n<tbody>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Hi {CUSTOMER_NAME}, how did {COMPANY_NAME} meet your expectations?</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"large\"><span style=\"font-size: 16px;\">Start by rating it!</span></td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td>{REVIEW_URL}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Order details</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Company: {COMPANY_NAME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Pick up: {PICKUP}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Drop off: {DROPOFF}</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Date/Time: {PICKUP_DATETIME}</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Distance: {TRIP_DISTANCE}*</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Trip Duration: {TRIP_DURATION}*</td>\r\n</tr>\r\n<tr>\r\n<td>\u00a0</td>\r\n</tr>\r\n<tr>\r\n<td class=\"normal\">Distance and Duration will be added to your profile when you submit the Review.</td>\r\n</tr>\r\n</tbody>\r\n</table>" }, "use_policy": "1", "privacy_policies": { "pt-BR": "", "nl-NL": "", "en-GB": "English Privacy policy", "es-ES": "", "fr-FR": "", "it-IT": "", "ru-RU": "" }, "faqs": { "nl-NL": "", "de-DE": "", "it-IT": "", "ru-RU": "", "en-GB": "", "pt-BR": "", "is-IS": "", "fr-FR": "", "en-US": "", "es-ES": "", "ro-RO": "" }, "new_order_admin_notification_type": "notification", "enable_aboutus": "1", "new_order_customer_notification_type": "notification", "enable_ourfleet": 0, "trial_subscriber": 0, "has_paid_subscr_own_api_keys": 1 }, "tbsaas_company_id": 15, "TBFCompanyObject": { "id": "15", "title": "Demo", "alias": "demo", "base_url": "https://tbftest.drivenot.com/company/demo", "short_url": "", "short_url_https": "", "booking_company_name": "Demo booking and dispatch software", "booking_notification_email": "taxibookingpro@gmail.com", "default_country": "0", "default_city": "London", "base_timezone": "Europe/London", "company_logo": "", "contact_calling_code": "44", "contact_phone": "6584932", "text": "Testing description", "drivenot_integrated": "1", "created": "2015-06-01 16:34:52", "created_by": "0", "modified": "2024-01-05 04:33:32", "modified_by": "645", "published": "1", "ordering": "0", "checked_out": "0", "checked_out_time": "0000-00-00 00:00:00", "default_language": "en-GB", "first_warning_sent_date": "0000-00-00 00:00:00", "last_warning_sent_date": "0000-00-00 00:00:00", "car_min_passenger": "0", "car_max_passenger": "20", "car_min_suitcase": "0", "car_max_suitcase": "10", "car_max_booster": "2", "car_max_child": "10", "car_max_infant": "2", "default_location_lat": "51.50735090", "default_location_lng": "-0.12775830", "isCompanyBookNowBtnEnabled": "1" }, "booking_form_design": "design2" } }
SELECT `data`
FROM `zlaw_session`
WHERE `session_id` = X'69636f346e716a39623230346c3035636d68696e397268373733'
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.18 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 2.76 ms |
Preparing | 0.03 ms |
Executing | 0.28 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.04 ms |
Reset for next command | 0.02 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'69636f346e716a39623230346c3035636d68696e397268373733'
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.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.05 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Executing | 0.18 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 |
---|---|---|
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'69636f346e716a39623230346c3035636d68696e397268373733', 1, 1716129983, 0, '', 0)
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 for update | 0.02 ms |
Update | 1.83 ms |
Waiting for query cache lock | 0.02 ms |
Update | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 2.92 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.04 ms |
Reset for next command | 0.01 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.13 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.04 ms |
Statistics | 2.17 ms |
Preparing | 0.09 ms |
Executing | 0.01 ms |
Sending data | 11.03 ms |
End of update loop | 0.09 ms |
Query end | 0.01 ms |
Commit | 0.03 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.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/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.13 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.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 1.41 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.02 ms |
Updating status | 0.04 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.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.14 ms |
Optimizing | 0.04 ms |
Statistics | 4.16 ms |
Preparing | 0.07 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.09 ms |
Executing | 0.01 ms |
Sending data | 0.32 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.06 ms |
Reset for next command | 0.02 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.17 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.78 ms |
Preparing | 0.12 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 9.84 ms |
End of update loop | 0.08 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.06 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.20 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 2.00 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.02 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.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 |
---|---|---|
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.14 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 1.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.03 ms |
Reset for next command | 0.01 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.27 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.07 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 | 1.47 ms |
Preparing | 0.07 ms |
Sorting result | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 0.76 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.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.12 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.12 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.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.14 ms |
Preparing | 0.07 ms |
Executing | 0.02 ms |
Sending data | 0.27 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 |
---|---|---|
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.14 ms |
Opening tables | 0.07 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.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Filling schema table | 1.58 ms |
Executing | 0.03 ms |
Sending data | 0.05 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.02 ms |
Updating status | 0.04 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` = '3.144.1.156'
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.08 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 2.72 ms |
Preparing | 0.03 ms |
Executing | 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.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: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.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.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 4.40 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.09 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/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.23 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.08 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 9.03 ms |
Preparing | 0.13 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 14.61 ms |
End of update loop | 0.07 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 |
---|---|---|
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.13 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 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 | 1.17 ms |
Preparing | 0.02 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.02 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.17 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.10 ms |
Table lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.07 ms |
Statistics | 0.16 ms |
Preparing | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.68 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.03 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: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.16 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.07 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.44 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: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.20 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.04 ms |
Statistics | 1.17 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 0.23 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.04 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\":\"ac92538d015ba76afd0f34a0aa448d73\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.07 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init for update | 0.10 ms |
Updating | 0.09 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
Commit | 5.73 ms |
Closing tables | 0.06 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 |
---|---|---|
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.19 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.13 ms |
Statistics | 1.99 ms |
Preparing | 0.07 ms |
Executing | 0.01 ms |
Sending data | 1.00 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.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 = 15
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 | 13 |
Status | Duration |
---|---|
Starting | 0.19 ms |
Checking permissions | 0.02 ms |
Opening tables | 5.86 ms |
After opening tables | 0.05 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Opening tables | 0.06 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.03 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 1.29 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 3.10 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.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/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 = 15
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 | 12417 | Using where |
Status | Duration |
---|---|
Starting | 0.13 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.42 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.10 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 | 0.05 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 76.77 ms |
End of update loop | 0.21 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.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.12 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.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 | 0.01 ms |
Checking permissions | 1.12 ms |
Executing | 0.02 ms |
Sending data | 0.33 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.05 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.04 ms |
Checking permissions | 0.01 ms |
Closing tables | 0.01 ms |
Opening tables | 0.42 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Filling schema table | 0.02 ms |
Opening tables | 5.68 ms |
After opening tables | 0.03 ms |
Checking permissions | 0.17 ms |
Closing tables | 0.02 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 |
Removing tmp table | 0.18 ms |
Closing tables | 0.04 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.06 ms |
Reset for next command | 0.02 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` = '670'
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.14 ms |
Checking permissions | 0.01 ms |
Opening tables | 2.44 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.09 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.08 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.10 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 24.51 ms |
Creating sort index | 0.22 ms |
Removing tmp table | 0.18 ms |
Creating sort index | 0.22 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.03 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.14 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.06 ms |
Reset for next command | 0.10 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 = 15
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.13 ms |
Checking permissions | 0.09 ms |
Opening tables | 2.85 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.07 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.04 ms |
Init | 0.07 ms |
Optimizing | 0.03 ms |
Statistics | 0.86 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 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/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 = 15
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.13 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.03 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.10 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.72 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.15 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.02 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 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 = 15
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.06 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.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.02 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.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 = 15
AND hourly_hire_enabled = 1
AND published = 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 | 27 | Using where |
Status | Duration |
---|---|
Starting | 0.24 ms |
Checking permissions | 0.04 ms |
Opening tables | 3.35 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.10 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.63 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 8.53 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.03 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:4475 |
10 | booking_helper::is_hourly_rate_enabled() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:151 |
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_shuttle_routes
WHERE company_id = 15
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_shuttle_routes | ref | idx_company | idx_company | 4 | const | 6 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.49 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.09 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.06 ms |
Init | 0.09 ms |
Optimizing | 0.04 ms |
Statistics | 0.57 ms |
Preparing | 0.08 ms |
Executing | 0.01 ms |
Sending data | 0.31 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.04 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.07 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:4565 |
10 | booking_helper::is_shuttles_enabled() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:156 |
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 = 15
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 | 15 | Using where |
Status | Duration |
---|---|
Starting | 0.11 ms |
Checking permissions | 0.09 ms |
Opening tables | 4.04 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.13 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 1.44 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 4.51 ms |
End of update loop | 0.03 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.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/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 = 15
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 | 17 | Using where |
Status | Duration |
---|---|
Starting | 0.08 ms |
Checking permissions | 0.02 ms |
Opening tables | 3.29 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.07 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 1.01 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 5.52 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 COUNT(id)
FROM zlaw_tbsaas_cars
WHERE company_id = 15
AND daily_hire_enabled = 1
AND published = 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 | 27 | 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.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 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.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:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/components/com_tbsaas/classes/company.helper.php:3416 |
10 | company_helper::hasAnyDailyHireCar() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:189 |
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,period,pickup_type,pickup_pois,pickup_zone_id,pickup_zone_ids
FROM zlaw_tbsaas_private_tours
WHERE company_id = 15
AND published = 1
ORDER BY title ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | zlaw_tbsaas_private_tours | ref | idx_company | idx_company | 4 | const | 3 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.05 ms |
Checking permissions | 0.01 ms |
Opening tables | 3.06 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.05 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.61 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.62 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/tours.helper.php:33 |
10 | ToursHelper::getCompanyTours() | JROOT/components/com_tbsaas/views/tbsaas/view.html.php:195 |
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 = 15
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 | 17 | Using where; Using temporary |
Status | Duration |
---|---|
Starting | 0.06 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 |
Executing | 0.01 ms |
Sending data | 0.11 ms |
Removing tmp table | 0.02 ms |
Sending data | 0.12 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.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 = 15
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 | 29 | Using where; Using filesort |
1 | SIMPLE | poi_cat | eq_ref | PRIMARY | PRIMARY | 4 | appcrbgnfx.poi.catid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 7.71 ms |
After opening tables | 0.05 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.14 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.05 ms |
Init | 0.09 ms |
Optimizing | 0.07 ms |
Statistics | 1.08 ms |
Preparing | 0.08 ms |
Sorting result | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 3.32 ms |
End of update loop | 0.02 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.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 *
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.08 ms |
Checking permissions | 0.01 ms |
Opening tables | 2.73 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 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.57 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 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.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: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.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.12 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.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.23 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.13 ms |
Optimizing | 0.05 ms |
Statistics | 1.61 ms |
Preparing | 0.08 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 4.61 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.03 ms |
Reset for next command | 0.01 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 = 252
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.12 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.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.11 ms |
Preparing | 0.07 ms |
Unlocking tables | 0.08 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 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 |
---|---|---|
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 = 252
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.07 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.05 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.02 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.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.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.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 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.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.04 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.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 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 lang_code,installed,published
FROM zlaw_tbsaas_company_langs
WHERE company_id = 15
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 | 8 | Using where |
Status | Duration |
---|---|
Starting | 0.22 ms |
Checking permissions | 0.02 ms |
Opening tables | 1.91 ms |
After opening tables | 0.02 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.01 ms |
Table lock | 0.06 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.81 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 1.05 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.03 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 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/blanktemplate/html/mod_languages/default.php:61 |
15 | require JROOT/templates/blanktemplate/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.17 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.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.57 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.90 ms |
End of update loop | 0.02 ms |
Query end | 0.05 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 |
---|---|---|
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.21 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.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.45 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.03 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 |
---|---|---|
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 `c2`.`language`,`c2`.`id`
FROM `zlaw_menu` AS `c`
INNER JOIN `zlaw_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `zlaw_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `zlaw_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 252
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.10 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 1.20 ms |
Preparing | 0.02 ms |
Executing | 0.03 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 |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
8 | MenusHelper::getAssociations() | JROOT/plugins/system/tbflanguagefilter/tbflanguagefilter.php:724 |
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 = 15
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 | 13 |
Status | Duration |
---|---|
Starting | 0.15 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.11 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 0.32 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 |
---|---|---|
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/blanktemplate/index.php:56 |
7 | require JROOT/templates/blanktemplate/index.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 = 15
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 | 12417 | Using where |
Status | Duration |
---|---|
Starting | 0.09 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.04 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 12.89 ms |
End of update loop | 0.09 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 2.81 ms |
Reset for next command | 0.03 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/blanktemplate/index.php:56 |
7 | require JROOT/templates/blanktemplate/index.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` = '670'
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.02 ms |
Opening tables | 0.09 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.13 ms |
Optimizing | 0.06 ms |
Statistics | 0.14 ms |
Preparing | 0.08 ms |
Creating tmp table | 0.15 ms |
Sorting result | 0.06 ms |
Executing | 0.01 ms |
Sending data | 5.09 ms |
Creating sort index | 0.24 ms |
Removing tmp table | 0.16 ms |
Creating sort index | 0.30 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.03 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.08 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 1.06 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/blanktemplate/index.php:56 |
7 | require JROOT/templates/blanktemplate/index.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 = 15
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.13 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.12 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.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.27 ms |
Reset for next command | 0.04 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/blanktemplate/index.php:57 |
7 | require JROOT/templates/blanktemplate/index.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 = 15
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 | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.15 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.02 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.29 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/blanktemplate/index.php:57 |
7 | require JROOT/templates/blanktemplate/index.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 = 15
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 | 3.17 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.07 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.06 ms |
Init | 0.05 ms |
Optimizing | 0.07 ms |
Statistics | 0.73 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.16 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.63 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/blanktemplate/index.php:156 |
7 | require JROOT/templates/blanktemplate/index.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.18 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 1.24 ms |
Preparing | 0.07 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
Creating sort index | 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.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.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 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.02 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.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 |
---|---|---|
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.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.02 ms |
Init | 0.03 ms |
Optimizing | 0.02 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.10 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.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: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.01 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 0.22 ms |
Preparing | 0.05 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.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: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.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.04 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.01 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 |
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 state
FROM `zlaw_tbsaas_company_bookbtns`
2 × SELECT COUNT(id)
FROM zlaw_tbsaas_cars
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_shuttle_routes
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 id,title,period,pickup_type,pickup_pois,pickup_zone_id,pickup_zone_ids
FROM zlaw_tbsaas_private_tours
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 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 `c2`.`language`,`c2`.`id`
FROM `zlaw_menu` AS `c`
INNER JOIN `zlaw_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `zlaw_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `zlaw_menu` AS `c2`
ON a2.id = c2.`id`
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'69636f346e716a39623230346c3035636d68696e397268373733', 1, 1716129983, 0, '', 0
1 × SHOW VARIABLES LIKE "collation_database
1 × UPDATE `zlaw_extensions`
SET `params` = '{\"mediaversion\":\"ac92538d015ba76afd0f34a0aa448d73\"}'
1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `zlaw_akeebasubs_subscriptions