Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.96 ms
(84.42%)
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
  7166
  382744
  404710
  414944
  420702
  420717
  422415
  422790
  426875
  432285
  432673
  435573
  436964
  441535
  441780
  449930
  450331
  450448
  451701
  453115
  454814
  460950
  461044
  461612
  468812
  469665
  472621
  479833
  483245
  484272
  484514
  486613
  490257
  490635
  491632
  493016
  494662
  496846
  498945
  502765
  506268
  507033
  508654
  509324
  510737
  513637
  517805
  519369
  522287
  524839
  527316
  532197
  532451
  533263
  540915
  546315
  547766
  548374
  552537
  555194
  556329
  556492
  556905
  557335
  559311
  560672
  562819
  562988
  563273
  563300
  563365
  563684
  565011
  566585
  568591
  569527
  572279
  573472
  576543
  578761
  578780
  584088
  585171
  589159
  590459
  591186
  594536
  595178
  595266
  600690
  605503
  616676
  617063
  620411
  622286
  622415
  651868
  660769
  667987
  670272
  682988
  705435
  709105
  712939
  716229
  729053
  730060
  742127
  742305
  748112
  750363
  759346
  760428
  778828
  781585
  794401
  795609
  796360
  803785
  810859
]
12.92 ms
(8.73%)
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
  569527
  560672
  670272
  716229
  562988
  585171
  760428
  451701
  461612
  524839
  506268
  508654
  517805
  483245
  484272
  513637
  527316
  590459
  616676
  559311
  572279
  617063
  432285
  422415
  426875
  507033
  563300
  578780
  469665
  742127
  491632
  682988
  781585
  660769
  795609
  796360
  730060
  803785
  810859
  729053
  750363
  422790
  436964
  461044
  460950
  548374
  595266
  7166
  705435
  759346
  748112
  414944
  794401
  450448
  432673
  486613
  449930
  540915
  576543
  552537
  556492
  565011
  594536
  404710
  468812
  620411
  622415
  566585
  496846
  556905
  555194
  532197
  563684
  562819
  591186
  600690
  420702
  556329
  568591
  589159
  441535
  441780
  484514
  498945
  532451
  479833
  563365
  584088
  578761
  709105
  712939
  667987
  622286
  742305
  778828
  490635
  493016
  510737
  519369
  547766
  557335
  546315
  509324
  450331
  533263
  563273
  651868
  573472
  605503
  435573
  595178
  522287
  382744
  420717
  472621
  453115
  454814
  494662
  502765
  490257
]
3.11 ms
(2.10%)
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
  7166
  382744
  404710
  414944
  420702
  420717
  422415
  422790
  426875
  432285
  432673
  435573
  436964
  441535
  441780
  449930
  450331
  450448
  451701
  453115
  454814
  460950
  461044
  461612
  468812
  469665
  472621
  479833
  483245
  484272
  484514
  486613
  490257
  490635
  491632
  493016
  494662
  496846
  498945
  502765
  506268
  507033
  508654
  509324
  510737
  513637
  517805
  519369
  522287
  524839
  527316
  532197
  532451
  533263
  540915
  546315
  547766
  548374
  552537
  555194
  556329
  556492
  556905
  557335
  559311
  560672
  562819
  562988
  563273
  563300
  563365
  563684
  565011
  566585
  568591
  569527
  572279
  573472
  576543
  578761
  578780
  584088
  585171
  589159
  590459
  591186
  594536
  595178
  595266
  600690
  605503
  616676
  617063
  620411
  622286
  622415
  651868
  660769
  667987
  670272
  682988
  705435
  709105
  712939
  716229
  729053
  730060
  742127
  742305
  748112
  750363
  759346
  760428
  778828
  781585
  794401
  795609
  796360
  803785
  810859
]
1.99 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пизда в крупном плане%…"
]
1.82 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин в крупныйпла"
]
1.49 ms
(1.00%)
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.