Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.69 ms
(86.61%)
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
  73204
  181334
  183036
  291356
  382084
  382194
  387082
  395344
  395365
  398477
  398508
  398577
  400328
  411318
  411930
  418225
  432518
  433271
  433304
  435999
  437285
  439350
  439434
  441211
  442508
  443040
  444078
  445448
  445818
  447821
  447906
  451437
  452563
  453558
  455518
  456453
  456522
  456581
  459547
  470036
  470968
  472403
  473113
  474116
  476455
  477639
  478213
  483106
  483482
  488259
  489323
  493019
  497679
  499088
  500069
  501005
  502499
  503322
  506023
  507012
  509540
  509880
  511955
  512843
  514873
  515736
  515759
  518184
  518379
  520101
  520936
  522634
  523056
  541816
  542385
  553306
  555018
  555291
  556690
  562416
  563164
  563702
  564565
  565868
  566701
  567400
  573273
  579612
  583644
  599070
  599609
  602482
  603417
  604857
  607045
  609091
  612169
  617117
  618082
  619090
  619191
  620828
  625440
  627158
  630359
  672671
  675142
  712285
  725650
  733273
  745252
  747994
  754771
  764095
  764273
  785891
  788100
  792002
  801653
]
14.80 ms
(7.98%)
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
  456453
  520936
  566701
  747994
  725650
  603417
  73204
  400328
  398577
  675142
  712285
  291356
  387082
  433271
  456581
  553306
  398477
  442508
  472403
  506023
  520101
  541816
  617117
  470968
  470036
  523056
  445448
  395365
  411318
  801653
  604857
  602482
  477639
  555291
  443040
  512843
  444078
  451437
  474116
  518379
  563164
  599070
  459547
  435999
  445818
  509540
  501005
  499088
  447906
  564565
  437285
  502499
  609091
  497679
  476455
  493019
  433304
  483482
  489323
  488259
  183036
  398508
  455518
  439350
  620828
  456522
  483106
  509880
  418225
  607045
  382084
  764095
  764273
  522634
  518184
  555018
  563702
  565868
  630359
  514873
  672671
  583644
  599609
  619191
  507012
  511955
  500069
  542385
  382194
  567400
  619090
  556690
  515736
  625440
  573273
  579612
  411930
  478213
  453558
  473113
  503322
  441211
  562416
  618082
  612169
  627158
  788100
  745252
  771687
  181334
  515759
  447821
  792002
  432518
  785891
  733273
  754771
  395344
  439434
  452563
]
3.16 ms
(1.70%)
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
  73204
  181334
  183036
  291356
  382084
  382194
  387082
  395344
  395365
  398477
  398508
  398577
  400328
  411318
  411930
  418225
  432518
  433271
  433304
  435999
  437285
  439350
  439434
  441211
  442508
  443040
  444078
  445448
  445818
  447821
  447906
  451437
  452563
  453558
  455518
  456453
  456522
  456581
  459547
  470036
  470968
  472403
  473113
  474116
  476455
  477639
  478213
  483106
  483482
  488259
  489323
  493019
  497679
  499088
  500069
  501005
  502499
  503322
  506023
  507012
  509540
  509880
  511955
  512843
  514873
  515736
  515759
  518184
  518379
  520101
  520936
  522634
  523056
  541816
  542385
  553306
  555018
  555291
  556690
  562416
  563164
  563702
  564565
  565868
  566701
  567400
  573273
  579612
  583644
  599070
  599609
  602482
  603417
  604857
  607045
  609091
  612169
  617117
  618082
  619090
  619191
  620828
  625440
  627158
  630359
  672671
  675142
  712285
  725650
  733273
  745252
  747994
  754771
  764095
  764273
  785891
  788100
  792002
  801653
]
2.01 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в трусик нижн бел"
]
1.75 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончать в трусы"
]
1.62 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в трусик нижн бел"
]
1.49 ms
(0.80%)
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.