Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.12 ms
(84.35%)
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
  6806
  12845
  47284
  107348
  129955
  136203
  379619
  381873
  382242
  382254
  383932
  389451
  391044
  396928
  424870
  430560
  430564
  445240
  448666
  460407
  462921
  464817
  466327
  474413
  482246
  483310
  487982
  489246
  490267
  495206
  500450
  504060
  506238
  507793
  510822
  520230
  521200
  521213
  521567
  521693
  524401
  530431
  530523
  530570
  532057
  532632
  532718
  532722
  533183
  533692
  538035
  538931
  542396
  543052
  543094
  543211
  543250
  543566
  543666
  543738
  544341
  546218
  547861
  548089
  548513
  549262
  549269
  550561
  552056
  557435
  560089
  566711
  569697
  569699
  569709
  569777
  569781
  570902
  581718
  583823
  585619
  586126
  600808
  605313
  607556
  617782
  622916
  623273
  630393
  640494
  668406
  714121
  716135
  722465
  725474
  729917
  729919
  729943
  734370
  735385
  740614
  744835
  756493
  765168
  778655
  782762
  782773
  796748
  796853
  803456
  810045
  814639
  817012
  817082
  817113
  817182
  819552
  820715
  823259
  827954
]
13.50 ms
(9.72%)
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
  506238
  532632
  533692
  538035
  521567
  521693
  543250
  543566
  569709
  581718
  583823
  543094
  550561
  557435
  543738
  547861
  552056
  566711
  569699
  570902
  668406
  546218
  549269
  585619
  617782
  623273
  796748
  810045
  607556
  640494
  500450
  532057
  495206
  6806
  391044
  383932
  107348
  381873
  12845
  389451
  430564
  430560
  823259
  817082
  817012
  817113
  474413
  482246
  507793
  532718
  533183
  538931
  520230
  532722
  521213
  524401
  530431
  530570
  543052
  548513
  542396
  543211
  543666
  548089
  569697
  569777
  544341
  714121
  716135
  722465
  549262
  560089
  569781
  586126
  622916
  630393
  600808
  778655
  782762
  782773
  725474
  729917
  729919
  734370
  796853
  729943
  735385
  744835
  740614
  803456
  382254
  47284
  448666
  490267
  504060
  530523
  510822
  756493
  521200
  483310
  379619
  396928
  820715
  462921
  605313
  765168
  445240
  464817
  129955
  136203
  382242
  424870
  814639
  817182
  819552
  827954
  460407
  487982
  489246
  466327
]
2.36 ms
(1.70%)
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
  6806
  12845
  47284
  107348
  129955
  136203
  379619
  381873
  382242
  382254
  383932
  389451
  391044
  396928
  424870
  430560
  430564
  445240
  448666
  460407
  462921
  464817
  466327
  474413
  482246
  483310
  487982
  489246
  490267
  495206
  500450
  504060
  506238
  507793
  510822
  520230
  521200
  521213
  521567
  521693
  524401
  530431
  530523
  530570
  532057
  532632
  532718
  532722
  533183
  533692
  538035
  538931
  542396
  543052
  543094
  543211
  543250
  543566
  543666
  543738
  544341
  546218
  547861
  548089
  548513
  549262
  549269
  550561
  552056
  557435
  560089
  566711
  569697
  569699
  569709
  569777
  569781
  570902
  581718
  583823
  585619
  586126
  600808
  605313
  607556
  617782
  622916
  623273
  630393
  640494
  668406
  714121
  716135
  722465
  725474
  729917
  729919
  729943
  734370
  735385
  740614
  744835
  756493
  765168
  778655
  782762
  782773
  796748
  796853
  803456
  810045
  814639
  817012
  817082
  817113
  817182
  819552
  820715
  823259
  827954
]
1.88 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "domination milf"
]
1.46 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "domination milf"
]
1.14 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "domination milf"
]

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.