Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.60 ms
(82.57%)
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
  43029
  65760
  145635
  177385
  256614
  385323
  393498
  396009
  396279
  398230
  398900
  401452
  414116
  417608
  418697
  420329
  427339
  432589
  438543
  444477
  444512
  447352
  452745
  458921
  465728
  468059
  468956
  469404
  469428
  471650
  475329
  477517
  480467
  494927
  499923
  500748
  511856
  526017
  526163
  530042
  531642
  551476
  568195
  598355
  600671
  600998
  602597
  609246
  609686
  614199
  620793
  622952
  646277
  695602
  697100
  701000
  707390
  709276
  709641
  713429
  716131
  716275
  723766
  729674
  730299
  734247
  736025
  736093
  737351
  738081
  738448
  750574
  751183
  751496
  751743
  751745
  754360
  760739
  765537
  769999
  784803
  797092
  799166
  799191
  801662
  804077
  804423
  805699
  811550
  811922
  812349
  817076
  817108
  819230
  819803
  819986
  820732
  821121
  821524
  822102
  822313
  822461
  822571
  822704
  822714
  822865
  823013
  823082
  823111
  823545
  824119
  824652
  825058
  825369
  825371
  825410
  825445
  825447
  827234
]
15.26 ms
(10.54%)
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
  417608
  65760
  420329
  469428
  414116
  145635
  709641
  805699
  765537
  701000
  43029
  393498
  396009
  822714
  817076
  817108
  819803
  822704
  823013
  827234
  822461
  822865
  824652
  825058
  819986
  823111
  825371
  825410
  471650
  531642
  713429
  646277
  716131
  602597
  801662
  723766
  736025
  737351
  751745
  804077
  812349
  751743
  738081
  738448
  754360
  769999
  751496
  751183
  256614
  396279
  398230
  418697
  432589
  444477
  452745
  475329
  458921
  468956
  511856
  600671
  598355
  760739
  730299
  447352
  500748
  709276
  398900
  427339
  469404
  477517
  438543
  401452
  465728
  480467
  468059
  499923
  551476
  568195
  494927
  385323
  444512
  797092
  799166
  799191
  734247
  736093
  697100
  177385
  822102
  823082
  824119
  824185
  819230
  821524
  825369
  821121
  822313
  822571
  823545
  825445
  820732
  825447
  526163
  526017
  530042
  707390
  695602
  716275
  600998
  609686
  620793
  609246
  614199
  622952
  811922
  784803
  804423
  811550
  729674
  750574
]
2.56 ms
(1.77%)
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
  43029
  65760
  145635
  177385
  256614
  385323
  393498
  396009
  396279
  398230
  398900
  401452
  414116
  417608
  418697
  420329
  427339
  432589
  438543
  444477
  444512
  447352
  452745
  458921
  465728
  468059
  468956
  469404
  469428
  471650
  475329
  477517
  480467
  494927
  499923
  500748
  511856
  526017
  526163
  530042
  531642
  551476
  568195
  598355
  600671
  600998
  602597
  609246
  609686
  614199
  620793
  622952
  646277
  695602
  697100
  701000
  707390
  709276
  709641
  713429
  716131
  716275
  723766
  729674
  730299
  734247
  736025
  736093
  737351
  738081
  738448
  750574
  751183
  751496
  751743
  751745
  754360
  760739
  765537
  769999
  784803
  797092
  799166
  799191
  801662
  804077
  804423
  805699
  811550
  811922
  812349
  817076
  817108
  819230
  819803
  819986
  820732
  821121
  821524
  822102
  822313
  822461
  822571
  822704
  822714
  822865
  823013
  823082
  823111
  823545
  824119
  824652
  825058
  825369
  825371
  825410
  825445
  825447
  827234
]
2.14 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina masturbation"
]
1.91 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская мастурбац"
]
1.71 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.15%)
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.