Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.17 ms
(82.53%)
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
  404766
  405272
  415577
  416965
  419988
  420262
  422299
  424527
  432081
  435664
  442042
  443833
  451004
  451965
  455438
  457629
  465358
  465834
  466157
  469424
  473725
  474820
  477230
  478332
  478458
  479196
  479811
  484689
  485622
  493160
  494702
  494983
  500699
  507973
  509543
  512527
  514644
  514997
  515633
  517414
  520597
  521131
  521653
  522403
  523995
  524528
  525693
  525966
  526811
  527614
  536371
  541242
  542941
  543419
  549246
  549248
  549857
  550436
  550853
  551487
  551913
  554370
  559121
  561071
  561576
  561853
  561888
  565178
  566248
  566536
  567148
  574396
  575794
  576286
  576308
  576653
  580952
  589642
  589825
  590884
  591135
  595799
  596693
  596904
  597002
  597042
  597533
  598263
  601699
  603255
  603971
  608416
  610606
  613171
  615938
  615975
  616800
  617597
  617674
  619038
  619539
  620052
  621228
  621988
  623678
  624030
  625001
  625870
  625884
  649123
  652263
  652893
  653459
  654322
  654352
  659216
  659328
  663421
  667233
  759691
]
23.79 ms
(11.21%)
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
  422299
  465358
  473725
  451004
  484689
  493160
  485622
  615975
  442042
  416965
  451965
  479811
  542941
  565178
  549857
  561071
  759691
  415577
  478332
  455438
  465834
  520597
  525966
  509543
  591135
  549248
  576308
  494702
  435664
  474820
  550853
  478458
  527614
  659328
  549246
  526811
  443833
  457629
  521653
  515633
  541242
  561888
  559121
  580952
  596693
  432081
  525693
  574396
  663421
  596904
  601699
  466157
  514644
  536371
  610606
  625001
  479196
  595799
  654352
  649123
  667233
  597042
  620052
  589825
  597533
  616800
  597002
  619038
  514997
  575794
  652893
  654322
  419988
  424527
  507973
  517414
  494983
  561853
  566248
  576286
  566536
  652263
  653459
  659216
  624030
  590884
  603971
  625870
  608416
  613171
  615938
  617597
  621988
  420262
  404766
  405272
  469424
  500699
  521131
  550436
  551487
  551913
  576653
  554370
  567148
  598263
  623678
  589642
  621228
  625884
  603255
  617674
  619539
  477230
  522403
  524528
  512527
  523995
  561576
  543419
]
5.57 ms
(2.63%)
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
  404766
  405272
  415577
  416965
  419988
  420262
  422299
  424527
  432081
  435664
  442042
  443833
  451004
  451965
  455438
  457629
  465358
  465834
  466157
  469424
  473725
  474820
  477230
  478332
  478458
  479196
  479811
  484689
  485622
  493160
  494702
  494983
  500699
  507973
  509543
  512527
  514644
  514997
  515633
  517414
  520597
  521131
  521653
  522403
  523995
  524528
  525693
  525966
  526811
  527614
  536371
  541242
  542941
  543419
  549246
  549248
  549857
  550436
  550853
  551487
  551913
  554370
  559121
  561071
  561576
  561853
  561888
  565178
  566248
  566536
  567148
  574396
  575794
  576286
  576308
  576653
  580952
  589642
  589825
  590884
  591135
  595799
  596693
  596904
  597002
  597042
  597533
  598263
  601699
  603255
  603971
  608416
  610606
  613171
  615938
  615975
  616800
  617597
  617674
  619038
  619539
  620052
  621228
  621988
  623678
  624030
  625001
  625870
  625884
  649123
  652263
  652893
  653459
  654322
  654352
  659216
  659328
  663421
  667233
  759691
]
2.24 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "язык поцелуй"
]
1.94 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "язык поцел"
]
1.75 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.