Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.55 ms
(86.59%)
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
  386558
  397203
  397869
  409340
  445424
  524338
  535985
  536298
  538684
  539458
  545358
  546550
  548483
  550682
  555153
  557446
  573168
  576621
  582203
  583364
  592470
  601026
  603343
  604840
  604877
  606121
  607213
  607628
  609977
  614182
  618341
  621168
  625679
  629971
  630125
  633456
  644187
  648446
  651117
  672723
  678761
  678780
  708614
  714393
  715416
  717621
  721178
  722678
  725562
  726210
  730485
  735292
  735919
  736092
  740457
  740573
  741610
  742427
  744173
  744980
  745058
  750885
  751370
  751485
  751494
  752190
  753019
  753074
  754744
  755183
  755193
  755351
  756045
  757216
  760590
  763393
  768598
  770020
  770100
  770231
  771950
  771979
  774078
  774728
  774739
  774742
  776542
  777522
  781799
  781948
  781956
  782479
  782489
  782496
  785831
  785882
  787352
  790764
  795527
  797369
  802573
  802739
  803749
  805724
  806984
  808711
  808862
  811104
  811109
  812226
  812492
  812733
  813597
  819222
  819232
  819243
  819261
  823406
  824563
  826142
]
12.03 ms
(7.57%)
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
  805724
  735292
  770020
  726210
  755183
  768598
  750885
  751485
  754744
  774078
  721178
  803749
  386558
  409340
  813597
  555153
  756045
  397869
  826142
  819222
  819243
  583364
  651117
  601026
  606121
  604877
  609977
  629971
  625679
  782479
  785831
  802573
  777522
  811104
  744173
  752190
  753019
  785882
  790764
  751494
  771950
  744980
  755351
  740573
  751370
  771979
  725562
  633456
  812226
  539458
  557446
  715416
  722678
  672723
  592470
  774742
  776542
  795527
  812733
  745058
  770100
  717621
  781956
  782496
  787352
  397203
  708614
  678780
  582203
  603343
  604840
  618341
  802739
  811109
  763393
  770231
  740457
  757216
  760590
  808711
  808862
  812492
  524338
  819232
  445424
  819261
  823406
  824563
  535985
  536298
  538684
  545358
  548483
  550682
  546550
  573168
  576621
  714393
  648446
  678761
  607628
  644187
  607213
  614182
  621168
  774728
  781799
  806984
  781948
  741610
  782489
  797369
  742427
  730485
  735919
  755193
  736092
  753074
  630125
  774739
]
2.81 ms
(1.77%)
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
  386558
  397203
  397869
  409340
  445424
  524338
  535985
  536298
  538684
  539458
  545358
  546550
  548483
  550682
  555153
  557446
  573168
  576621
  582203
  583364
  592470
  601026
  603343
  604840
  604877
  606121
  607213
  607628
  609977
  614182
  618341
  621168
  625679
  629971
  630125
  633456
  644187
  648446
  651117
  672723
  678761
  678780
  708614
  714393
  715416
  717621
  721178
  722678
  725562
  726210
  730485
  735292
  735919
  736092
  740457
  740573
  741610
  742427
  744173
  744980
  745058
  750885
  751370
  751485
  751494
  752190
  753019
  753074
  754744
  755183
  755193
  755351
  756045
  757216
  760590
  763393
  768598
  770020
  770100
  770231
  771950
  771979
  774078
  774728
  774739
  774742
  776542
  777522
  781799
  781948
  781956
  782479
  782489
  782496
  785831
  785882
  787352
  790764
  795527
  797369
  802573
  802739
  803749
  805724
  806984
  808711
  808862
  811104
  811109
  812226
  812492
  812733
  813597
  819222
  819232
  819243
  819261
  823406
  824563
  826142
]
1.85 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom solo tits"
]
1.78 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom соло сиськ"
]
1.32 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom соло сиськ"
]

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.