Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.31 ms
(86.37%)
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
  73413
  185435
  233274
  370957
  381747
  383971
  386331
  387179
  395427
  398704
  402822
  413770
  423781
  423799
  427813
  428141
  432429
  434242
  437564
  441691
  447250
  447711
  448253
  449854
  449862
  453661
  453944
  455391
  458109
  458534
  459077
  461286
  472074
  475607
  477605
  479296
  485062
  485605
  486053
  486423
  487316
  488931
  489269
  495322
  498247
  498557
  499719
  506755
  507030
  508223
  521736
  525304
  527461
  529507
  531442
  535241
  535846
  535905
  538218
  552208
  555750
  556174
  557223
  557963
  563190
  566842
  568964
  569803
  570276
  573413
  573592
  574626
  577486
  580270
  581186
  581511
  582383
  584869
  586687
  587061
  587134
  588415
  591286
  591563
  592073
  592323
  594510
  595554
  595664
  597126
  597767
  597946
  607299
  608900
  616916
  616936
  624514
  625217
  644626
  648202
  651548
  651563
  652623
  652784
  653460
  656744
  662823
  664836
  665889
  673704
  677862
  677906
  695924
  699449
  700915
  707082
  740577
  748042
  791186
  813467
]
10.95 ms
(7.20%)
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
  506755
  580270
  700915
  387179
  644626
  586687
  485062
  563190
  459077
  597946
  597126
  383971
  185435
  398704
  423781
  427813
  413770
  441691
  437564
  447711
  449862
  458109
  475607
  449854
  477605
  488931
  447250
  448253
  453944
  458534
  461286
  472074
  495322
  507030
  525304
  527461
  499719
  535905
  521736
  535241
  535846
  486053
  557963
  581186
  556174
  569803
  573413
  552208
  557223
  566842
  570276
  574626
  581511
  584869
  651548
  651563
  699449
  648202
  662823
  677862
  707082
  652623
  652784
  653460
  656744
  677906
  568964
  577486
  595554
  595664
  597767
  607299
  608900
  588415
  591563
  616936
  587061
  587134
  616916
  624514
  592073
  592323
  594510
  791186
  813467
  748042
  740577
  625217
  386331
  453661
  455391
  479296
  381747
  432429
  233274
  402822
  423799
  434242
  487316
  498557
  508223
  538218
  485605
  486423
  489269
  498247
  529507
  73413
  395427
  370957
  428141
  531442
  582383
  555750
  573592
  665889
  673704
  664836
  695924
  591286
]
2.38 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
  73413
  185435
  233274
  370957
  381747
  383971
  386331
  387179
  395427
  398704
  402822
  413770
  423781
  423799
  427813
  428141
  432429
  434242
  437564
  441691
  447250
  447711
  448253
  449854
  449862
  453661
  453944
  455391
  458109
  458534
  459077
  461286
  472074
  475607
  477605
  479296
  485062
  485605
  486053
  486423
  487316
  488931
  489269
  495322
  498247
  498557
  499719
  506755
  507030
  508223
  521736
  525304
  527461
  529507
  531442
  535241
  535846
  535905
  538218
  552208
  555750
  556174
  557223
  557963
  563190
  566842
  568964
  569803
  570276
  573413
  573592
  574626
  577486
  580270
  581186
  581511
  582383
  584869
  586687
  587061
  587134
  588415
  591286
  591563
  592073
  592323
  594510
  595554
  595664
  597126
  597767
  597946
  607299
  608900
  616916
  616936
  624514
  625217
  644626
  648202
  651548
  651563
  652623
  652784
  653460
  656744
  662823
  664836
  665889
  673704
  677862
  677906
  695924
  699449
  700915
  707082
  740577
  748042
  791186
  813467
]
1.98 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "наездниц поз молодые"
]
1.95 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сверху молодые"
]
1.95 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "наездниц поз молодые"
]
1.51 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.