Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
672.46 ms
(65.44%)
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
  474072
  398784
  459600
  391881
  447083
  498900
  504251
  513282
  400463
  570051
  597043
  473979
  512754
  185714
  414962
  453860
  551256
  495549
  493553
  549762
  471331
  476749
  477146
  482767
  558599
  552211
  572467
  561669
  552248
  562226
  573826
  480028
  441759
  461150
  470334
  425889
  461776
  473905
  477908
  481187
  480831
  456262
  503706
  541734
  492818
  486833
  494396
  498822
  482763
  596670
  412528
  537960
  483213
  778970
  392632
  559021
  563359
  572755
  595398
  596619
  590609
  397065
  470484
  475597
  486465
  490619
  562248
  496959
  413180
  547389
  802622
  760909
  413199
  444221
  500747
  562277
  561270
  565589
  598674
  598700
  598503
  596673
  462231
  471169
  381775
  400723
  448340
  449590
  412134
  529463
  512303
  524010
  398801
  500741
  552425
  412515
  428259
  448359
  443736
  477137
  570040
  572363
  573543
  573596
  570198
  570506
  573675
  573711
  573954
  574588
  563993
  570280
  570307
  560942
  570204
  578997
  462728
  479613
  402219
  439049
]
208.71 ms
(20.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐÇÐâÐüÐüð║ð░ÐÅ ÐàÐâð┤ÐïðÁ ð┤ðÁð▓ÐâÐêð║ð%ÔǪ"
]
137.91 ms
(13.42%)
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
  185714
  381775
  391881
  392632
  397065
  398784
  398801
  400463
  400723
  402219
  412134
  412515
  412528
  413180
  413199
  414962
  425889
  428259
  439049
  441759
  443736
  444221
  447083
  448340
  448359
  449590
  453860
  456262
  459600
  461150
  461776
  462231
  462728
  470334
  470484
  471169
  471331
  473905
  473979
  474072
  475597
  476749
  477137
  477146
  477908
  479613
  480028
  480831
  481187
  482763
  482767
  483213
  486465
  486833
  490619
  492818
  493553
  494396
  495549
  496959
  498822
  498900
  500741
  500747
  503706
  504251
  512303
  512754
  513282
  524010
  529463
  537960
  541734
  547389
  549762
  551256
  552211
  552248
  552425
  558599
  559021
  560942
  561270
  561669
  562226
  562248
  562277
  563359
  563993
  565589
  570040
  570051
  570198
  570204
  570280
  570307
  570506
  572363
  572467
  572755
  573543
  573596
  573675
  573711
  573826
  573954
  574588
  578997
  590609
  595398
  596619
  596670
  596673
  597043
  598503
  598674
  598700
  760909
  778970
  802622
]
3.67 ms
(0.36%)
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
  185714
  381775
  391881
  392632
  397065
  398784
  398801
  400463
  400723
  402219
  412134
  412515
  412528
  413180
  413199
  414962
  425889
  428259
  439049
  441759
  443736
  444221
  447083
  448340
  448359
  449590
  453860
  456262
  459600
  461150
  461776
  462231
  462728
  470334
  470484
  471169
  471331
  473905
  473979
  474072
  475597
  476749
  477137
  477146
  477908
  479613
  480028
  480831
  481187
  482763
  482767
  483213
  486465
  486833
  490619
  492818
  493553
  494396
  495549
  496959
  498822
  498900
  500741
  500747
  503706
  504251
  512303
  512754
  513282
  524010
  529463
  537960
  541734
  547389
  549762
  551256
  552211
  552248
  552425
  558599
  559021
  560942
  561270
  561669
  562226
  562248
  562277
  563359
  563993
  565589
  570040
  570051
  570198
  570204
  570280
  570307
  570506
  572363
  572467
  572755
  573543
  573596
  573675
  573711
  573826
  573954
  574588
  578997
  590609
  595398
  596619
  596670
  596673
  597043
  598503
  598674
  598700
  760909
  778970
  802622
]
1.90 ms
(0.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск худая девушк"
]
1.48 ms
(0.14%)
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.