Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.09 ms
(84.62%)
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
  190876
  358603
  392439
  395729
  401303
  411220
  411721
  425195
  440694
  443187
  444911
  445846
  447806
  455698
  459922
  462181
  463394
  464278
  467216
  469990
  481390
  481997
  489924
  504038
  512223
  525751
  525988
  531319
  537577
  538767
  539342
  539570
  539773
  542499
  542876
  549140
  550779
  559653
  562021
  574255
  579945
  584054
  598368
  599628
  619261
  619601
  621634
  622557
  628507
  629603
  641322
  645543
  646712
  652315
  653117
  666376
  671251
  675230
  677738
  681422
  685041
  691592
  691723
  698921
  701817
  702862
  705238
  707401
  707419
  708005
  710143
  710191
  712791
  714597
  714605
  718620
  720543
  721502
  722162
  724482
  726764
  729053
  730190
  730562
  730628
  730839
  732202
  734439
  735783
  737252
  740664
  740703
  742277
  742284
  743019
  746885
  746934
  747247
  749475
  755458
  760265
  770394
  786639
  788629
  795059
  815874
  816621
  816980
  818464
  820365
  820472
  820491
  820591
  821283
  821744
  825259
  825959
  826203
  827102
  827484
]
12.42 ms
(8.82%)
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
  531319
  549140
  574255
  579945
  559653
  562021
  550779
  685041
  707401
  707419
  710143
  718620
  691592
  701817
  708005
  671251
  681422
  705238
  720543
  599628
  621634
  619601
  622557
  726764
  737252
  740703
  742277
  746934
  770394
  729053
  730562
  742284
  724482
  392439
  358603
  411220
  440694
  444911
  443187
  827484
  445846
  447806
  464278
  489924
  455698
  459922
  481390
  525988
  539342
  538767
  469990
  542876
  710191
  411721
  462181
  463394
  467216
  481997
  190876
  395729
  401303
  425195
  504038
  525751
  512223
  816980
  820472
  827102
  821283
  815874
  818464
  539570
  677738
  702862
  721502
  675230
  628507
  641322
  795059
  735783
  730628
  730839
  734439
  788629
  816621
  820365
  820591
  825959
  821744
  826203
  820491
  825259
  539773
  537577
  542499
  584054
  646712
  698921
  645543
  652315
  653117
  666376
  691723
  714605
  712791
  714597
  722162
  598368
  619261
  629603
  730190
  732202
  749475
  786639
  746885
  743019
  747247
  760265
  740664
  755458
]
2.35 ms
(1.67%)
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
  190876
  358603
  392439
  395729
  401303
  411220
  411721
  425195
  440694
  443187
  444911
  445846
  447806
  455698
  459922
  462181
  463394
  464278
  467216
  469990
  481390
  481997
  489924
  504038
  512223
  525751
  525988
  531319
  537577
  538767
  539342
  539570
  539773
  542499
  542876
  549140
  550779
  559653
  562021
  574255
  579945
  584054
  598368
  599628
  619261
  619601
  621634
  622557
  628507
  629603
  641322
  645543
  646712
  652315
  653117
  666376
  671251
  675230
  677738
  681422
  685041
  691592
  691723
  698921
  701817
  702862
  705238
  707401
  707419
  708005
  710143
  710191
  712791
  714597
  714605
  718620
  720543
  721502
  722162
  724482
  726764
  729053
  730190
  730562
  730628
  730839
  732202
  734439
  735783
  737252
  740664
  740703
  742277
  742284
  743019
  746885
  746934
  747247
  749475
  755458
  760265
  770394
  786639
  788629
  795059
  815874
  816621
  816980
  818464
  820365
  820472
  820491
  820591
  821283
  821744
  825259
  825959
  826203
  827102
  827484
]
2.04 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy cock"
]
1.82 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая cock"
]
1.37 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая cock"
]

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.