Yourfix - Uw winkelwagen

Avond reparatie

Onze winkels zijn voor vandaag alweer gesloten, maar geen paniek! Deze avond staat ons team voor u klaar tot 21:00 om alsnog uw telefoon te repareren op afspraak!

Bel ons direct: ‭‬‭‬‭06 15 25 26 70‬

Hieronder ziet u de artikelen die in uw winkelwagen zitten. Druk op het vergrootglas om meer informatie over het artikel/product te zien.

Soort	Omschrijving	Aantal	Prijs	Acties
U heeft nog geen producten in uw winkelwagen geplaatst.

(default) 5 queries took 2005 ms
Nr	Query	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 `Coupon`.`id`, `Coupon`.`name`, `Coupon`.`code`, `Coupon`.`valid_from`, `Coupon`.`valid_till`, `Coupon`.`user_id`, `Coupon`.`minimal_spending`, `Coupon`.`usage_limit`, `Coupon`.`once_user_limit`, `Coupon`.`auto_apply`, `Coupon`.`discount_money`, `Coupon`.`discount_percent`, `Coupon`.`active`, `Coupon`.`can_combine`, `Coupon`.`created` FROM `coupons` AS `Coupon` WHERE ((`Coupon`.`valid_from` IS NULL) OR (DATE(`Coupon`.`valid_from`) <= DATE(NOW()))) AND ((`Coupon`.`valid_till` IS NULL) OR (DATE(`Coupon`.`valid_till`) > DATE(NOW()))) AND ((`Coupon`.`user_id` IS NULL) OR (`Coupon`.`user_id` IS NULL)) AND ((`Coupon`.`minimal_spending` IS NULL) OR (`Coupon`.`minimal_spending` < 0)) AND ((`Coupon`.`usage_limit` IS NULL) OR (`Coupon`.`usage_limit` > (SELECT count(*) FROM invoice_coupons WHERE `invoice_coupons`.`coupon_id` = `Coupon`.`id`))) AND ((`Coupon`.`once_user_limit` IS NULL) OR (`Coupon`.`once_user_limit` = 0) OR (true)) AND ((`Coupon`.`code` IS NULL) OR (`Coupon`.`auto_apply` = 1)) AND `active` = 1 ORDER BY `Coupon`.`code` DESC, `Coupon`.`discount_money` DESC, `Coupon`.`discount_percent` DESC LIMIT 1	0	0	2001
4	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
5	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

(default) 5 queries took 2005 ms

Query

Error

Affected

Num. rows

Took (ms)

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

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

SELECT `Coupon`.`id`, `Coupon`.`name`, `Coupon`.`code`, `Coupon`.`valid_from`, `Coupon`.`valid_till`, `Coupon`.`user_id`, `Coupon`.`minimal_spending`, `Coupon`.`usage_limit`, `Coupon`.`once_user_limit`, `Coupon`.`auto_apply`, `Coupon`.`discount_money`, `Coupon`.`discount_percent`, `Coupon`.`active`, `Coupon`.`can_combine`, `Coupon`.`created` FROM `coupons` AS `Coupon` WHERE ((`Coupon`.`valid_from` IS NULL) OR (DATE(`Coupon`.`valid_from`) <= DATE(NOW()))) AND ((`Coupon`.`valid_till` IS NULL) OR (DATE(`Coupon`.`valid_till`) > DATE(NOW()))) AND ((`Coupon`.`user_id` IS NULL) OR (`Coupon`.`user_id` IS NULL)) AND ((`Coupon`.`minimal_spending` IS NULL) OR (`Coupon`.`minimal_spending` < 0)) AND ((`Coupon`.`usage_limit` IS NULL) OR (`Coupon`.`usage_limit` > (SELECT count(*) FROM invoice_coupons WHERE `invoice_coupons`.`coupon_id` = `Coupon`.`id`))) AND ((`Coupon`.`once_user_limit` IS NULL) OR (`Coupon`.`once_user_limit` = 0) OR (true)) AND ((`Coupon`.`code` IS NULL) OR (`Coupon`.`auto_apply` = 1)) AND `active` = 1 ORDER BY `Coupon`.`code` DESC, `Coupon`.`discount_money` DESC, `Coupon`.`discount_percent` DESC LIMIT 1

2001

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

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

YourFix - Uw winkelwagen