Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.61 ms
(83.51%)
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
  382045
  382739
  382748
  382808
  383367
  383659
  387198
  388313
  389895
  389945
  392599
  395134
  395141
  396711
  396889
  398530
  402419
  406018
  407365
  407684
  411324
  411397
  411614
  411776
  446853
  462606
  465386
  465570
  465892
  466189
  466318
  466394
  474095
  475861
  482782
  484413
  484746
  485690
  504173
  509044
  515994
  517073
  519038
  523392
  525269
  527142
  534334
  536140
  549799
  555788
  588233
  619526
  623487
  624366
  681075
  702362
  707428
  709359
  715551
  720004
  720455
  724023
  725655
  726574
  726576
  726830
  731788
  732344
  733091
  735934
  735992
  736307
  740117
  740616
  741091
  744825
  745799
  745844
  745929
  746173
  748246
  752627
  755369
  758427
  759477
  759693
  765640
  766690
  770112
  772104
  773577
  774331
  779341
  785607
  788490
  789532
  798087
  798905
  800360
  800712
  803941
  804194
  804983
  805711
  806286
  813835
  816774
  816793
  817394
  818057
  818478
  819508
  819621
  819894
  824152
  824621
  825155
  825439
  825775
  826889
]
16.34 ms
(9.99%)
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
  789532
  733091
  740117
  746173
  748246
  798087
  805711
  736307
  755369
  774331
  724023
  726576
  740616
  745844
  765640
  772104
  773577
  726830
  731788
  745799
  726574
  732344
  741091
  752627
  758427
  766690
  707428
  709359
  798905
  803941
  804194
  804983
  411324
  475861
  392599
  465386
  411397
  382748
  388313
  466318
  509044
  484413
  466394
  387198
  402419
  819508
  824152
  825155
  824621
  825439
  465570
  536140
  525269
  702362
  681075
  720004
  720455
  555788
  624366
  800712
  788490
  725655
  745929
  800360
  759693
  744825
  735934
  759477
  770112
  715551
  779341
  785607
  383659
  406018
  474095
  485690
  549799
  389895
  466189
  465892
  484746
  826889
  816774
  825775
  588233
  806286
  735992
  534334
  504173
  515994
  517073
  462606
  619526
  623487
  523392
  527142
  519038
  382739
  382808
  383367
  395141
  395134
  382045
  389945
  396711
  396889
  398530
  407365
  407684
  411614
  411776
  816793
  817394
  818057
  813835
  819621
  818478
  819894
  446853
  482782
]
2.79 ms
(1.71%)
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
  382045
  382739
  382748
  382808
  383367
  383659
  387198
  388313
  389895
  389945
  392599
  395134
  395141
  396711
  396889
  398530
  402419
  406018
  407365
  407684
  411324
  411397
  411614
  411776
  446853
  462606
  465386
  465570
  465892
  466189
  466318
  466394
  474095
  475861
  482782
  484413
  484746
  485690
  504173
  509044
  515994
  517073
  519038
  523392
  525269
  527142
  534334
  536140
  549799
  555788
  588233
  619526
  623487
  624366
  681075
  702362
  707428
  709359
  715551
  720004
  720455
  724023
  725655
  726574
  726576
  726830
  731788
  732344
  733091
  735934
  735992
  736307
  740117
  740616
  741091
  744825
  745799
  745844
  745929
  746173
  748246
  752627
  755369
  758427
  759477
  759693
  765640
  766690
  770112
  772104
  773577
  774331
  779341
  785607
  788490
  789532
  798087
  798905
  800360
  800712
  803941
  804194
  804983
  805711
  806286
  813835
  816774
  816793
  817394
  818057
  818478
  819508
  819621
  819894
  824152
  824621
  825155
  825439
  825775
  826889
]
2.03 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature pussy"
]
1.99 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature pussy"
]
1.98 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature pussy"
]

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.