Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.74 ms
(85.56%)
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
  96029
  409506
  411884
  414306
  422340
  425206
  448825
  470034
  473010
  474649
  474652
  475776
  477879
  516073
  517842
  522823
  522859
  522880
  522887
  522901
  526894
  529243
  530010
  530489
  530941
  531089
  531223
  532264
  532720
  532737
  533063
  533697
  535048
  536586
  537200
  537763
  537771
  541822
  541846
  541884
  543475
  550194
  550205
  559161
  561117
  561131
  561135
  561140
  561142
  576727
  581383
  582323
  585446
  590411
  591692
  593441
  600185
  600295
  600321
  600352
  600355
  601625
  604513
  610692
  612343
  616336
  617418
  620130
  622373
  624155
  631170
  632571
  632600
  632636
  633124
  635188
  636303
  636304
  637103
  637434
  639706
  639717
  639823
  640755
  641683
  642002
  642064
  642378
  643731
  644961
  645952
  646229
  646771
  646786
  646899
  648252
  648815
  649106
  650476
  650846
  651079
  652223
  666549
  668528
  676110
  678493
  679733
  681455
  683261
  683831
  688624
  703833
  716882
  720260
  720288
  721611
  775958
  795593
  801471
  804464
]
16.97 ms
(9.20%)
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
  516073
  522887
  532737
  522880
  533697
  561117
  550205
  576727
  561131
  561135
  561140
  561142
  681455
  650846
  591692
  601625
  610692
  620130
  624155
  600295
  622373
  775958
  801471
  409506
  477879
  474652
  470034
  473010
  522823
  522859
  522901
  517842
  529243
  721611
  795593
  96029
  414306
  530941
  531089
  474649
  541884
  582323
  541846
  550194
  678493
  646771
  683261
  646229
  646786
  683831
  600185
  604513
  616336
  642002
  590411
  600321
  600355
  632636
  636304
  633124
  637434
  641683
  639717
  703833
  804464
  475776
  448825
  646899
  632571
  411884
  422340
  425206
  644961
  526894
  530010
  535048
  537763
  537771
  530489
  532264
  536586
  531223
  532720
  533063
  537200
  541822
  543475
  559161
  581383
  650476
  652223
  720260
  651079
  676110
  679733
  716882
  720288
  645952
  648252
  648815
  649106
  666549
  668528
  688624
  631170
  632600
  642064
  612343
  617418
  637103
  642378
  585446
  593441
  600352
  635188
  636303
  639706
  639823
  640755
  643731
]
2.75 ms
(1.49%)
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
  96029
  409506
  411884
  414306
  422340
  425206
  448825
  470034
  473010
  474649
  474652
  475776
  477879
  516073
  517842
  522823
  522859
  522880
  522887
  522901
  526894
  529243
  530010
  530489
  530941
  531089
  531223
  532264
  532720
  532737
  533063
  533697
  535048
  536586
  537200
  537763
  537771
  541822
  541846
  541884
  543475
  550194
  550205
  559161
  561117
  561131
  561135
  561140
  561142
  576727
  581383
  582323
  585446
  590411
  591692
  593441
  600185
  600295
  600321
  600352
  600355
  601625
  604513
  610692
  612343
  616336
  617418
  620130
  622373
  624155
  631170
  632571
  632600
  632636
  633124
  635188
  636303
  636304
  637103
  637434
  639706
  639717
  639823
  640755
  641683
  642002
  642064
  642378
  643731
  644961
  645952
  646229
  646771
  646786
  646899
  648252
  648815
  649106
  650476
  650846
  651079
  652223
  666549
  668528
  676110
  678493
  679733
  681455
  683261
  683831
  688624
  703833
  716882
  720260
  720288
  721611
  775958
  795593
  801471
  804464
]
1.90 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal mom"
]
1.67 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал mom"
]
1.67 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал mom"
]
1.66 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.