Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.66 ms
(58.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step sister секс"
]
126.75 ms
(35.18%)
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
  384938
  395227
  396883
  397068
  397555
  399475
  400668
  406849
  407182
  412311
  412717
  413434
  417097
  417975
  421338
  427558
  433352
  433448
  434887
  437260
  437303
  441595
  441691
  441897
  453191
  457304
  459214
  460423
  460894
  464229
  468625
  468909
  476397
  476825
  477319
  483888
  485756
  485891
  486192
  490271
  493476
  493878
  495409
  495646
  500043
  501031
  504282
  510175
  513321
  513748
  524266
  528023
  528107
  532006
  535944
  537813
  543457
  543565
  547392
  550976
  555965
  559949
  564801
  570150
  577944
  579793
  584562
  588735
  595967
  598374
  604726
  610532
  613227
  617195
  619368
  625950
  650076
  650197
  650648
  662050
  662183
  680585
  682625
  696379
  703289
  706498
  709739
  710185
  714580
  718882
  720175
  736591
  739675
  742608
  744251
  748981
  750308
  754156
  757370
  761467
  762310
  763230
  767448
  770813
  772017
  778021
  778975
  780128
  782753
  784429
  785276
  785956
  788050
  791553
  793013
  805715
  806131
  809605
  813585
]
14.62 ms
(4.06%)
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
  476397
  406849
  397555
  543457
  780128
  427558
  441691
  441897
  485756
  501031
  535944
  537813
  504282
  718882
  696379
  619368
  791553
  739675
  703289
  397068
  437303
  433352
  495646
  524266
  528107
  813585
  579793
  782753
  744251
  763230
  709739
  400668
  399475
  459214
  453191
  555965
  564801
  584562
  809605
  785276
  742608
  750308
  714580
  483888
  550976
  559949
  625950
  412311
  543565
  485891
  532006
  720175
  662183
  595967
  793013
  754156
  757370
  412717
  493476
  493878
  617195
  395227
  441595
  433448
  476825
  464229
  513321
  706498
  710185
  650076
  680585
  650648
  662050
  610532
  613227
  778021
  784429
  788050
  806131
  762310
  767448
  736591
  772017
  770813
  778975
  434887
  437260
  490271
  495409
  513748
  477319
  604726
  748981
  785956
  396883
  682625
  805715
  761467
  486192
  384938
  407182
  413434
  417097
  457304
  460423
  598374
  460894
  421338
  468625
  510175
  417975
  500043
  528023
  468909
  570150
  547392
  570835
  650197
  577944
  588735
]
2.31 ms
(0.64%)
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
  384938
  395227
  396883
  397068
  397555
  399475
  400668
  406849
  407182
  412311
  412717
  413434
  417097
  417975
  421338
  427558
  433352
  433448
  434887
  437260
  437303
  441595
  441691
  441897
  453191
  457304
  459214
  460423
  460894
  464229
  468625
  468909
  476397
  476825
  477319
  483888
  485756
  485891
  486192
  490271
  493476
  493878
  495409
  495646
  500043
  501031
  504282
  510175
  513321
  513748
  524266
  528023
  528107
  532006
  535944
  537813
  543457
  543565
  547392
  550976
  555965
  559949
  564801
  570150
  577944
  579793
  584562
  588735
  595967
  598374
  604726
  610532
  613227
  617195
  619368
  625950
  650076
  650197
  650648
  662050
  662183
  680585
  682625
  696379
  703289
  706498
  709739
  710185
  714580
  718882
  720175
  736591
  739675
  742608
  744251
  748981
  750308
  754156
  757370
  761467
  762310
  763230
  767448
  770813
  772017
  778021
  778975
  780128
  782753
  784429
  785276
  785956
  788050
  791553
  793013
  805715
  806131
  809605
  813585
]
1.94 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step sister fuck"
]
1.61 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step sister секс"
]

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.