Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.91 ms
(88.90%)
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
  384911
  386653
  387380
  398368
  399338
  399414
  400878
  401260
  417950
  418117
  419427
  420104
  420105
  420718
  421784
  425304
  428772
  432418
  437166
  438447
  441452
  441560
  441708
  442143
  442475
  444109
  447124
  447913
  449657
  452429
  453819
  453986
  454837
  456583
  456691
  458868
  459267
  459494
  459685
  460107
  460958
  461677
  463092
  463166
  463301
  463610
  466569
  467844
  468145
  470961
  471189
  471474
  471774
  472714
  473958
  474977
  475714
  476675
  478875
  481154
  481251
  482081
  482403
  483050
  483727
  483852
  483944
  486961
  490079
  490281
  492595
  493917
  496030
  497986
  498655
  499517
  499668
  499690
  501804
  503619
  503870
  504036
  511735
  513019
  513307
  514461
  515482
  516054
  516848
  520126
  521864
  523258
  524782
  525422
  527717
  540889
  548742
  552874
  556019
  558156
  565587
  566451
  566595
  566709
  566986
  567860
  569246
  570537
  572906
  573689
  575785
  578468
  581832
  591336
  602634
  605430
  609627
  622737
  700547
  716746
]
14.94 ms
(6.45%)
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
  418117
  442143
  386653
  449657
  498655
  384911
  419427
  428772
  420105
  442475
  452429
  460107
  463610
  463092
  483944
  497986
  514461
  463301
  566451
  569246
  566595
  716746
  420718
  470961
  425304
  459685
  481251
  459494
  476675
  438447
  461677
  441560
  466569
  483852
  499517
  525422
  499690
  486961
  556019
  558156
  483727
  399414
  387380
  399338
  444109
  421784
  441452
  490281
  456691
  459267
  565587
  602634
  609627
  432418
  441708
  453819
  398368
  471189
  496030
  578468
  400878
  401260
  463166
  523258
  540889
  458868
  570537
  566986
  482081
  503870
  521864
  492595
  575785
  513019
  420104
  437166
  447913
  572906
  581832
  700547
  567860
  475714
  478875
  468145
  471474
  454837
  520126
  493917
  516848
  490079
  524782
  504036
  566709
  605430
  481154
  447124
  503619
  482403
  453986
  473958
  471774
  552874
  573689
  548742
  622737
  591336
  417950
  467844
  474977
  456583
  501804
  513307
  483050
  499668
  515482
  511735
  516054
  527717
  472714
  460958
]
3.12 ms
(1.35%)
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
  384911
  386653
  387380
  398368
  399338
  399414
  400878
  401260
  417950
  418117
  419427
  420104
  420105
  420718
  421784
  425304
  428772
  432418
  437166
  438447
  441452
  441560
  441708
  442143
  442475
  444109
  447124
  447913
  449657
  452429
  453819
  453986
  454837
  456583
  456691
  458868
  459267
  459494
  459685
  460107
  460958
  461677
  463092
  463166
  463301
  463610
  466569
  467844
  468145
  470961
  471189
  471474
  471774
  472714
  473958
  474977
  475714
  476675
  478875
  481154
  481251
  482081
  482403
  483050
  483727
  483852
  483944
  486961
  490079
  490281
  492595
  493917
  496030
  497986
  498655
  499517
  499668
  499690
  501804
  503619
  503870
  504036
  511735
  513019
  513307
  514461
  515482
  516054
  516848
  520126
  521864
  523258
  524782
  525422
  527717
  540889
  548742
  552874
  556019
  558156
  565587
  566451
  566595
  566709
  566986
  567860
  569246
  570537
  572906
  573689
  575785
  578468
  581832
  591336
  602634
  605430
  609627
  622737
  700547
  716746
]
2.24 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк красивая"
]
1.88 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls beautiful"
]
1.86 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк красивая"
]
1.67 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.