Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.73 ms
(82.07%)
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
  88591
  89346
  151179
  154133
  154240
  154257
  154972
  248347
  290366
  340567
  352189
  357499
  388962
  389144
  391915
  402619
  410694
  413341
  413673
  415300
  415879
  416531
  416631
  416695
  428729
  431439
  436639
  439071
  446949
  448604
  448854
  452810
  453221
  454172
  460765
  464951
  468943
  470473
  471132
  473450
  476163
  477761
  483738
  486772
  498318
  511857
  518187
  521540
  529713
  529714
  530368
  530679
  531839
  532530
  535438
  540945
  545439
  547480
  547489
  554100
  561036
  561346
  564289
  580069
  589185
  590370
  597190
  597534
  602251
  625227
  628104
  628105
  628106
  634071
  648869
  657527
  657562
  658774
  658816
  658850
  660043
  660382
  660385
  660411
  660419
  661455
  662026
  668660
  669035
  669057
  669071
  670372
  671008
  671018
  671045
  672939
  683297
  686106
  686130
  691286
  697614
  705362
  713142
  745092
  745111
  752592
  752630
  752632
  752660
  752669
  752767
  761430
  770324
  770386
  792092
  792726
  799693
  803135
  806938
]
16.09 ms
(10.34%)
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
  413673
  431439
  671008
  580069
  589185
  628105
  806938
  628106
  248347
  352189
  389144
  597534
  446949
  452810
  436639
  415300
  473450
  535438
  464951
  357499
  448604
  416531
  151179
  89346
  154257
  531839
  154133
  154972
  88591
  410694
  416695
  483738
  416631
  792092
  561346
  340567
  402619
  290366
  413341
  439071
  453221
  454172
  471132
  518187
  532530
  476163
  564310
  547489
  547480
  561036
  668660
  669071
  672939
  686130
  648869
  660385
  660419
  670372
  713142
  660382
  660411
  669035
  669057
  671018
  671045
  683297
  686106
  545439
  634071
  597190
  625227
  799693
  752632
  752660
  752767
  602251
  468943
  470473
  498318
  154240
  529713
  529714
  530368
  540945
  658816
  662026
  564289
  590370
  628104
  745092
  792726
  745111
  752669
  752630
  770386
  415879
  460765
  477761
  448854
  511857
  391915
  554100
  803135
  761430
  752592
  770324
  428729
  388962
  486772
  521540
  530679
  657527
  658850
  658774
  661455
  691286
  697614
  657562
  660043
  705362
]
4.15 ms
(2.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
  88591
  89346
  151179
  154133
  154240
  154257
  154972
  248347
  290366
  340567
  352189
  357499
  388962
  389144
  391915
  402619
  410694
  413341
  413673
  415300
  415879
  416531
  416631
  416695
  428729
  431439
  436639
  439071
  446949
  448604
  448854
  452810
  453221
  454172
  460765
  464951
  468943
  470473
  471132
  473450
  476163
  477761
  483738
  486772
  498318
  511857
  518187
  521540
  529713
  529714
  530368
  530679
  531839
  532530
  535438
  540945
  545439
  547480
  547489
  554100
  561036
  561346
  564289
  580069
  589185
  590370
  597190
  597534
  602251
  625227
  628104
  628105
  628106
  634071
  648869
  657527
  657562
  658774
  658816
  658850
  660043
  660382
  660385
  660411
  660419
  661455
  662026
  668660
  669035
  669057
  669071
  670372
  671008
  671018
  671045
  672939
  683297
  686106
  686130
  691286
  697614
  705362
  713142
  745092
  745111
  752592
  752630
  752632
  752660
  752669
  752767
  761430
  770324
  770386
  792092
  792726
  799693
  803135
  806938
]
2.10 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал дилд мастурбац"
]
1.99 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дилд мастурбац"
]
1.80 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal dildo masturbation"
]
1.77 ms
(1.14%)
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.