Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.37 ms
(84.31%)
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
  388604
  389458
  392787
  395924
  397530
  402383
  409004
  410806
  416408
  421236
  421780
  421892
  422187
  422261
  424798
  426701
  428547
  428853
  430313
  430433
  433310
  433350
  433977
  434003
  435934
  437497
  437582
  439587
  439743
  443183
  446269
  447163
  449710
  451165
  455957
  456605
  457686
  458018
  459783
  460370
  463691
  464329
  467294
  476628
  477337
  482251
  482629
  483356
  483449
  486902
  493213
  495394
  497104
  504968
  505973
  506131
  508701
  511369
  512212
  512556
  512895
  516226
  517011
  517428
  518046
  520203
  520683
  521520
  521997
  523829
  524626
  528390
  528858
  531996
  532682
  535335
  537123
  538002
  543773
  543794
  562990
  564378
  565626
  569394
  579209
  591258
  600965
  614772
  622670
  628696
  630630
  645883
  659986
  663969
  676591
  682181
  695087
  696567
  699604
  709503
  710588
  711341
  716915
  716921
  720258
  723945
  724456
  729635
  743463
  756797
  758564
  769490
  775261
  788559
  813913
  824810
]
15.13 ms
(8.96%)
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
  724456
  723945
  699604
  428547
  527201
  630630
  622670
  775261
  543794
  483449
  421780
  422261
  788559
  439743
  676591
  457686
  482629
  506131
  512895
  455957
  456605
  486902
  591258
  523829
  388604
  543773
  562990
  720258
  433977
  421236
  493213
  628696
  729635
  426701
  428853
  389458
  449710
  422187
  769490
  697939
  402383
  409004
  451165
  716915
  614772
  435934
  537123
  424798
  659986
  430433
  538002
  483356
  460370
  531996
  512212
  476628
  433310
  437497
  416408
  521520
  520203
  495394
  410806
  467294
  517011
  463691
  458018
  516226
  600965
  433350
  392787
  443183
  716921
  756797
  711341
  682181
  564378
  528390
  813913
  447163
  512556
  511369
  504968
  434003
  517428
  565626
  421892
  520683
  535335
  824810
  695087
  696567
  743463
  758564
  709503
  508701
  497104
  645883
  446269
  524626
  482251
  477337
  518046
  521997
  505973
  532682
  559076
  395924
  569394
  579209
  716936
  663969
  710588
  459783
  437582
  528858
  397530
  430313
  464329
  439587
]
3.01 ms
(1.78%)
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
  388604
  389458
  392787
  395924
  397530
  402383
  409004
  410806
  416408
  421236
  421780
  421892
  422187
  422261
  424798
  426701
  428547
  428853
  430313
  430433
  433310
  433350
  433977
  434003
  435934
  437497
  437582
  439587
  439743
  443183
  446269
  447163
  449710
  451165
  455957
  456605
  457686
  458018
  459783
  460370
  463691
  464329
  467294
  476628
  477337
  482251
  482629
  483356
  483449
  486902
  493213
  495394
  497104
  504968
  505973
  506131
  508701
  511369
  512212
  512556
  512895
  516226
  517011
  517428
  518046
  520203
  520683
  521520
  521997
  523829
  524626
  528390
  528858
  531996
  532682
  535335
  537123
  538002
  543773
  543794
  562990
  564378
  565626
  569394
  579209
  591258
  600965
  614772
  622670
  628696
  630630
  645883
  659986
  663969
  676591
  682181
  695087
  696567
  699604
  709503
  710588
  711341
  716915
  716921
  720258
  723945
  724456
  729635
  743463
  756797
  758564
  769490
  775261
  788559
  813913
  824810
]
2.63 ms
(1.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son дрочк член"
]
2.01 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son дрочк член"
]
2.01 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son handjob"
]
1.70 ms
(1.01%)
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.