Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.08 ms
(81.76%)
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
  476476
  519246
  541764
  542493
  544299
  546469
  547859
  560079
  560390
  560920
  561002
  562996
  563123
  563195
  563213
  563383
  563538
  566684
  566860
  574263
  576626
  576647
  581305
  581353
  581355
  583851
  584104
  592415
  592443
  592452
  592489
  592494
  592501
  592518
  592522
  593447
  598058
  600712
  603161
  606598
  620172
  621310
  621315
  621322
  621323
  633161
  634692
  644296
  644323
  644331
  645233
  647630
  650494
  651210
  668465
  668985
  669566
  669567
  670106
  670108
  670773
  671701
  671707
  671714
  671730
  671740
  671745
  671751
  672117
  672138
  672144
  672745
  677705
  681059
  681085
  687119
  689699
  690853
  690870
  692188
  693055
  694089
  694203
  694470
  695246
  695613
  695626
  695948
  696355
  697354
  697368
  698531
  699567
  699578
  700741
  703048
  703091
  703436
  703511
  703528
  703538
  703554
  703556
  707318
  708462
  711907
  716746
  719097
  721715
  724173
  724241
  742971
  744294
  750064
  759706
  770268
  789659
  790814
  790827
  823358
]
16.42 ms
(10.91%)
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
  690853
  592518
  620172
  644323
  823358
  563538
  670106
  546469
  574263
  634692
  592489
  770268
  711907
  566860
  672117
  703511
  681059
  707318
  689699
  703556
  544299
  560079
  647630
  694203
  695626
  671714
  692188
  576647
  621315
  789659
  651210
  668465
  697368
  699578
  576626
  724241
  644331
  547859
  668985
  694089
  681085
  592501
  700741
  542493
  563123
  669566
  671701
  671745
  693055
  697354
  672745
  698531
  703554
  633161
  621310
  759706
  581353
  750064
  541764
  519246
  476476
  562996
  563383
  581305
  695613
  703048
  560920
  592494
  593447
  600712
  621322
  744294
  672144
  670108
  703436
  721715
  671740
  703538
  592452
  644296
  708462
  583851
  694470
  677705
  696355
  671730
  699567
  606598
  603161
  592522
  742971
  703091
  790814
  670773
  645233
  672138
  695948
  598058
  592415
  716746
  581355
  650494
  690870
  719097
  671707
  703528
  669567
  671751
  687119
  695246
  563213
  592443
  724173
  621323
  790827
  560390
  563195
  561002
  566684
  584104
]
3.33 ms
(2.21%)
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
  476476
  519246
  541764
  542493
  544299
  546469
  547859
  560079
  560390
  560920
  561002
  562996
  563123
  563195
  563213
  563383
  563538
  566684
  566860
  574263
  576626
  576647
  581305
  581353
  581355
  583851
  584104
  592415
  592443
  592452
  592489
  592494
  592501
  592518
  592522
  593447
  598058
  600712
  603161
  606598
  620172
  621310
  621315
  621322
  621323
  633161
  634692
  644296
  644323
  644331
  645233
  647630
  650494
  651210
  668465
  668985
  669566
  669567
  670106
  670108
  670773
  671701
  671707
  671714
  671730
  671740
  671745
  671751
  672117
  672138
  672144
  672745
  677705
  681059
  681085
  687119
  689699
  690853
  690870
  692188
  693055
  694089
  694203
  694470
  695246
  695613
  695626
  695948
  696355
  697354
  697368
  698531
  699567
  699578
  700741
  703048
  703091
  703436
  703511
  703528
  703538
  703554
  703556
  707318
  708462
  711907
  716746
  719097
  721715
  724173
  724241
  742971
  744294
  750064
  759706
  770268
  789659
  790814
  790827
  823358
]
2.10 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom секс ретр"
]
1.97 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom sex retro"
]
1.93 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.14%)
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.