Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.42 ms
(85.35%)
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
  398224
  401957
  401971
  402145
  411591
  413182
  420540
  422345
  430351
  433070
  434097
  438199
  439717
  443149
  443692
  443747
  445620
  450399
  453013
  454029
  454041
  454043
  454257
  455320
  458011
  458724
  460181
  460184
  460191
  460204
  461017
  461350
  461371
  461727
  463216
  464144
  464332
  464354
  464963
  468720
  469383
  469466
  471397
  471408
  471609
  472691
  473492
  474778
  475051
  476256
  477726
  482251
  482386
  483496
  492115
  492138
  492366
  495229
  496112
  504104
  505748
  506126
  506127
  507895
  513376
  514813
  517281
  518856
  519938
  521264
  524626
  525273
  527155
  528847
  531919
  532044
  537161
  546115
  549236
  551923
  555158
  559048
  561463
  562884
  563141
  563437
  563453
  563455
  569970
  576265
  584765
  587915
  589628
  605484
  608350
  622670
  630630
  639152
  687437
  706294
  721724
  724371
  726577
  736399
  742545
  748228
  748231
  748239
  753205
  756803
  763845
  772466
  776462
  788559
  800190
  801235
  807485
  812885
]
15.96 ms
(8.99%)
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
  455320
  460181
  460204
  461350
  461371
  463216
  464144
  483496
  453013
  454043
  458011
  468720
  469383
  474778
  507895
  518856
  495229
  506127
  514813
  527201
  531919
  537161
  521264
  525273
  527155
  528847
  496112
  504104
  506126
  517281
  519938
  524626
  532044
  461017
  461727
  464332
  464963
  473492
  475051
  492138
  492366
  549236
  559048
  584765
  551923
  561463
  563437
  546115
  563455
  576265
  687437
  676582
  706294
  721724
  555158
  562884
  563141
  563453
  569970
  587915
  630630
  589628
  605484
  788559
  801235
  753205
  772466
  812885
  736399
  748228
  748231
  748239
  756803
  724371
  763845
  726577
  742545
  608350
  622670
  639152
  776462
  800190
  807485
  398224
  401957
  402145
  420540
  422345
  443149
  443747
  464354
  469466
  472691
  482251
  482386
  401971
  438199
  460191
  471408
  454029
  458724
  460184
  471397
  471609
  476256
  411591
  413182
  430351
  434097
  443692
  454257
  477726
  433070
  439717
  445620
  450399
  454041
  505748
  492115
  513376
]
2.91 ms
(1.64%)
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
  398224
  401957
  401971
  402145
  411591
  413182
  420540
  422345
  430351
  433070
  434097
  438199
  439717
  443149
  443692
  443747
  445620
  450399
  453013
  454029
  454041
  454043
  454257
  455320
  458011
  458724
  460181
  460184
  460191
  460204
  461017
  461350
  461371
  461727
  463216
  464144
  464332
  464354
  464963
  468720
  469383
  469466
  471397
  471408
  471609
  472691
  473492
  474778
  475051
  476256
  477726
  482251
  482386
  483496
  492115
  492138
  492366
  495229
  496112
  504104
  505748
  506126
  506127
  507895
  513376
  514813
  517281
  518856
  519938
  521264
  524626
  525273
  527155
  528847
  531919
  532044
  537161
  546115
  549236
  551923
  555158
  559048
  561463
  562884
  563141
  563437
  563453
  563455
  569970
  576265
  584765
  587915
  589628
  605484
  608350
  622670
  630630
  639152
  687437
  706294
  721724
  724371
  726577
  736399
  742545
  748228
  748231
  748239
  753205
  756803
  763845
  772466
  776462
  788559
  800190
  801235
  807485
  812885
]
1.86 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son жоп"
]
1.81 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son ass"
]
1.64 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son жоп"
]

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.