Query Metrics

7 Database Queries
7 Different statements
178.83 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
155.17 ms
(86.77%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  393265
  397686
  398009
  421762
  421763
  443051
  449472
  450929
  451879
  452737
  452744
  452756
  459090
  469768
  485220
  493079
  496467
  499911
  507481
  508696
  529124
  536216
  538619
  546850
  551662
  554846
  558265
  571946
  587967
  600235
  614900
  616312
  622304
  627362
  628942
  644883
  647249
  669309
  675159
  678238
  699519
  699543
  703314
  714953
  715779
  719233
  719972
  730341
  730355
  731117
  732200
  732752
  733594
  734061
  734534
  736112
  736310
  736321
  738463
  738514
  738911
  739665
  739887
  740280
  741266
  742987
  743774
  747002
  749303
  751742
  753172
  757914
  760278
  761437
  761784
  762306
  762525
  762529
  762564
  765386
  765402
  767663
  767740
  772276
  772345
  772364
  772368
  772389
  773757
  778079
  780238
  780260
  782418
  783876
  785299
  785617
  787571
  787647
  791629
  791780
  793084
  793971
  795698
  797174
  797903
  797929
  798566
  798619
  800036
  805256
  805258
  809590
  810367
  811027
  813193
  813214
  824336
  825452
  825891
]
13.62 ms
(7.61%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  800036
  778079
  780238
  791629
  793084
  798566
  734534
  736310
  753172
  772368
  785617
  797903
  810367
  731117
  739665
  747002
  738911
  743774
  751742
  762306
  767663
  767740
  734061
  749303
  761437
  765402
  614900
  715779
  782418
  791780
  811027
  450929
  398009
  785299
  805256
  587967
  742987
  421762
  529124
  538619
  571946
  554846
  699519
  647249
  703314
  719233
  699543
  714953
  719972
  622304
  616312
  600235
  797174
  797929
  736321
  760278
  761784
  772345
  787571
  730355
  738514
  740280
  741266
  762525
  772389
  738463
  757914
  772364
  730341
  732200
  736112
  762529
  765386
  772276
  773757
  780260
  793971
  798619
  813214
  496467
  825452
  828018
  644883
  536216
  628942
  809590
  787647
  732752
  739887
  452756
  397686
  824336
  783876
  795698
  762564
  813193
  825891
  805258
  627362
  733594
  393265
  421763
  443051
  449472
  459090
  485220
  451879
  452737
  469768
  452744
  499911
  507481
  508696
  493079
  546850
  551662
  558265
  669309
  675159
  678238
]
3.10 ms
(1.73%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  393265
  397686
  398009
  421762
  421763
  443051
  449472
  450929
  451879
  452737
  452744
  452756
  459090
  469768
  485220
  493079
  496467
  499911
  507481
  508696
  529124
  536216
  538619
  546850
  551662
  554846
  558265
  571946
  587967
  600235
  614900
  616312
  622304
  627362
  628942
  644883
  647249
  669309
  675159
  678238
  699519
  699543
  703314
  714953
  715779
  719233
  719972
  730341
  730355
  731117
  732200
  732752
  733594
  734061
  734534
  736112
  736310
  736321
  738463
  738514
  738911
  739665
  739887
  740280
  741266
  742987
  743774
  747002
  749303
  751742
  753172
  757914
  760278
  761437
  761784
  762306
  762525
  762529
  762564
  765386
  765402
  767663
  767740
  772276
  772345
  772364
  772368
  772389
  773757
  778079
  780238
  780260
  782418
  783876
  785299
  785617
  787571
  787647
  791629
  791780
  793084
  793971
  795698
  797174
  797903
  797929
  798566
  798619
  800036
  805256
  805258
  809590
  810367
  811027
  813193
  813214
  824336
  825452
  825891
]
1.93 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum close up"
]
1.75 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum close up"
]
1.40 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum close up"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.