Bel nu 072 - 582 4996 (Alkmaar)
072 - 574 3060 (Heerhugowaard)
0224 - 745 223 (Schagen)
 |
LG |
 |
LG G6 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `User`.`id`, `User`.`jid`, `User`.`email`, `User`.`pin`, `User`.`enabled`, `User`.`company_name`, `User`.`last_ip`, `User`.`receive_email`, `User`.`password`, `User`.`level`, `User`.`firstname`, `User`.`lastname`, `User`.`address`, `User`.`city`, `User`.`zipcode`, `User`.`telephone`, `User`.`temporarily`, `User`.`hash`, `User`.`tablet_registration`, `User`.`admin_registration`, `User`.`location_id`, `User`.`comment`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`lastname`, ', ', `User`.`firstname`)) AS `User__name`, ((SELECT IFNULL(SUM(`UserPoint`.`points`), 0) FROM user_points as UserPoint WHERE `UserPoint`.`user_id` = `User`.`id` AND `UserPoint`.`redeem_date` >= DATE_SUB(NOW(),INTERVAL 1 YEAR))) AS `User__points`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `users` AS `User` LEFT JOIN `locations` AS `Location` ON (`User`.`location_id` = `Location`.`id`) WHERE `User`.`id` IS NULL LIMIT 1 | 0 | 0 | 1 | |
| 2 | SELECT `Setting`.`title`, `Setting`.`id`, `Setting`.`contact_email`, `Setting`.`homepage_text`, `Setting`.`termsconditions`, `Setting`.`price_text`, `Setting`.`title_users`, `Setting`.`title_pricing`, `Setting`.`title_services`, `Setting`.`title_pages`, `Setting`.`title_news`, `Setting`.`show_notification`, `Setting`.`notification`, `Setting`.`insurance_text`, `Setting`.`service_text`, `Setting`.`meta_description`, `Setting`.`show_big_notification`, `Setting`.`big_notification_title`, `Setting`.`big_notification`, `Setting`.`shipping_costs_limit`, `Setting`.`shipping_costs`, `Setting`.`point_amount_needed`, `Setting`.`money_for_point`, `Setting`.`give_points`, `Setting`.`default_tax`, `Setting`.`invoice_footer`, `Setting`.`promo_code_display`, `Setting`.`promo_code_header`, `Setting`.`promo_code_content`, `Setting`.`coupon_price_minimal`, `Setting`.`quotation_price`, `Setting`.`popup_work_night` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 1 | |
| 3 | SELECT `RepairBrand`.`id`, `RepairBrand`.`name`, `RepairBrand`.`image`, `RepairBrand`.`order`, `RepairBrand`.`active` FROM `repair_brands` AS `RepairBrand` WHERE `RepairBrand`.`id` = 7 LIMIT 1 | 1 | 1 | 1 | |
| 4 | SELECT `RepairProduct`.`id`, `RepairProduct`.`repair_brand_id`, `RepairProduct`.`repair_product_group_id`, `RepairProduct`.`name`, `RepairProduct`.`seo_name`, `RepairProduct`.`image`, `RepairProduct`.`has_big_image`, `RepairProduct`.`order`, `RepairProduct`.`active` FROM `repair_products` AS `RepairProduct` WHERE `RepairProduct`.`id` = 110 LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `RepairProblem`.`id`, `RepairProblem`.`repair_product_id`, `RepairProblem`.`title`, `RepairProblem`.`content`, `RepairProblem`.`description`, `RepairProblem`.`image`, `RepairProblem`.`repair_time`, `RepairProblem`.`in_stock`, `RepairProblem`.`price`, `RepairProblem`.`order`, `RepairProblem`.`views`, `RepairProblem`.`is_customer_orderable`, `RepairProblem`.`is_preview`, `RepairProblem`.`barcode`, `RepairProduct`.`id`, `RepairProduct`.`repair_brand_id`, `RepairProduct`.`repair_product_group_id`, `RepairProduct`.`name`, `RepairProduct`.`seo_name`, `RepairProduct`.`image`, `RepairProduct`.`has_big_image`, `RepairProduct`.`order`, `RepairProduct`.`active` FROM `repair_problems` AS `RepairProblem` LEFT JOIN `repair_products` AS `RepairProduct` ON (`RepairProblem`.`repair_product_id` = `RepairProduct`.`id`) WHERE `RepairProblem`.`repair_product_id` = 110 ORDER BY `RepairProblem`.`order` ASC, `RepairProblem`.`title` ASC | 1 | 1 | 1 | |
| 6 | SELECT `Tags`.`id`, `Tags`.`name`, `RepairProblemTag`.`id`, `RepairProblemTag`.`repair_problem_id`, `RepairProblemTag`.`tag_id` FROM `tags` AS `Tags` JOIN `repair_problem_tags` AS `RepairProblemTag` ON (`RepairProblemTag`.`repair_problem_id` = 351 AND `RepairProblemTag`.`tag_id` = `Tags`.`id`) | 0 | 0 | 0 | |
| 7 | SELECT `Stock`.`id`, `Stock`.`name`, `Stock`.`stock`, `Stock`.`cost`, `Stock`.`location_id`, `Stock`.`barcode`, `Stock`.`customer_price`, `Stock`.`modified`, `Stock`.`created`, `RepairProblemStock`.`id`, `RepairProblemStock`.`repair_problem_id`, `RepairProblemStock`.`stock_id` FROM `stocks` AS `Stock` JOIN `repair_problem_stocks` AS `RepairProblemStock` ON (`RepairProblemStock`.`repair_problem_id` = 351 AND `RepairProblemStock`.`stock_id` = `Stock`.`id`) | 0 | 0 | 0 | |
| 8 | SELECT `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `timetable` AS `Timetable` LEFT JOIN `locations` AS `Location` ON (`Timetable`.`location_id` = `Location`.`id`) WHERE `Timetable`.`tue_popup` = 1 AND `Timetable`.`tue_closedallday` = 0 AND `Timetable`.`tue_closed` > '18:00:00' AND `Timetable`.`tue_closed` > CURTIME() AND CURTIME() > '18:00:00' AND `Location`.`is_store` = 1 | 0 | 0 | 1 | |
| 9 | SELECT `Timetable`.`id`, `Timetable`.`location_id`, `Timetable`.`mon_open`, `Timetable`.`mon_closed`, `Timetable`.`mon_closedallday`, `Timetable`.`mon_popup`, `Timetable`.`tue_open`, `Timetable`.`tue_closed`, `Timetable`.`tue_closedallday`, `Timetable`.`tue_popup`, `Timetable`.`wed_open`, `Timetable`.`wed_closed`, `Timetable`.`wed_closedallday`, `Timetable`.`wed_popup`, `Timetable`.`thu_open`, `Timetable`.`thu_closed`, `Timetable`.`thu_closedallday`, `Timetable`.`thu_popup`, `Timetable`.`fri_open`, `Timetable`.`fri_closed`, `Timetable`.`fri_closedallday`, `Timetable`.`fri_popup`, `Timetable`.`sat_open`, `Timetable`.`sat_closed`, `Timetable`.`sat_closedallday`, `Timetable`.`sat_popup`, `Timetable`.`sun_open`, `Timetable`.`sun_closed`, `Timetable`.`sun_closedallday`, `Timetable`.`sun_popup`, `Timetable`.`message`, `Timetable`.`modified`, `Location`.`id`, `Location`.`is_store`, `Location`.`name`, `Location`.`invoice_prefix`, `Location`.`picture_url`, `Location`.`title`, `Location`.`address`, `Location`.`zipcode`, `Location`.`city`, `Location`.`phone`, `Location`.`mobile`, `Location`.`email`, `Location`.`owner_name`, `Location`.`kvk`, `Location`.`btw_number`, `Location`.`bank_name`, `Location`.`bank_owner_name`, `Location`.`bank_number`, `Location`.`bank_iban`, `Location`.`order`, `Location`.`gcp_refresh_token`, `Location`.`facebook_access_token`, `Location`.`facebook_token_is_valid`, `Location`.`facebook_page_id`, `Location`.`facebook_page_access_token`, `Location`.`created` FROM `timetable` AS `Timetable` LEFT JOIN `locations` AS `Location` ON (`Timetable`.`location_id` = `Location`.`id`) WHERE `Location`.`is_store` = 1 AND `Timetable`.`tue_closedallday` = 0 ORDER BY `Timetable`.`tue_closed` DESC LIMIT 1 | 1 | 1 | 1 |
Winkelmandje (0)
Account