Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.07 ms
(80.83%)
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
  233135
  398409
  420540
  422349
  425394
  426553
  428229
  428576
  431463
  432249
  434321
  439981
  443817
  443945
  445623
  448483
  450653
  450948
  452480
  452556
  454869
  455560
  455879
  462525
  466028
  468858
  471452
  471969
  472389
  476320
  476791
  479106
  480764
  482975
  486303
  487824
  488812
  491014
  492054
  492652
  493108
  493381
  500090
  506028
  508989
  509422
  511388
  511833
  516152
  517579
  518802
  520935
  521022
  522092
  522226
  523066
  523266
  524449
  525471
  526070
  527476
  527836
  529055
  529358
  537810
  546460
  546950
  556921
  557377
  557378
  557993
  558494
  561382
  561991
  562043
  565213
  565347
  569188
  569603
  570845
  570860
  572022
  574237
  576230
  580751
  582784
  583645
  583861
  585515
  586649
  587849
  591004
  592390
  592514
  593063
  595789
  596373
  596730
  596927
  597947
  599029
  601399
  603256
  604304
  605613
  607552
  610626
  612171
  616973
  619123
  623284
  633853
  640687
  643109
  650539
  652007
  658042
  670274
  677106
  690822
]
22.99 ms
(13.27%)
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
  488812
  561382
  591004
  592514
  603256
  640687
  426553
  432249
  428576
  439981
  445623
  480764
  491014
  455879
  518802
  521022
  529055
  529358
  537810
  522092
  523266
  562043
  565213
  565347
  570845
  583861
  582784
  546460
  556921
  557377
  557993
  569188
  570860
  574237
  583645
  652007
  690822
  670274
  677106
  546950
  557378
  558494
  561991
  580751
  587849
  592390
  601399
  605613
  616973
  623284
  599029
  612171
  619123
  633853
  586649
  593063
  595789
  596373
  596730
  610626
  596927
  420540
  434321
  443817
  450948
  462525
  466028
  468858
  471452
  476791
  425394
  448483
  450653
  454869
  398409
  431463
  471969
  479106
  422349
  472389
  522226
  492054
  493108
  511388
  520935
  523066
  525471
  527836
  487824
  492652
  506028
  508989
  482975
  509422
  572022
  455560
  233135
  493381
  486303
  576230
  643109
  585515
  607552
  516152
  524449
  526070
  569603
  650539
  597947
  604304
  443945
  428229
  452556
  476320
  658042
  452480
  527476
  500090
  511833
  517579
]
2.94 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
  233135
  398409
  420540
  422349
  425394
  426553
  428229
  428576
  431463
  432249
  434321
  439981
  443817
  443945
  445623
  448483
  450653
  450948
  452480
  452556
  454869
  455560
  455879
  462525
  466028
  468858
  471452
  471969
  472389
  476320
  476791
  479106
  480764
  482975
  486303
  487824
  488812
  491014
  492054
  492652
  493108
  493381
  500090
  506028
  508989
  509422
  511388
  511833
  516152
  517579
  518802
  520935
  521022
  522092
  522226
  523066
  523266
  524449
  525471
  526070
  527476
  527836
  529055
  529358
  537810
  546460
  546950
  556921
  557377
  557378
  557993
  558494
  561382
  561991
  562043
  565213
  565347
  569188
  569603
  570845
  570860
  572022
  574237
  576230
  580751
  582784
  583645
  583861
  585515
  586649
  587849
  591004
  592390
  592514
  593063
  595789
  596373
  596730
  596927
  597947
  599029
  601399
  603256
  604304
  605613
  607552
  610626
  612171
  616973
  619123
  623284
  633853
  640687
  643109
  650539
  652007
  658042
  670274
  677106
  690822
]
2.14 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "чулки ноги"
]
1.85 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел ног"
]
1.72 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел ног"
]
1.59 ms
(0.92%)
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.