Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.18 ms
(83.73%)
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
  72589
  202134
  316153
  388183
  389516
  396056
  405815
  408085
  413979
  415224
  415926
  416162
  416699
  421119
  424195
  429601
  430814
  433592
  433748
  438533
  439023
  441073
  441228
  442679
  444968
  445540
  445704
  445774
  445796
  446604
  447562
  449531
  450254
  450297
  452052
  452221
  453043
  453521
  454443
  456048
  457141
  458331
  461029
  462970
  464118
  467049
  468236
  468720
  469826
  471347
  472214
  475859
  476309
  477923
  478015
  480414
  485455
  488337
  489946
  492039
  497681
  497752
  499476
  501568
  505800
  506376
  506669
  506961
  511633
  511811
  512923
  517717
  518136
  518400
  518760
  519350
  524380
  524795
  525208
  526604
  536728
  538675
  543418
  545207
  546607
  551419
  555859
  561426
  564619
  564626
  568381
  575730
  594500
  597503
  598856
  613850
  620044
  622695
  628087
  677030
  708472
  710423
  719120
  723794
  725586
  736371
  755396
  758938
  774957
  775192
  795509
  800389
  802786
  812522
  812989
  816944
  817153
  818456
  821629
  825204
]
14.52 ms
(9.48%)
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
  710423
  802786
  812522
  774957
  723794
  800389
  758938
  755396
  72589
  202134
  413979
  415926
  416699
  438533
  444968
  430814
  480414
  450254
  450297
  453521
  468720
  511811
  517717
  501568
  512923
  475859
  545207
  561426
  575730
  543418
  546607
  568381
  555859
  613850
  594500
  812989
  389516
  424195
  476309
  433748
  446604
  421119
  439023
  462970
  449531
  477923
  526604
  485455
  525208
  506376
  519350
  524795
  821629
  816944
  817153
  825204
  518136
  677030
  708472
  622695
  795509
  725586
  719120
  818456
  458331
  628087
  408085
  452052
  405815
  441228
  441073
  429601
  445774
  445796
  456048
  488337
  445704
  469826
  453043
  461029
  467049
  468236
  489946
  506961
  497681
  499476
  518400
  464118
  564619
  551419
  564626
  598856
  775192
  388183
  478015
  472214
  457141
  518760
  538675
  492039
  505800
  524380
  497752
  511633
  620044
  597503
  506669
  442679
  433592
  445540
  415224
  447562
  736371
  452221
  454443
  471347
  396056
  536728
  316153
  416162
]
3.26 ms
(2.13%)
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
  72589
  202134
  316153
  388183
  389516
  396056
  405815
  408085
  413979
  415224
  415926
  416162
  416699
  421119
  424195
  429601
  430814
  433592
  433748
  438533
  439023
  441073
  441228
  442679
  444968
  445540
  445704
  445774
  445796
  446604
  447562
  449531
  450254
  450297
  452052
  452221
  453043
  453521
  454443
  456048
  457141
  458331
  461029
  462970
  464118
  467049
  468236
  468720
  469826
  471347
  472214
  475859
  476309
  477923
  478015
  480414
  485455
  488337
  489946
  492039
  497681
  497752
  499476
  501568
  505800
  506376
  506669
  506961
  511633
  511811
  512923
  517717
  518136
  518400
  518760
  519350
  524380
  524795
  525208
  526604
  536728
  538675
  543418
  545207
  546607
  551419
  555859
  561426
  564619
  564626
  568381
  575730
  594500
  597503
  598856
  613850
  620044
  622695
  628087
  677030
  708472
  710423
  719120
  723794
  725586
  736371
  755396
  758938
  774957
  775192
  795509
  800389
  802786
  812522
  812989
  816944
  817153
  818456
  821629
  825204
]
1.93 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "oil sex"
]
1.83 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "масл секс"
]
1.75 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.