Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.37 ms
(87.27%)
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
  6741
  7219
  251476
  373842
  385505
  386813
  391253
  392748
  393937
  394853
  395679
  395733
  396639
  397053
  397436
  398231
  400143
  400209
  400450
  400458
  400469
  400927
  401313
  402870
  404276
  406501
  408774
  410897
  412289
  418493
  419629
  423301
  429300
  429543
  432760
  434638
  447562
  453785
  456608
  458196
  461918
  463857
  468711
  469846
  473004
  476808
  476913
  477823
  479190
  487093
  489534
  489569
  495759
  502641
  509025
  509952
  510677
  511713
  512276
  512604
  517668
  519976
  520950
  529248
  531409
  538197
  538204
  538372
  541250
  543892
  546603
  547823
  548034
  548775
  552924
  558131
  559785
  560541
  560573
  562886
  563800
  563878
  565417
  565951
  566475
  566621
  570013
  570269
  570493
  570650
  571615
  571918
  573950
  575056
  575516
  575740
  576271
  576323
  576389
  579620
  581658
  584322
  586789
  592300
  592329
  593138
  595819
  597242
  627813
  630529
  656545
  665107
  667563
  669577
  707915
  716236
  719150
  722912
  748416
  803658
]
16.35 ms
(8.14%)
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
  566475
  592300
  748416
  7219
  502641
  511713
  538204
  579620
  400143
  394853
  396639
  519976
  576271
  543892
  560573
  552924
  592329
  597242
  400927
  489569
  538372
  509025
  373842
  453785
  716236
  400450
  429300
  489534
  400458
  571615
  575740
  559785
  570493
  570013
  593138
  463857
  541250
  669577
  479190
  558131
  509952
  627813
  566621
  547823
  395679
  386813
  392748
  391253
  397053
  548034
  565417
  667563
  410897
  495759
  487093
  385505
  419629
  456608
  565951
  575056
  560541
  722912
  586789
  630529
  477823
  429543
  400469
  401313
  418493
  408774
  473004
  563878
  476808
  404276
  529248
  412289
  656545
  402870
  476913
  398231
  531409
  546603
  548775
  576323
  468711
  510677
  665107
  570269
  571918
  803658
  707915
  393937
  397436
  512276
  538197
  395733
  406501
  719150
  434638
  520950
  584322
  432760
  251476
  581658
  512604
  6741
  562886
  400209
  423301
  469846
  576389
  447562
  458196
  461918
  517668
  570650
  575516
  563800
  573950
  595819
]
3.13 ms
(1.56%)
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
  6741
  7219
  251476
  373842
  385505
  386813
  391253
  392748
  393937
  394853
  395679
  395733
  396639
  397053
  397436
  398231
  400143
  400209
  400450
  400458
  400469
  400927
  401313
  402870
  404276
  406501
  408774
  410897
  412289
  418493
  419629
  423301
  429300
  429543
  432760
  434638
  447562
  453785
  456608
  458196
  461918
  463857
  468711
  469846
  473004
  476808
  476913
  477823
  479190
  487093
  489534
  489569
  495759
  502641
  509025
  509952
  510677
  511713
  512276
  512604
  517668
  519976
  520950
  529248
  531409
  538197
  538204
  538372
  541250
  543892
  546603
  547823
  548034
  548775
  552924
  558131
  559785
  560541
  560573
  562886
  563800
  563878
  565417
  565951
  566475
  566621
  570013
  570269
  570493
  570650
  571615
  571918
  573950
  575056
  575516
  575740
  576271
  576323
  576389
  579620
  581658
  584322
  586789
  592300
  592329
  593138
  595819
  597242
  627813
  630529
  656545
  665107
  667563
  669577
  707915
  716236
  719150
  722912
  748416
  803658
]
1.76 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð¥ð╗ð¥ð┤ð¥ð╣ ð┤ðÁð▓ÐâÐêð║ð░ ÐüðÁð║ÐüðÔǪ"
]
1.55 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодой девушк секс"
]
1.25 ms
(0.62%)
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.