Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.67 ms
(87.02%)
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
  80510
  385600
  398233
  406977
  422350
  462182
  489255
  521002
  529856
  537211
  545254
  560455
  564098
  572730
  573244
  576511
  578559
  585599
  588172
  593794
  593821
  596394
  601855
  603945
  614574
  616014
  616344
  616809
  626708
  628229
  636137
  639186
  663253
  668342
  672783
  675450
  688940
  696720
  697722
  700874
  707901
  708337
  708463
  709284
  710177
  712767
  719127
  719452
  722121
  724680
  725331
  730455
  731140
  732598
  733297
  734523
  735009
  735322
  741065
  748350
  749417
  749592
  756268
  763603
  764805
  765387
  767824
  774931
  776235
  776372
  777459
  777803
  778796
  778911
  778912
  778917
  779638
  780238
  780954
  781186
  781289
  781298
  782613
  782634
  784339
  784426
  786688
  787578
  790251
  790757
  791049
  791540
  792355
  792915
  793809
  794596
  794740
  795821
  796019
  796025
  796036
  796040
  796044
  796580
  799443
  799550
  799991
  800036
  800140
  802007
  802326
  802804
  803416
  803435
  803442
  804844
  808251
  810493
]
11.43 ms
(6.39%)
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
  791540
  799550
  799991
  777803
  778044
  779638
  781186
  784426
  800140
  803416
  724680
  725331
  730455
  734523
  749417
  749592
  765416
  793809
  763603
  731140
  735322
  748350
  765387
  733297
  741065
  732598
  735009
  722121
  778911
  778917
  784339
  792915
  802326
  804844
  80510
  422350
  385600
  398233
  778912
  791049
  521002
  777459
  767824
  808251
  756268
  764805
  406977
  489255
  462182
  537211
  529856
  560455
  578559
  572730
  545254
  564098
  573244
  697722
  700874
  707901
  708463
  719452
  663253
  675450
  688940
  696720
  710177
  719127
  668342
  672783
  708337
  709284
  712767
  576511
  588172
  593794
  593821
  601855
  616809
  626708
  628229
  636137
  614574
  616014
  596394
  603945
  616344
  585599
  639186
  776372
  780954
  781289
  792355
  794596
  795821
  796019
  796044
  796580
  799443
  800036
  802804
  810493
  774931
  776235
  778796
  780238
  781298
  782613
  782634
  786688
  787578
  790251
  790757
  794740
  796025
  796036
  796040
  802007
  803435
  803442
]
4.45 ms
(2.49%)
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
  80510
  385600
  398233
  406977
  422350
  462182
  489255
  521002
  529856
  537211
  545254
  560455
  564098
  572730
  573244
  576511
  578559
  585599
  588172
  593794
  593821
  596394
  601855
  603945
  614574
  616014
  616344
  616809
  626708
  628229
  636137
  639186
  663253
  668342
  672783
  675450
  688940
  696720
  697722
  700874
  707901
  708337
  708463
  709284
  710177
  712767
  719127
  719452
  722121
  724680
  725331
  730455
  731140
  732598
  733297
  734523
  735009
  735322
  741065
  748350
  749417
  749592
  756268
  763603
  764805
  765387
  767824
  774931
  776235
  776372
  777459
  777803
  778796
  778911
  778912
  778917
  779638
  780238
  780954
  781186
  781289
  781298
  782613
  782634
  784339
  784426
  786688
  787578
  790251
  790757
  791049
  791540
  792355
  792915
  793809
  794596
  794740
  795821
  796019
  796025
  796036
  796040
  796044
  796580
  799443
  799550
  799991
  800036
  800140
  802007
  802326
  802804
  803416
  803435
  803442
  804844
  808251
  810493
]
2.16 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm to mouth"
]
1.84 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм mouth"
]
1.79 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм mouth"
]

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.