Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.69 ms
(81.91%)
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
  381853
  396194
  401180
  413186
  415172
  420478
  423331
  428797
  434301
  436452
  439811
  440964
  444942
  451469
  451589
  458311
  461986
  465092
  465964
  467513
  470773
  470947
  474483
  476469
  477979
  478238
  478380
  480869
  481388
  481519
  483370
  484101
  485916
  486578
  487702
  487761
  487872
  489105
  490410
  490549
  491107
  492618
  493110
  497547
  498018
  501637
  502719
  502851
  503494
  503504
  505133
  505202
  507363
  510088
  513302
  513325
  514571
  516658
  517953
  518061
  518731
  520286
  520382
  520611
  520928
  522023
  525225
  528212
  536067
  537306
  541078
  541080
  542941
  546891
  548787
  552671
  556202
  558841
  558956
  560505
  562271
  562311
  564472
  564745
  565494
  566780
  572131
  573328
  575745
  578848
  579619
  591365
  591397
  595884
  596227
  596306
  596657
  598736
  598965
  601281
  601983
  601998
  603003
  609229
  616818
  623709
  625913
  626824
  627097
  628282
  628533
  629446
  631264
  652240
  653267
  653504
  654392
  655631
  657023
  680794
]
17.24 ms
(11.80%)
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
  520928
  518061
  461986
  596657
  474483
  627097
  579619
  575745
  598965
  631264
  420478
  413186
  518731
  489105
  505133
  486578
  510088
  520382
  520611
  655631
  562311
  503504
  548787
  552671
  566780
  573328
  653504
  654392
  680794
  652240
  657023
  598736
  603003
  623709
  629446
  595884
  601281
  596306
  591365
  601983
  401180
  423331
  480869
  444942
  396194
  428797
  477979
  522023
  484101
  487761
  513302
  491107
  514571
  609229
  451589
  578848
  625913
  501637
  546891
  541078
  560505
  591397
  628533
  436452
  505202
  513325
  541080
  487872
  628282
  478380
  516658
  498018
  601998
  440964
  653267
  562271
  465092
  470947
  536067
  467513
  558956
  596227
  616818
  381853
  415172
  470773
  458311
  478238
  451469
  481519
  485916
  490549
  497547
  542941
  434301
  439811
  517953
  483370
  492618
  487702
  507363
  502851
  572131
  528212
  503494
  565494
  626824
  476469
  481388
  490410
  465964
  525225
  537306
  502719
  520286
  493110
  558841
  556202
  564472
  564745
]
2.43 ms
(1.66%)
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
  381853
  396194
  401180
  413186
  415172
  420478
  423331
  428797
  434301
  436452
  439811
  440964
  444942
  451469
  451589
  458311
  461986
  465092
  465964
  467513
  470773
  470947
  474483
  476469
  477979
  478238
  478380
  480869
  481388
  481519
  483370
  484101
  485916
  486578
  487702
  487761
  487872
  489105
  490410
  490549
  491107
  492618
  493110
  497547
  498018
  501637
  502719
  502851
  503494
  503504
  505133
  505202
  507363
  510088
  513302
  513325
  514571
  516658
  517953
  518061
  518731
  520286
  520382
  520611
  520928
  522023
  525225
  528212
  536067
  537306
  541078
  541080
  542941
  546891
  548787
  552671
  556202
  558841
  558956
  560505
  562271
  562311
  564472
  564745
  565494
  566780
  572131
  573328
  575745
  578848
  579619
  591365
  591397
  595884
  596227
  596306
  596657
  598736
  598965
  601281
  601983
  601998
  603003
  609229
  616818
  623709
  625913
  626824
  627097
  628282
  628533
  629446
  631264
  652240
  653267
  653504
  654392
  655631
  657023
  680794
]
1.88 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в одежде русские"
]
1.57 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в одежд русск"
]
1.56 ms
(1.07%)
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.