Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.13 ms
(84.70%)
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
  358592
  391087
  400819
  401373
  407589
  409093
  411470
  416082
  417767
  418221
  419808
  420730
  427905
  428264
  435089
  437614
  438447
  444144
  444393
  444449
  445448
  445956
  446855
  450096
  451982
  452218
  455246
  455513
  457358
  457830
  459783
  460674
  461943
  464006
  464207
  464263
  470293
  471061
  471188
  471933
  473462
  474464
  475603
  475815
  475871
  479418
  479470
  480476
  482867
  483848
  485344
  485851
  489169
  490181
  490505
  491980
  491991
  492209
  494177
  494342
  496953
  498545
  499881
  500037
  502337
  504131
  507462
  508154
  508272
  512714
  514668
  515589
  515596
  519604
  519800
  521978
  522001
  524981
  525176
  527574
  532300
  533126
  533969
  534657
  538484
  545492
  555526
  557190
  558903
  561230
  564565
  572784
  578020
  586647
  587954
  589611
  591972
  592536
  593543
  596894
  598222
  599212
  599499
  600832
  600983
  603378
  609273
  617472
  618970
  619539
  620281
  621360
  621367
  621540
  624168
  642177
  724312
  762117
  810910
]
22.96 ms
(11.04%)
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
  621540
  586647
  589611
  593543
  596894
  598222
  599212
  599499
  600832
  600983
  621360
  642177
  587954
  591972
  592536
  609273
  618970
  620281
  621367
  724312
  762117
  603378
  617472
  810910
  420730
  461943
  471188
  473462
  391087
  428264
  445956
  479418
  358592
  400819
  417767
  418221
  427905
  435089
  445448
  459783
  460674
  470293
  407589
  411470
  438447
  444449
  457358
  471933
  475603
  409093
  416082
  444144
  455246
  457830
  475871
  479470
  502337
  504131
  507462
  515589
  485851
  491991
  494177
  496953
  514668
  519604
  521978
  524981
  526806
  482867
  489169
  491980
  500037
  522001
  534657
  485344
  490181
  492209
  494342
  498545
  512714
  515596
  464006
  624168
  619539
  401373
  437614
  444393
  419808
  451982
  464207
  471061
  483848
  475815
  480476
  446855
  450096
  452218
  455513
  474464
  490505
  508154
  508272
  533969
  519800
  527574
  532300
  525176
  533126
  499881
  538484
  464263
  545492
  555526
  558903
  561230
  572784
  578020
  557190
  564565
]
2.71 ms
(1.30%)
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
  358592
  391087
  400819
  401373
  407589
  409093
  411470
  416082
  417767
  418221
  419808
  420730
  427905
  428264
  435089
  437614
  438447
  444144
  444393
  444449
  445448
  445956
  446855
  450096
  451982
  452218
  455246
  455513
  457358
  457830
  459783
  460674
  461943
  464006
  464207
  464263
  470293
  471061
  471188
  471933
  473462
  474464
  475603
  475815
  475871
  479418
  479470
  480476
  482867
  483848
  485344
  485851
  489169
  490181
  490505
  491980
  491991
  492209
  494177
  494342
  496953
  498545
  499881
  500037
  502337
  504131
  507462
  508154
  508272
  512714
  514668
  515589
  515596
  519604
  519800
  521978
  522001
  524981
  525176
  527574
  532300
  533126
  533969
  534657
  538484
  545492
  555526
  557190
  558903
  561230
  564565
  572784
  578020
  586647
  587954
  589611
  591972
  592536
  593543
  596894
  598222
  599212
  599499
  600832
  600983
  603378
  609273
  617472
  618970
  619539
  620281
  621360
  621367
  621540
  624168
  642177
  724312
  762117
  810910
]
1.98 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass skirt"
]
1.52 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп юбк"
]
1.39 ms
(0.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.24 ms
(0.60%)
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.