Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.82 ms
(86.77%)
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
  212183
  391873
  396312
  413131
  414753
  426886
  427407
  432358
  455779
  461128
  463232
  468347
  485425
  490392
  492468
  493609
  493736
  495707
  500965
  503721
  507442
  507838
  507921
  508680
  510018
  510058
  512144
  513163
  516514
  519828
  519971
  523889
  526465
  526959
  527887
  528225
  529886
  531395
  533212
  534827
  535277
  538100
  538521
  539016
  542668
  543147
  544536
  546335
  546664
  547207
  547711
  552690
  552727
  556561
  557910
  558655
  559105
  562751
  564326
  564788
  565765
  566109
  570991
  572714
  572896
  573276
  574117
  577570
  577653
  578572
  578598
  578810
  579775
  586706
  587613
  589735
  591039
  591446
  594018
  594412
  595224
  597670
  598216
  600887
  601198
  601229
  601414
  602707
  603189
  605697
  605958
  606179
  607044
  608220
  613663
  616442
  616643
  619779
  621194
  623304
  626773
  627532
  629446
  632246
  633297
  637560
  644517
  650867
  651306
  653891
  653893
  655558
  656525
  657244
  659066
  666030
  667025
  682409
  701580
  701621
]
11.74 ms
(7.34%)
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
  633297
  432358
  391873
  414753
  492468
  396312
  413131
  493609
  495707
  507921
  538521
  523889
  526959
  534827
  535277
  539016
  544536
  547711
  556561
  557910
  562751
  572896
  546335
  572714
  552690
  552727
  559105
  577653
  578572
  653893
  667025
  650867
  655558
  659066
  564788
  601229
  608220
  597670
  598216
  602707
  621194
  644517
  589735
  591039
  591446
  594018
  616442
  619779
  637560
  587613
  605697
  605958
  606179
  616643
  623304
  632246
  426886
  463232
  468347
  503721
  526465
  519971
  546664
  579775
  653891
  427407
  490392
  461128
  493736
  508680
  512144
  513163
  519828
  538100
  507442
  527887
  533212
  547207
  558655
  577570
  578810
  570991
  666030
  682409
  701580
  701621
  578598
  600887
  601198
  603189
  601414
  586706
  594412
  595224
  607044
  455779
  485425
  510058
  528225
  565765
  542668
  564326
  651306
  629446
  613663
  529886
  500965
  510018
  566109
  627532
  626773
  212183
  516514
  507838
  531395
  574117
  543147
  573276
  656525
  657244
]
2.52 ms
(1.57%)
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
  212183
  391873
  396312
  413131
  414753
  426886
  427407
  432358
  455779
  461128
  463232
  468347
  485425
  490392
  492468
  493609
  493736
  495707
  500965
  503721
  507442
  507838
  507921
  508680
  510018
  510058
  512144
  513163
  516514
  519828
  519971
  523889
  526465
  526959
  527887
  528225
  529886
  531395
  533212
  534827
  535277
  538100
  538521
  539016
  542668
  543147
  544536
  546335
  546664
  547207
  547711
  552690
  552727
  556561
  557910
  558655
  559105
  562751
  564326
  564788
  565765
  566109
  570991
  572714
  572896
  573276
  574117
  577570
  577653
  578572
  578598
  578810
  579775
  586706
  587613
  589735
  591039
  591446
  594018
  594412
  595224
  597670
  598216
  600887
  601198
  601229
  601414
  602707
  603189
  605697
  605958
  606179
  607044
  608220
  613663
  616442
  616643
  619779
  621194
  623304
  626773
  627532
  629446
  632246
  633297
  637560
  644517
  650867
  651306
  653891
  653893
  655558
  656525
  657244
  659066
  666030
  667025
  682409
  701580
  701621
]
2.07 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex telephone"
]
1.79 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс телефон"
]
1.63 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.89%)
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.