Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.05 ms
(83.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
  6670
  197443
  386065
  388907
  392597
  395781
  400843
  402425
  403663
  404019
  411734
  413429
  415928
  417942
  418066
  420606
  420865
  423364
  423815
  427093
  428207
  428668
  429288
  429355
  432458
  433686
  435104
  435198
  437242
  437459
  441877
  442158
  444671
  444916
  446281
  449702
  451254
  455562
  456876
  456887
  457577
  457881
  458649
  458738
  459022
  459308
  459552
  460264
  461272
  462258
  464068
  465116
  466452
  468878
  469629
  471774
  475693
  477695
  478163
  482579
  482619
  483334
  483997
  484992
  485062
  486133
  486167
  489226
  490652
  490709
  490712
  492161
  494834
  496375
  500249
  500314
  504206
  506106
  506754
  510424
  511066
  513647
  513936
  514011
  516715
  517497
  519452
  521076
  521793
  522049
  526137
  527022
  527588
  529451
  533632
  535918
  541245
  542964
  545622
  545636
  545651
  546770
  552181
  554804
  556614
  556808
  558578
  561636
  563398
  570273
  592486
  601425
  604857
  605674
  606016
  626978
  652907
  720464
  781147
  787172
]
16.50 ms
(10.53%)
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
  427093
  545622
  545636
  556614
  546770
  423364
  429355
  482579
  459022
  542964
  552181
  435198
  461272
  400843
  428668
  446281
  456887
  413429
  465116
  475693
  561636
  604857
  468878
  469629
  484992
  444916
  392597
  485062
  720464
  533632
  519452
  471774
  197443
  415928
  417942
  482619
  466452
  526137
  490709
  458738
  516715
  556808
  451254
  462258
  477695
  535918
  486167
  570273
  444671
  504206
  500249
  541245
  513647
  558578
  388907
  6670
  437459
  486133
  464068
  442158
  459552
  437242
  500314
  506754
  402425
  521076
  522049
  435104
  513936
  517497
  781147
  787172
  458649
  554804
  483334
  510424
  490712
  527588
  605674
  457881
  529451
  652907
  626978
  506106
  492161
  606016
  457577
  432458
  478163
  386065
  404019
  441877
  459308
  449702
  460264
  563398
  545651
  592486
  601425
  428207
  433686
  411734
  418066
  420606
  423815
  429288
  455562
  456876
  527022
  490652
  483997
  489226
  496375
  494834
  514011
  521793
  511066
  395781
  403663
  420865
]
2.90 ms
(1.85%)
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
  6670
  197443
  386065
  388907
  392597
  395781
  400843
  402425
  403663
  404019
  411734
  413429
  415928
  417942
  418066
  420606
  420865
  423364
  423815
  427093
  428207
  428668
  429288
  429355
  432458
  433686
  435104
  435198
  437242
  437459
  441877
  442158
  444671
  444916
  446281
  449702
  451254
  455562
  456876
  456887
  457577
  457881
  458649
  458738
  459022
  459308
  459552
  460264
  461272
  462258
  464068
  465116
  466452
  468878
  469629
  471774
  475693
  477695
  478163
  482579
  482619
  483334
  483997
  484992
  485062
  486133
  486167
  489226
  490652
  490709
  490712
  492161
  494834
  496375
  500249
  500314
  504206
  506106
  506754
  510424
  511066
  513647
  513936
  514011
  516715
  517497
  519452
  521076
  521793
  522049
  526137
  527022
  527588
  529451
  533632
  535918
  541245
  542964
  545622
  545636
  545651
  546770
  552181
  554804
  556614
  556808
  558578
  561636
  563398
  570273
  592486
  601425
  604857
  605674
  606016
  626978
  652907
  720464
  781147
  787172
]
2.04 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "раком в лифчиком в спа…"
]
1.50 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак в бюстгалтер нижн бел в спа"
]
1.27 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.