Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
348.48 ms
(93.98%)
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
  3392
  6866
  17190
  120497
  373875
  384452
  386673
  386771
  388353
  389319
  390904
  391590
  392554
  393052
  395642
  396098
  396519
  397353
  398257
  398446
  400026
  401124
  403348
  410776
  428574
  432762
  441479
  458920
  464598
  487205
  487429
  500308
  501649
  518905
  520764
  529025
  536245
  537245
  540844
  542042
  543162
  544782
  561012
  566873
  575109
  590799
  590806
  594267
  595467
  597560
  597798
  598135
  598754
  600146
  603052
  605329
  620978
  624170
  627418
  632118
  632593
  640407
  647275
  650230
  651974
  652955
  654346
  658837
  671665
  692047
  696160
  698841
  700282
  707088
  712174
  717890
  718687
  718700
  719376
  720465
  722483
  722649
  727773
  728404
  728676
  729160
  730346
  741529
  742942
  743087
  746802
  747138
  747443
  747498
  752595
  752721
  753259
  753797
  754180
  755634
  756073
  760909
  762972
  763061
  765573
  766461
  777652
  778962
  779010
  781052
  782842
  785582
  787505
  788414
  791328
  797389
  799862
  821397
  822717
  824927
]
13.11 ms
(3.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
  386673
  3392
  597560
  728404
  728676
  590799
  487205
  501649
  388353
  120497
  487429
  566873
  753797
  393052
  632118
  743087
  824927
  544782
  791328
  386771
  632593
  575109
  441479
  652955
  654346
  722649
  597798
  600146
  590806
  624170
  785582
  752595
  754180
  787505
  741529
  747138
  742942
  729160
  747498
  756073
  777652
  384452
  520764
  529025
  398257
  821397
  720465
  788414
  766461
  760909
  763061
  395642
  410776
  700282
  6866
  594267
  765573
  403348
  500308
  722483
  391590
  620978
  779010
  797389
  400026
  458920
  390904
  753259
  627418
  782842
  396519
  536245
  707088
  730346
  747443
  542042
  781052
  17190
  432762
  518905
  537245
  605329
  799862
  712174
  392554
  397353
  401124
  464598
  398446
  428574
  540844
  561012
  543162
  650230
  671665
  658837
  696160
  717890
  719376
  647275
  603052
  598135
  598754
  746802
  755634
  752721
  762972
  727773
  718687
  373875
  396098
  389319
  822717
  692047
  718700
  651974
  698841
  640407
  595467
  778962
]
2.95 ms
(0.80%)
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
  3392
  6866
  17190
  120497
  373875
  384452
  386673
  386771
  388353
  389319
  390904
  391590
  392554
  393052
  395642
  396098
  396519
  397353
  398257
  398446
  400026
  401124
  403348
  410776
  428574
  432762
  441479
  458920
  464598
  487205
  487429
  500308
  501649
  518905
  520764
  529025
  536245
  537245
  540844
  542042
  543162
  544782
  561012
  566873
  575109
  590799
  590806
  594267
  595467
  597560
  597798
  598135
  598754
  600146
  603052
  605329
  620978
  624170
  627418
  632118
  632593
  640407
  647275
  650230
  651974
  652955
  654346
  658837
  671665
  692047
  696160
  698841
  700282
  707088
  712174
  717890
  718687
  718700
  719376
  720465
  722483
  722649
  727773
  728404
  728676
  729160
  730346
  741529
  742942
  743087
  746802
  747138
  747443
  747498
  752595
  752721
  753259
  753797
  754180
  755634
  756073
  760909
  762972
  763061
  765573
  766461
  777652
  778962
  779010
  781052
  782842
  785582
  787505
  788414
  791328
  797389
  799862
  821397
  822717
  824927
]
1.86 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen anal girls"
]
1.69 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen анал девушк"
]
1.46 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen анал девушк"
]

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.