(default) 10 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `fietsenm_cphp`.`cphp_users` AS `User` WHERE `User`.`id` = 1213110
2SELECT `User`.`id`, `User`.`email`, `User`.`password`, `User`.`hash`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`slug`, `User`.`firstname`, `User`.`lastname`, `User`.`phone`, `User`.`website`, `User`.`street`, `User`.`housenumber`, `User`.`zipcode`, `User`.`city`, `User`.`country`, `User`.`about`, `User`.`logo_filename`, `User`.`news`, `User`.`news_partner`, `User`.`is_hidden`, `User`.`is_restricted`, `User`.`lat`, `User`.`lon`, `User`.`role`, `User`.`login_id` FROM `fietsenm_cphp`.`cphp_users` AS `User` WHERE `User`.`id` = 1213 LIMIT 1110
3BEGIN110
4INSERT INTO `fietsenm_cphp`.`cphp_stats` (`type`, `entity`, `entity_id`, `user_agent`, `user_ip`, `created`) VALUES ('view', 'user', 1213, 'CCBot/2.0 (https://commoncrawl.org/faq/)', '54.235.55.253', '2019-02-23 11:25:23')110
5COMMIT110
6SELECT `OpeningHour`.`id`, `OpeningHour`.`day`, `OpeningHour`.`from`, `OpeningHour`.`to`, `OpeningHour`.`user_id` FROM `fietsenm_cphp`.`cphp_opening_hours` AS `OpeningHour` WHERE `OpeningHour`.`user_id` = 1213000
7SELECT `Product`.*, `Type`.*, `Frame`.*, `Brand`.*, `Exemplar`.*, `User`.* FROM `fietsenm_cphp`.`cphp_products` AS `Product` INNER JOIN `fietsenm_cphp`.`cphp_users` AS `User` ON (`User`.`id` = `Product`.`user_id`) INNER JOIN `fietsenm_cphp`.`cphp_types` AS `Type` ON (`Type`.`id` = `Product`.`type_id`) LEFT OUTER JOIN `fietsenm_cphp`.`cphp_frames` AS `Frame` ON (`Frame`.`id` = `Product`.`frame_id`) LEFT OUTER JOIN `fietsenm_cphp`.`cphp_brands` AS `Brand` ON (`Brand`.`id` = `Product`.`brand_id`) LEFT OUTER JOIN `fietsenm_cphp`.`cphp_exemplars` AS `Exemplar` ON (`Exemplar`.`id` = `Product`.`exemplar_id`) WHERE `Product`.`user_id` = 1213 AND `Product`.`is_deleted` = '0' ORDER BY `Product`.`created` desc113
8SELECT `Product`.`slug`, `Type`.`slug`, `Frame`.`slug`, `Brand`.`slug`, `Product`.`is_used` FROM `fietsenm_cphp`.`cphp_products` AS `Product` INNER JOIN `fietsenm_cphp`.`cphp_types` AS `Type` ON (`Type`.`id` = `Product`.`type_id`) LEFT OUTER JOIN `fietsenm_cphp`.`cphp_frames` AS `Frame` ON (`Frame`.`id` = `Product`.`frame_id`) LEFT OUTER JOIN `fietsenm_cphp`.`cphp_brands` AS `Brand` ON (`Brand`.`id` = `Product`.`brand_id`) WHERE `Product`.`id` = 533 LIMIT 1110
9SELECT `ProductImage`.`filename` FROM `fietsenm_cphp`.`cphp_product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = 533 ORDER BY `ProductImage`.`sort_order` asc LIMIT 1110
10SELECT `Postcode`.`id`, `Postcode`.`postcode`, `Postcode`.`postcode_id`, `Postcode`.`pnum`, `Postcode`.`pchar`, `Postcode`.`minnumber`, `Postcode`.`maxnumber`, `Postcode`.`numbertype`, `Postcode`.`street`, `Postcode`.`city`, `Postcode`.`city_id`, `Postcode`.`municipality`, `Postcode`.`municipality_id`, `Postcode`.`province`, `Postcode`.`province_code`, `Postcode`.`lat`, `Postcode`.`lon`, `Postcode`.`rd_x`, `Postcode`.`rd_y`, `Postcode`.`location_detail`, `Postcode`.`changed_date` FROM `fietsenm_cphp`.`cphp_postcodes` AS `Postcode` WHERE `Postcode`.`postcode_id` = 35418277110