Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.24 ms
(85.01%)
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
  389211
  389519
  389639
  389895
  391287
  411518
  412881
  418293
  419028
  424190
  427081
  427087
  427249
  436444
  437974
  437997
  438334
  438767
  442003
  443068
  443459
  443499
  443961
  445320
  446592
  447390
  450851
  451279
  452324
  453524
  455644
  455875
  456703
  457629
  459113
  459727
  466757
  470746
  473740
  474271
  475195
  475571
  475943
  477094
  478123
  478207
  480066
  480629
  480866
  481816
  487364
  489667
  491096
  495327
  495483
  495999
  499616
  500210
  501916
  502896
  505378
  505525
  509293
  510855
  510881
  511841
  512230
  516875
  517393
  518317
  520487
  521201
  521355
  522578
  523055
  523128
  525598
  525709
  525941
  526809
  526881
  528263
  528814
  534027
  534032
  534571
  534676
  540696
  555128
  559618
  567081
  572337
  591176
  592263
  598172
  601990
  608645
  612614
  613313
  616089
  620236
  622773
  623378
  626405
  634536
  637445
  637741
  646838
  647340
  650624
  651148
  682866
  683301
  722796
  727055
  741760
  751589
  791505
  805292
  818071
]
18.07 ms
(9.13%)
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
  634536
  805292
  741760
  727055
  480629
  419028
  436444
  451279
  477094
  427081
  442003
  475571
  526809
  499616
  491096
  459113
  459727
  495327
  525709
  443961
  437997
  455644
  470746
  391287
  427249
  505378
  509293
  522578
  534571
  495999
  453524
  818071
  474271
  567081
  559618
  683301
  608645
  791505
  389639
  438334
  456703
  411518
  437974
  478207
  518317
  526881
  495483
  501916
  528814
  525598
  505525
  626405
  389211
  466757
  389519
  517393
  487364
  534032
  555128
  572337
  682866
  650624
  592263
  612614
  412881
  480066
  438767
  418293
  473740
  478123
  443499
  446592
  443068
  475943
  481816
  502896
  521201
  521355
  534676
  510881
  523055
  489667
  520487
  523128
  540696
  480866
  511841
  637445
  751589
  475195
  447390
  455875
  528263
  500210
  510855
  512230
  443459
  450851
  427087
  457629
  637741
  452324
  525941
  445320
  646838
  601990
  722796
  424190
  389895
  516875
  598172
  622773
  616089
  534027
  620236
  613313
  623378
  647340
  651148
  591176
]
3.72 ms
(1.88%)
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
  389211
  389519
  389639
  389895
  391287
  411518
  412881
  418293
  419028
  424190
  427081
  427087
  427249
  436444
  437974
  437997
  438334
  438767
  442003
  443068
  443459
  443499
  443961
  445320
  446592
  447390
  450851
  451279
  452324
  453524
  455644
  455875
  456703
  457629
  459113
  459727
  466757
  470746
  473740
  474271
  475195
  475571
  475943
  477094
  478123
  478207
  480066
  480629
  480866
  481816
  487364
  489667
  491096
  495327
  495483
  495999
  499616
  500210
  501916
  502896
  505378
  505525
  509293
  510855
  510881
  511841
  512230
  516875
  517393
  518317
  520487
  521201
  521355
  522578
  523055
  523128
  525598
  525709
  525941
  526809
  526881
  528263
  528814
  534027
  534032
  534571
  534676
  540696
  555128
  559618
  567081
  572337
  591176
  592263
  598172
  601990
  608645
  612614
  613313
  616089
  620236
  622773
  623378
  626405
  634536
  637445
  637741
  646838
  647340
  650624
  651148
  682866
  683301
  722796
  727055
  741760
  751589
  791505
  805292
  818071
]
2.28 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swallow russian"
]
2.16 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "глота русск"
]
1.56 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.