Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.29 ms
(85.84%)
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
  17250
  96623
  117073
  263296
  314552
  326305
  382057
  387678
  387951
  391677
  392964
  393108
  393848
  395861
  396139
  396212
  398089
  398364
  398557
  399418
  401108
  402159
  403965
  404209
  408009
  408586
  409843
  415790
  421866
  423505
  423909
  427252
  428044
  428582
  440749
  440932
  441584
  445285
  447145
  447543
  448370
  452971
  453785
  453833
  456567
  457146
  457516
  457942
  458387
  459233
  460330
  460763
  465157
  466679
  466974
  467606
  468088
  468341
  468699
  470052
  471685
  473450
  476142
  478411
  479682
  483559
  491639
  493658
  493899
  499884
  504025
  508177
  508193
  508966
  509725
  510679
  511481
  512458
  512948
  518762
  521834
  533733
  534064
  534609
  541874
  547420
  547431
  549126
  550207
  555220
  555337
  559685
  561002
  561861
  562228
  566770
  566875
  567226
  569132
  569225
  571166
  571430
  580628
  582479
  591353
  591992
  592472
  597584
  599072
  602602
  606651
  607254
  610052
  629458
  653261
  654388
  674110
  740607
  745352
  776099
]
14.56 ms
(8.78%)
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
  479682
  460763
  478411
  457942
  468341
  465157
  562228
  592472
  610052
  314552
  445285
  452971
  569132
  393108
  263296
  17250
  398089
  398557
  401108
  403965
  423909
  428044
  408009
  427252
  440932
  448370
  453785
  460330
  476142
  473450
  493658
  453833
  458387
  466974
  508966
  508193
  509725
  512948
  533733
  499884
  534609
  508177
  511481
  521834
  466679
  549126
  567226
  555337
  561002
  561861
  566875
  582479
  547431
  566770
  571430
  654388
  674110
  653261
  571166
  597584
  591353
  591992
  599072
  607254
  740607
  117073
  326305
  387951
  392964
  421866
  423505
  457146
  391677
  393848
  395861
  402159
  409843
  447543
  471685
  456567
  491639
  534064
  550207
  541874
  483559
  606651
  602602
  382057
  396212
  398364
  399418
  440749
  447145
  467606
  470052
  518762
  504025
  468088
  547420
  559685
  580628
  569225
  555220
  629458
  387678
  396139
  408586
  441584
  459233
  428582
  468699
  404209
  415790
  457516
  510679
  512458
  493899
  776099
  745352
  96623
]
2.64 ms
(1.59%)
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
  17250
  96623
  117073
  263296
  314552
  326305
  382057
  387678
  387951
  391677
  392964
  393108
  393848
  395861
  396139
  396212
  398089
  398364
  398557
  399418
  401108
  402159
  403965
  404209
  408009
  408586
  409843
  415790
  421866
  423505
  423909
  427252
  428044
  428582
  440749
  440932
  441584
  445285
  447145
  447543
  448370
  452971
  453785
  453833
  456567
  457146
  457516
  457942
  458387
  459233
  460330
  460763
  465157
  466679
  466974
  467606
  468088
  468341
  468699
  470052
  471685
  473450
  476142
  478411
  479682
  483559
  491639
  493658
  493899
  499884
  504025
  508177
  508193
  508966
  509725
  510679
  511481
  512458
  512948
  518762
  521834
  533733
  534064
  534609
  541874
  547420
  547431
  549126
  550207
  555220
  555337
  559685
  561002
  561861
  562228
  566770
  566875
  567226
  569132
  569225
  571166
  571430
  580628
  582479
  591353
  591992
  592472
  597584
  599072
  602602
  606651
  607254
  610052
  629458
  653261
  654388
  674110
  740607
  745352
  776099
]
1.85 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð░ð¢ð░ð╗Ðîð¢Ðïð╣ ÐüðÁð║Ðü ð▓ð¥ð╗ð¥Ðüð░ÐÔǪ"
]
1.55 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал волос"
]
1.45 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.87%)
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.