Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.80 ms
(80.09%)
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
  145660
  381933
  393091
  399639
  399652
  400195
  400243
  407809
  409784
  410781
  413296
  415917
  418098
  425968
  425993
  426005
  428322
  428354
  428860
  431481
  433592
  435613
  443335
  443581
  443622
  443639
  444101
  445712
  445908
  446152
  447951
  450184
  450310
  451523
  460448
  461606
  463739
  464627
  467712
  468120
  471653
  476729
  479863
  482602
  494401
  495673
  496810
  497891
  500226
  503418
  505631
  506141
  507290
  508141
  508947
  509309
  510206
  512376
  513102
  516503
  518089
  518176
  520226
  523082
  528550
  531542
  531900
  537349
  537508
  538544
  539645
  546842
  549130
  549739
  558804
  560229
  561558
  562509
  566032
  567386
  568928
  574369
  579284
  581438
  583614
  584403
  596459
  599173
  601113
  601316
  601825
  607662
  608667
  615004
  619232
  620569
  636449
  652644
  660739
  686207
  690828
  694056
  719014
  720289
  724484
  732347
  733480
  756398
  771673
  772248
  779647
  779840
  784417
  800030
  800556
  807958
  808461
  809271
  811475
  812757
]
25.03 ms
(14.55%)
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
  546842
  574369
  443581
  425993
  567386
  450310
  619232
  620569
  636449
  733480
  784417
  538544
  450184
  445712
  561558
  581438
  601825
  800030
  494401
  507290
  690828
  464627
  537508
  812757
  418098
  505631
  531900
  596459
  428354
  399639
  508947
  720289
  531542
  482602
  400243
  433592
  500226
  426005
  471653
  615004
  694056
  756398
  495673
  508141
  537349
  724484
  566032
  516503
  393091
  660739
  807958
  447951
  399652
  425968
  479863
  811475
  445908
  518089
  435613
  601316
  800556
  520226
  599173
  779647
  460448
  381933
  539645
  562509
  719014
  579284
  771673
  808461
  468120
  513102
  400195
  568928
  446152
  558804
  584403
  652644
  608667
  772248
  443639
  451523
  444101
  523082
  732347
  512376
  443335
  467712
  583614
  607662
  428860
  410781
  809271
  518176
  510206
  428322
  463739
  461606
  413296
  496810
  431481
  506141
  549130
  549739
  509309
  497891
  560229
  779840
  145660
  407809
  503418
  476729
  601113
  409784
  528550
  686207
  443622
  415917
]
2.28 ms
(1.33%)
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
  145660
  381933
  393091
  399639
  399652
  400195
  400243
  407809
  409784
  410781
  413296
  415917
  418098
  425968
  425993
  426005
  428322
  428354
  428860
  431481
  433592
  435613
  443335
  443581
  443622
  443639
  444101
  445712
  445908
  446152
  447951
  450184
  450310
  451523
  460448
  461606
  463739
  464627
  467712
  468120
  471653
  476729
  479863
  482602
  494401
  495673
  496810
  497891
  500226
  503418
  505631
  506141
  507290
  508141
  508947
  509309
  510206
  512376
  513102
  516503
  518089
  518176
  520226
  523082
  528550
  531542
  531900
  537349
  537508
  538544
  539645
  546842
  549130
  549739
  558804
  560229
  561558
  562509
  566032
  567386
  568928
  574369
  579284
  581438
  583614
  584403
  596459
  599173
  601113
  601316
  601825
  607662
  608667
  615004
  619232
  620569
  636449
  652644
  660739
  686207
  690828
  694056
  719014
  720289
  724484
  732347
  733480
  756398
  771673
  772248
  779647
  779840
  784417
  800030
  800556
  807958
  808461
  809271
  811475
  812757
]
1.85 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex big tit"
]
1.84 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс большие tit"
]
1.78 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс большие tit"
]

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.