Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.38 ms
(80.93%)
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
  381817
  386189
  389729
  400491
  400513
  401200
  411325
  415753
  420311
  422803
  424169
  424248
  429872
  429902
  430311
  438429
  440761
  441094
  442072
  442128
  444235
  447349
  448000
  450287
  452354
  452953
  454110
  456312
  459196
  461129
  462461
  463832
  465970
  466226
  466341
  466855
  468269
  471162
  472418
  472943
  473533
  476321
  477223
  484648
  500429
  500914
  502578
  506057
  509440
  509836
  510546
  513334
  517735
  521107
  527476
  532700
  532893
  534138
  537893
  538021
  540727
  548392
  549836
  557327
  562342
  563448
  565110
  566363
  567414
  567597
  574432
  578180
  586578
  588139
  593510
  594300
  600946
  605679
  607599
  619604
  624905
  649523
  659385
  660807
  662190
  664525
  664972
  665288
  667496
  669387
  669736
  694115
  698102
  704907
  714247
  714925
  714927
  716550
  724264
  730975
  731105
  733446
  741712
  742383
  748521
  760859
  774598
  781990
  788776
  796877
  796881
  803755
  804054
  804427
  808063
  808151
  815789
  825751
  826379
]
23.60 ms
(13.80%)
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
  509440
  452953
  381817
  444235
  438429
  430311
  440761
  415753
  424248
  825751
  459196
  468269
  447349
  448000
  540727
  472418
  565110
  566363
  548392
  567597
  660807
  664525
  665288
  716550
  714925
  662190
  664972
  669736
  694115
  549836
  567414
  574432
  588139
  605679
  600946
  593510
  594300
  803755
  804054
  804427
  808063
  724264
  730975
  731105
  788776
  733446
  741712
  742383
  748521
  607599
  704907
  714247
  774598
  424169
  429902
  454110
  465970
  429872
  466341
  400513
  420311
  456312
  506057
  502578
  521107
  513334
  477223
  484648
  400491
  401200
  472943
  826379
  386189
  422803
  442072
  441094
  442128
  815789
  450287
  473533
  452354
  466855
  471162
  476321
  500914
  537893
  538021
  500429
  509836
  510546
  517735
  527476
  532700
  532893
  534138
  461129
  462461
  557327
  562342
  563448
  578180
  649523
  659385
  667496
  669387
  624905
  619604
  586578
  796881
  787989
  760859
  698102
  714927
  781990
  796877
  808151
  389729
  411325
  463832
  466226
]
2.64 ms
(1.55%)
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
  381817
  386189
  389729
  400491
  400513
  401200
  411325
  415753
  420311
  422803
  424169
  424248
  429872
  429902
  430311
  438429
  440761
  441094
  442072
  442128
  444235
  447349
  448000
  450287
  452354
  452953
  454110
  456312
  459196
  461129
  462461
  463832
  465970
  466226
  466341
  466855
  468269
  471162
  472418
  472943
  473533
  476321
  477223
  484648
  500429
  500914
  502578
  506057
  509440
  509836
  510546
  513334
  517735
  521107
  527476
  532700
  532893
  534138
  537893
  538021
  540727
  548392
  549836
  557327
  562342
  563448
  565110
  566363
  567414
  567597
  574432
  578180
  586578
  588139
  593510
  594300
  600946
  605679
  607599
  619604
  624905
  649523
  659385
  660807
  662190
  664525
  664972
  665288
  667496
  669387
  669736
  694115
  698102
  704907
  714247
  714925
  714927
  716550
  724264
  730975
  731105
  733446
  741712
  742383
  748521
  760859
  774598
  781990
  788776
  796877
  796881
  803755
  804054
  804427
  808063
  808151
  815789
  825751
  826379
]
1.88 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby dildo"
]
1.68 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby дилд"
]
1.47 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby дилд"
]
1.32 ms
(0.77%)
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.