Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.97 ms
(85.18%)
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
  70082
  382049
  386596
  387218
  390024
  391986
  396358
  402692
  406350
  409921
  414651
  416975
  417324
  429764
  429943
  435108
  439301
  440632
  441185
  443232
  443661
  443662
  444703
  445733
  445738
  448811
  452228
  452279
  453583
  457163
  459325
  460706
  461765
  462470
  464188
  467195
  468010
  468012
  468628
  471035
  473216
  473722
  474621
  476120
  490071
  491263
  495014
  510109
  510394
  511810
  512613
  514798
  516291
  517204
  517330
  517725
  518476
  519085
  521089
  521367
  522130
  522147
  522785
  525303
  530483
  531233
  534150
  534166
  536542
  536645
  537901
  540400
  542583
  542590
  545747
  545803
  565102
  573238
  574559
  579171
  580472
  583714
  585251
  587272
  589524
  591067
  596643
  597028
  598042
  598498
  599908
  599957
  603642
  604387
  604597
  604849
  605449
  625412
  631192
  631193
  633798
  637741
  639335
  643112
  645327
  680206
  684312
  704216
  712775
  714464
  720245
  720938
  729911
  731665
  738827
  742428
  745384
  749152
  779736
  824469
]
20.47 ms
(9.97%)
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
  525303
  511810
  387218
  536542
  579171
  591067
  585251
  604597
  519085
  476120
  517204
  443662
  471035
  531233
  704216
  639335
  738827
  779736
  386596
  714464
  598498
  545747
  453583
  402692
  518476
  598042
  416975
  452279
  522130
  574559
  684312
  70082
  390024
  443232
  445733
  712775
  382049
  391986
  441185
  517330
  409921
  729911
  720938
  396358
  439301
  468012
  597028
  680206
  573238
  631192
  406350
  414651
  429764
  522785
  580472
  599957
  643112
  435108
  467195
  473722
  542583
  490071
  824469
  742428
  534166
  514798
  596643
  521367
  444703
  510109
  429943
  464188
  542590
  565102
  461765
  495014
  521089
  512613
  517725
  603642
  417324
  745384
  530483
  534150
  537901
  720245
  645327
  599908
  633798
  452228
  491263
  473216
  587272
  749152
  462470
  443661
  445738
  540400
  637741
  604387
  468628
  468010
  589524
  459325
  522147
  605449
  457163
  474621
  510394
  536645
  583714
  440632
  625412
  448811
  604849
  545803
  460706
  731665
  631193
  516291
]
2.91 ms
(1.42%)
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
  70082
  382049
  386596
  387218
  390024
  391986
  396358
  402692
  406350
  409921
  414651
  416975
  417324
  429764
  429943
  435108
  439301
  440632
  441185
  443232
  443661
  443662
  444703
  445733
  445738
  448811
  452228
  452279
  453583
  457163
  459325
  460706
  461765
  462470
  464188
  467195
  468010
  468012
  468628
  471035
  473216
  473722
  474621
  476120
  490071
  491263
  495014
  510109
  510394
  511810
  512613
  514798
  516291
  517204
  517330
  517725
  518476
  519085
  521089
  521367
  522130
  522147
  522785
  525303
  530483
  531233
  534150
  534166
  536542
  536645
  537901
  540400
  542583
  542590
  545747
  545803
  565102
  573238
  574559
  579171
  580472
  583714
  585251
  587272
  589524
  591067
  596643
  597028
  598042
  598498
  599908
  599957
  603642
  604387
  604597
  604849
  605449
  625412
  631192
  631193
  633798
  637741
  639335
  643112
  645327
  680206
  684312
  704216
  712775
  714464
  720245
  720938
  729911
  731665
  738827
  742428
  745384
  749152
  779736
  824469
]
2.26 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal girl black"
]
1.77 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал девушк black"
]
1.36 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал девушк black"
]

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.