Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.42 ms
(85.13%)
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
  187704
  233570
  340567
  386384
  389680
  391669
  397880
  397916
  411015
  411326
  411417
  411930
  422349
  423775
  424090
  424317
  424444
  428393
  429902
  439645
  439650
  439750
  440339
  440445
  440824
  443085
  443820
  444104
  445208
  448679
  451462
  454546
  456389
  460804
  460864
  460924
  461932
  463087
  465902
  465907
  466186
  466241
  468113
  468182
  468815
  468916
  469164
  469167
  470031
  470402
  470502
  470615
  471113
  473908
  473960
  476267
  476838
  478057
  479051
  479061
  479087
  479121
  480902
  481923
  485366
  485638
  485974
  486126
  490126
  491913
  492167
  492660
  493316
  494215
  503494
  512745
  513538
  514366
  515707
  519452
  522092
  523733
  525839
  526300
  527836
  529516
  530005
  531524
  534119
  542753
  544502
  547805
  548907
  552375
  556338
  558928
  560008
  563152
  566421
  573175
  582576
  591130
  591213
  600023
  601487
  603437
  609071
  620251
  651822
  677861
  705408
  720511
  738331
  746580
  761517
  769133
  782230
  788100
  795202
  825764
]
19.81 ms
(9.89%)
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
  470615
  519452
  529516
  582576
  494215
  677861
  601487
  761517
  469167
  397880
  470402
  476838
  552375
  547805
  411015
  424444
  466186
  479121
  460804
  473908
  513538
  486126
  485366
  485974
  492167
  769133
  465902
  479087
  480902
  440445
  591130
  481923
  439645
  460924
  471113
  479051
  566421
  424090
  525839
  542753
  573175
  445208
  600023
  544502
  591213
  397916
  490126
  470502
  233570
  558928
  651822
  788100
  795202
  746580
  738331
  705408
  531524
  444104
  391669
  476267
  422349
  620251
  411930
  473960
  515707
  411326
  491913
  187704
  825764
  603437
  468916
  454546
  720511
  782230
  463087
  461932
  534119
  522092
  548907
  560008
  563152
  609071
  424317
  451462
  468182
  423775
  439750
  465907
  340567
  456389
  460864
  468113
  527836
  523733
  448679
  503494
  530005
  411417
  526300
  469164
  389680
  514366
  439650
  440824
  479061
  428393
  468815
  478057
  466241
  512745
  429902
  470031
  386384
  443085
  485638
  556338
  440339
  443820
  493316
  492660
]
2.57 ms
(1.28%)
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
  187704
  233570
  340567
  386384
  389680
  391669
  397880
  397916
  411015
  411326
  411417
  411930
  422349
  423775
  424090
  424317
  424444
  428393
  429902
  439645
  439650
  439750
  440339
  440445
  440824
  443085
  443820
  444104
  445208
  448679
  451462
  454546
  456389
  460804
  460864
  460924
  461932
  463087
  465902
  465907
  466186
  466241
  468113
  468182
  468815
  468916
  469164
  469167
  470031
  470402
  470502
  470615
  471113
  473908
  473960
  476267
  476838
  478057
  479051
  479061
  479087
  479121
  480902
  481923
  485366
  485638
  485974
  486126
  490126
  491913
  492167
  492660
  493316
  494215
  503494
  512745
  513538
  514366
  515707
  519452
  522092
  523733
  525839
  526300
  527836
  529516
  530005
  531524
  534119
  542753
  544502
  547805
  548907
  552375
  556338
  558928
  560008
  563152
  566421
  573175
  582576
  591130
  591213
  600023
  601487
  603437
  609071
  620251
  651822
  677861
  705408
  720511
  738331
  746580
  761517
  769133
  782230
  788100
  795202
  825764
]
2.19 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские мамы чулки"
]
1.82 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск мам женщин чулк нижн бел"
]
1.63 ms
(0.81%)
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.