Der neue Blickwinkel
für Schutz und Sicherheit!
Der neue Blickwinkel
für Schutz und Sicherheit!

Referenzen - Einzelhandelsschutz


< zurück
| |
weiter >
(default) 6 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `references`991
2DESCRIBE `reference_categories`771
3SELECT COUNT(*) AS `count` FROM `references` AS `Reference` LEFT JOIN `reference_categories` AS `ReferenceCategory` ON (`Reference`.`reference_category_id` = `ReferenceCategory`.`id`) WHERE `ReferenceCategory`.`url` IS NULL 110
4SELECT `Reference`.`id`, `Reference`.`reference_category_id`, `Reference`.`name`, `Reference`.`url`, `Reference`.`image`, `Reference`.`file`, `Reference`.`date`, `Reference`.`created`, `Reference`.`modified`, `ReferenceCategory`.`id`, `ReferenceCategory`.`order`, `ReferenceCategory`.`name`, `ReferenceCategory`.`url`, `ReferenceCategory`.`image`, `ReferenceCategory`.`created`, `ReferenceCategory`.`modified` FROM `references` AS `Reference` LEFT JOIN `reference_categories` AS `ReferenceCategory` ON (`Reference`.`reference_category_id` = `ReferenceCategory`.`id`) WHERE `ReferenceCategory`.`url` IS NULL ORDER BY IF(`Reference`.`date` IS NULL OR `Reference`.`modified` IS NULL, COALESCE(TIMESTAMP(`Reference`.`date`), TIMESTAMP(`Reference`.`modified`)), GREATEST(TIMESTAMP(`Reference`.`date`), TIMESTAMP(`Reference`.`modified`))) DESC LIMIT 15000
5SELECT `ReferenceCategory`.`id`, `ReferenceCategory`.`order`, `ReferenceCategory`.`name`, `ReferenceCategory`.`url`, `ReferenceCategory`.`image`, `ReferenceCategory`.`created`, `ReferenceCategory`.`modified` FROM `reference_categories` AS `ReferenceCategory` WHERE 1 = 1 ORDER BY `order` ASC 550
6SELECT `ReferenceCategory`.`id`, `ReferenceCategory`.`order`, `ReferenceCategory`.`name`, `ReferenceCategory`.`url`, `ReferenceCategory`.`image`, `ReferenceCategory`.`created`, `ReferenceCategory`.`modified` FROM `reference_categories` AS `ReferenceCategory` WHERE 1 = 1 ORDER BY `order` ASC 550