Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.05 ms
(87.40%)
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
  398074
  398429
  414099
  419949
  427379
  428587
  435879
  445577
  446253
  463953
  470830
  510521
  514627
  515048
  516019
  529131
  530298
  530404
  530498
  530996
  531724
  532866
  533239
  535196
  538725
  544099
  549861
  561189
  565575
  565879
  573928
  576139
  596743
  598229
  601807
  604105
  604358
  604367
  608322
  608605
  608894
  614533
  614549
  624941
  627790
  642526
  643943
  644498
  645038
  645511
  646136
  647134
  648691
  649789
  650235
  650676
  650705
  650730
  653039
  658463
  658540
  669319
  686849
  688474
  690952
  693363
  697853
  705139
  716384
  717443
  718146
  724121
  736387
  739487
  739777
  741186
  745467
  745940
  748419
  749362
  749649
  751470
  757496
  757521
  758092
  764798
  766657
  768784
  769075
  773668
  773730
  776390
  778962
  785544
  788080
  788238
  788511
  791074
  792733
  795303
  796196
  796295
  796621
  797926
  798331
  798557
  800653
  801565
  802369
  806715
  808056
  808086
  808486
  810737
  811797
  812947
  813222
  819111
]
11.60 ms
(6.67%)
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
  573928
  751470
  419949
  470830
  530996
  549861
  601807
  624941
  614549
  565575
  785544
  604105
  758092
  435879
  515048
  414099
  529131
  828578
  398429
  463953
  535196
  514627
  658540
  697853
  650730
  669319
  705139
  646136
  686849
  718146
  608322
  598229
  596743
  627790
  604358
  796196
  778962
  788511
  795303
  796295
  796621
  798557
  812947
  739487
  741186
  749649
  773668
  773730
  791074
  792733
  797926
  801565
  757496
  724121
  757521
  769075
  745940
  766657
  710923
  788080
  538725
  531724
  576139
  565879
  608894
  608605
  806715
  811797
  739777
  614533
  644498
  813222
  427379
  510521
  533239
  819111
  516019
  642526
  800653
  798331
  736387
  749362
  768784
  717443
  650235
  604367
  745467
  748419
  530498
  530298
  690952
  645038
  802369
  808056
  764798
  398074
  428587
  788238
  561189
  446253
  445577
  808086
  530404
  532866
  544099
  647134
  648691
  649789
  650705
  693363
  645511
  653039
  658463
  688474
  650676
  716384
  643943
  776390
  808486
  810737
]
2.51 ms
(1.44%)
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
  398074
  398429
  414099
  419949
  427379
  428587
  435879
  445577
  446253
  463953
  470830
  510521
  514627
  515048
  516019
  529131
  530298
  530404
  530498
  530996
  531724
  532866
  533239
  535196
  538725
  544099
  549861
  561189
  565575
  565879
  573928
  576139
  596743
  598229
  601807
  604105
  604358
  604367
  608322
  608605
  608894
  614533
  614549
  624941
  627790
  642526
  643943
  644498
  645038
  645511
  646136
  647134
  648691
  649789
  650235
  650676
  650705
  650730
  653039
  658463
  658540
  669319
  686849
  688474
  690952
  693363
  697853
  705139
  716384
  717443
  718146
  724121
  736387
  739487
  739777
  741186
  745467
  745940
  748419
  749362
  749649
  751470
  757496
  757521
  758092
  764798
  766657
  768784
  769075
  773668
  773730
  776390
  778962
  785544
  788080
  788238
  788511
  791074
  792733
  795303
  796196
  796295
  796621
  797926
  798331
  798557
  800653
  801565
  802369
  806715
  808056
  808086
  808486
  810737
  811797
  812947
  813222
  819111
]
2.11 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls big ass"
]
2.02 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк большая большие жоп"
]
1.85 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.