Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.37 ms
(88.97%)
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
  419628
  422365
  435356
  444262
  446929
  453920
  457372
  459944
  461904
  462057
  464563
  468658
  468965
  469833
  471020
  478547
  481401
  481465
  482437
  483725
  483726
  483767
  483776
  485254
  485847
  486010
  486014
  488242
  488467
  489301
  489330
  491599
  492488
  492958
  493443
  493980
  494600
  495122
  498837
  499000
  505937
  511453
  517400
  517882
  518926
  521184
  524029
  524138
  524859
  541892
  542784
  547790
  560435
  563551
  563710
  564490
  571696
  573354
  577132
  578731
  578766
  583335
  589672
  591929
  591957
  592304
  595231
  595601
  607717
  613690
  613782
  615984
  616472
  619312
  625121
  628625
  628714
  666033
  674916
  697196
  707440
  707467
  715935
  720187
  727434
  728255
  728716
  729181
  730936
  737922
  739778
  746101
  752719
  752826
  756245
  769465
  796563
  803625
  807842
  809784
  824634
  824892
]
11.86 ms
(6.02%)
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
  803625
  483776
  488467
  824634
  482437
  453920
  486014
  517400
  563710
  715935
  628625
  595231
  809784
  707467
  483767
  499000
  483725
  469833
  462057
  564490
  578766
  674916
  578731
  592304
  613690
  796563
  727434
  730936
  728716
  613782
  720187
  505937
  498837
  824892
  471020
  485254
  488242
  524138
  486010
  541892
  666033
  591957
  752719
  752826
  728255
  619312
  464563
  492488
  521184
  478547
  563551
  707440
  697196
  595601
  589672
  625121
  628714
  807842
  756245
  769465
  729181
  739778
  422365
  444262
  517882
  518926
  483726
  494600
  495122
  511453
  542784
  573354
  457372
  468658
  446929
  485847
  492958
  493443
  491599
  560435
  615984
  746101
  737922
  481465
  435356
  524859
  493980
  547790
  577132
  591929
  607717
  616472
  481401
  489301
  571696
  459944
  461904
  489330
  583335
  524029
  468965
  419628
]
2.79 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
  419628
  422365
  435356
  444262
  446929
  453920
  457372
  459944
  461904
  462057
  464563
  468658
  468965
  469833
  471020
  478547
  481401
  481465
  482437
  483725
  483726
  483767
  483776
  485254
  485847
  486010
  486014
  488242
  488467
  489301
  489330
  491599
  492488
  492958
  493443
  493980
  494600
  495122
  498837
  499000
  505937
  511453
  517400
  517882
  518926
  521184
  524029
  524138
  524859
  541892
  542784
  547790
  560435
  563551
  563710
  564490
  571696
  573354
  577132
  578731
  578766
  583335
  589672
  591929
  591957
  592304
  595231
  595601
  607717
  613690
  613782
  615984
  616472
  619312
  625121
  628625
  628714
  666033
  674916
  697196
  707440
  707467
  715935
  720187
  727434
  728255
  728716
  729181
  730936
  737922
  739778
  746101
  752719
  752826
  756245
  769465
  796563
  803625
  807842
  809784
  824634
  824892
]
1.92 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam pregnant"
]
1.90 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер беремен"
]
1.84 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.73%)
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.