Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.71 ms
(83.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
  424193
  475140
  480415
  516140
  536923
  543882
  545365
  545451
  545790
  546121
  546950
  547483
  547801
  549836
  551923
  555065
  557546
  557969
  559049
  559286
  561803
  563419
  563892
  566998
  567110
  568052
  572268
  573311
  575302
  575338
  575533
  576125
  578400
  578412
  580319
  580345
  586372
  586407
  587418
  590396
  591643
  591664
  592681
  595735
  596084
  596125
  598194
  598253
  599906
  601548
  603187
  603327
  603586
  604519
  605455
  606880
  607185
  607218
  607667
  613432
  619091
  629658
  629886
  632681
  643043
  649136
  650485
  666719
  666869
  668537
  669884
  671737
  681257
  691201
  692711
  699729
  705663
  756230
  756491
  759967
  760667
  761736
  763739
  770149
  770663
  770901
  776731
  777577
  781792
  782653
  783312
  785530
  785877
  786454
  787047
  787272
  788119
  788790
  789526
  789647
  792550
  793340
  798598
  799093
  800307
  801348
  801917
  801953
  801957
  802029
  807599
  807711
  809415
  810983
  811007
  812565
  812824
  812885
  813084
  814681
]
14.10 ms
(9.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
  557969
  559049
  559286
  561803
  567110
  575533
  543882
  546121
  547483
  547801
  551923
  563419
  566998
  575302
  578412
  580319
  580345
  545451
  545790
  557546
  563892
  578400
  649136
  650485
  666719
  666869
  671737
  681257
  691201
  699729
  668537
  669884
  692711
  545365
  546950
  549836
  555065
  568052
  572268
  573311
  575338
  576125
  595735
  599906
  607185
  607218
  619091
  586372
  591664
  592681
  596084
  598194
  604519
  607667
  591643
  596125
  598253
  603187
  603327
  603586
  605455
  629658
  629886
  632681
  586407
  587418
  590396
  601548
  606880
  643043
  777577
  781792
  782653
  785530
  800307
  801348
  807599
  807711
  813084
  776731
  787047
  788790
  793340
  798598
  801957
  809415
  812565
  760667
  761736
  783312
  785877
  786454
  788119
  789526
  792550
  799093
  801917
  801953
  810983
  812885
  770901
  756230
  756491
  770149
  759967
  763739
  770663
  613432
  705663
  787272
  789647
  802029
  811007
  812824
  424193
  475140
  480415
  536923
  516140
  814681
]
2.86 ms
(2.01%)
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
  424193
  475140
  480415
  516140
  536923
  543882
  545365
  545451
  545790
  546121
  546950
  547483
  547801
  549836
  551923
  555065
  557546
  557969
  559049
  559286
  561803
  563419
  563892
  566998
  567110
  568052
  572268
  573311
  575302
  575338
  575533
  576125
  578400
  578412
  580319
  580345
  586372
  586407
  587418
  590396
  591643
  591664
  592681
  595735
  596084
  596125
  598194
  598253
  599906
  601548
  603187
  603327
  603586
  604519
  605455
  606880
  607185
  607218
  607667
  613432
  619091
  629658
  629886
  632681
  643043
  649136
  650485
  666719
  666869
  668537
  669884
  671737
  681257
  691201
  692711
  699729
  705663
  756230
  756491
  759967
  760667
  761736
  763739
  770149
  770663
  770901
  776731
  777577
  781792
  782653
  783312
  785530
  785877
  786454
  787047
  787272
  788119
  788790
  789526
  789647
  792550
  793340
  798598
  799093
  800307
  801348
  801917
  801953
  801957
  802029
  807599
  807711
  809415
  810983
  811007
  812565
  812824
  812885
  813084
  814681
]
1.99 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gape mom"
]
1.84 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк mom"
]
1.20 ms
(0.84%)
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.