Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.15 ms
(86.20%)
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
  418244
  424815
  425095
  427857
  432663
  432746
  433982
  443624
  445458
  461411
  463239
  473363
  476446
  486602
  490536
  493277
  496896
  498474
  499603
  518041
  518641
  522210
  526265
  541062
  542376
  549708
  560521
  562702
  562941
  565013
  565863
  574160
  579175
  586505
  591728
  591744
  594589
  595283
  597911
  599645
  605200
  616644
  629621
  630135
  631632
  632176
  636504
  639957
  644129
  644168
  649384
  664462
  665622
  677624
  678868
  680026
  681237
  695719
  697182
  697308
  700470
  700506
  705934
  708311
  710890
  711345
  712094
  720066
  721885
  725646
  727385
  727434
  731479
  736106
  742009
  742735
  746539
  748051
  756399
  756986
  757468
  761216
  761720
  764163
  768297
  769010
  770326
  771045
  771137
  773319
  776161
  777499
  778923
  779941
  784585
  784808
  786051
  787380
  787429
  787851
  789402
  789906
  791186
  791366
  791688
  793839
  795836
  795998
  796374
  797660
  797742
  800891
  810379
  811501
  812014
  812290
  813156
  820711
  826293
  826681
]
12.90 ms
(7.88%)
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
  418244
  518041
  493277
  565013
  712094
  432663
  433982
  522210
  562941
  560521
  630135
  432746
  562702
  681237
  632176
  761720
  742735
  427857
  424815
  486602
  496896
  725646
  473363
  695719
  826681
  826293
  490536
  463239
  499603
  526265
  518641
  542376
  541062
  664462
  677624
  697308
  700506
  705934
  665622
  680026
  708311
  720066
  697182
  710890
  574160
  586505
  616644
  594589
  629621
  636504
  644129
  591744
  599645
  595283
  597911
  639957
  776161
  777499
  787851
  789402
  791186
  791688
  795836
  797660
  797742
  778923
  779941
  789906
  810379
  812290
  727385
  727434
  736106
  742009
  771137
  773319
  784585
  786051
  791366
  793839
  795998
  796374
  811501
  812014
  813156
  731479
  756399
  756986
  768297
  761216
  769010
  746539
  748051
  757468
  770326
  771045
  764163
  711345
  721885
  784808
  787380
  787429
  800891
  425095
  461411
  476446
  443624
  445458
  579175
  820711
  498474
  549708
  565863
  649384
  678868
  700470
  591728
  605200
  631632
  644168
]
3.01 ms
(1.84%)
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
  418244
  424815
  425095
  427857
  432663
  432746
  433982
  443624
  445458
  461411
  463239
  473363
  476446
  486602
  490536
  493277
  496896
  498474
  499603
  518041
  518641
  522210
  526265
  541062
  542376
  549708
  560521
  562702
  562941
  565013
  565863
  574160
  579175
  586505
  591728
  591744
  594589
  595283
  597911
  599645
  605200
  616644
  629621
  630135
  631632
  632176
  636504
  639957
  644129
  644168
  649384
  664462
  665622
  677624
  678868
  680026
  681237
  695719
  697182
  697308
  700470
  700506
  705934
  708311
  710890
  711345
  712094
  720066
  721885
  725646
  727385
  727434
  731479
  736106
  742009
  742735
  746539
  748051
  756399
  756986
  757468
  761216
  761720
  764163
  768297
  769010
  770326
  771045
  771137
  773319
  776161
  777499
  778923
  779941
  784585
  784808
  786051
  787380
  787429
  787851
  789402
  789906
  791186
  791366
  791688
  793839
  795836
  795998
  796374
  797660
  797742
  800891
  810379
  811501
  812014
  812290
  813156
  820711
  826293
  826681
]
1.91 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties creampie"
]
1.75 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел creampie"
]
1.59 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел creampie"
]
1.44 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.