Time ms | SQL Statement | Params | Rows |
---|
0,373 explain ► | SELECT `id`, `created`, `content`, `title`
FROM `article`
WHERE (`type` = ?) AND (`public` = ?)
ORDER BY `created` DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | article | ALL | | | | | 65 | Using where; Using filesort | .../app/presenters/BasePresenter.php | 1
1
| 61 |
0,273 explain ► | SELECT `id`, `content`
FROM `article`
WHERE (`id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | article | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/presenters/BasePresenter.php | 48
| 1 |
0,195 explain ► | SELECT `id`, `content`
FROM `article`
WHERE (`id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | article | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/presenters/BasePresenter.php | 49
| 1 |
0,326 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 1
| 1 |
0,253 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 105
1
| 1 |
1,752 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 105
1
| 1 |
0,163 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (99))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,180 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 2
| 1 |
0,204 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 100
1
| 1 |
0,164 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 100
1
| 1 |
0,186 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (94))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,199 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 3
| 1 |
5,222 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 102
1
| 1 |
0,170 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 102
1
| 1 |
0,181 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (96))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,193 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 4
| 1 |
0,166 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 87
1
| 1 |
0,205 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 87
1
| 1 |
0,164 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (81))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,211 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 5
| 1 |
0,469 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 107
1
| 1 |
0,180 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 107
1
| 1 |
0,271 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (101))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,192 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 6
| 1 |
2,302 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 108
1
| 1 |
0,830 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 108
1
| 1 |
0,179 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (102))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,155 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 7
| 1 |
0,186 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 88
1
| 1 |
0,160 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 88
1
| 1 |
0,209 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (82))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,173 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 8
| 1 |
0,176 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 99
1
| 1 |
0,112 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 99
1
| 1 |
0,165 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (93))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,204 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 9
| 1 |
0,152 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 101
1
| 1 |
0,158 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 101
1
| 1 |
0,166 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (95))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,131 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 10
| 1 |
0,202 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 103
1
| 1 |
0,174 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 103
1
| 1 |
0,140 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (97))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,223 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 11
| 1 |
0,151 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 104
1
| 1 |
0,175 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 104
1
| 1 |
0,138 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (98))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
5,308 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 12
| 1 |
0,181 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 106
1
| 1 |
0,151 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 106
1
| 1 |
0,186 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (100))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |
0,202 explain ► | SELECT `id_position`, `id_photogallery_text`
FROM `photogallery_position`
WHERE (`id_position` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_position | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 13
| 1 |
0,149 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 109
1
| 1 |
0,191 explain ► | SELECT `id`, `photogallery_id`, `name`, `label`, `subname`
FROM `photogallery_text`
WHERE (`id` = ?) AND (`lang_id` = ?)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery_text | const | PRIMARY,lang | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | 109
1
| 1 |
0,163 explain ► | SELECT `id`, `cover`
FROM `photogallery`
WHERE (`id` IN (103))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | photogallery | const | PRIMARY | PRIMARY | 4 | const | 1 | | .../app/model/Photogalleries.php | | 1 |