Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.46 ms
(83.92%)
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
  351473
  389832
  403418
  407418
  417466
  418034
  418720
  428229
  431760
  432461
  450069
  452588
  452590
  453854
  455619
  456188
  461105
  462245
  467859
  471041
  479393
  483855
  485069
  487860
  493408
  493914
  494514
  495583
  497853
  502852
  503471
  503472
  505530
  507154
  507862
  508272
  508283
  510725
  511341
  514005
  515596
  515615
  515618
  515629
  515631
  517143
  517559
  522512
  522666
  522961
  523903
  525619
  545497
  545673
  547998
  550505
  552755
  552806
  554529
  558909
  564275
  568233
  568635
  568699
  570755
  583148
  585473
  586579
  588322
  588325
  588347
  590148
  591823
  599588
  600855
  600878
  600888
  607870
  618376
  621464
  625282
  628514
  642934
  643672
  664522
  669639
  672190
  689879
  695353
  695375
  695424
  697763
  698618
  718717
  727317
  730738
  730743
  733987
  734860
  735862
  741062
  742026
  746066
  752920
  753636
  760879
  760886
  762521
  766480
  768963
  781049
  796489
  809052
  811174
  811721
  814706
  820195
  825925
  828660
]
22.91 ms
(11.21%)
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
  417466
  471041
  735862
  505530
  508272
  525619
  507154
  545497
  545673
  564275
  568699
  591823
  585473
  642934
  450069
  455619
  515631
  522961
  503471
  493408
  554529
  600878
  814706
  588325
  752920
  403418
  483855
  515615
  828660
  643672
  811174
  796489
  741062
  628514
  618376
  494514
  461105
  452588
  508283
  511341
  517143
  522666
  550505
  558909
  664522
  407418
  467859
  418720
  428229
  515629
  493914
  514005
  568233
  510725
  824264
  552755
  698618
  695353
  547998
  730738
  753636
  746066
  768963
  389832
  432461
  452590
  453854
  495583
  497853
  552806
  621464
  625282
  418034
  503472
  522512
  825925
  507862
  672190
  718717
  669639
  695424
  600855
  586579
  809052
  781049
  730743
  760886
  766480
  727317
  733987
  734860
  760879
  762521
  811721
  607870
  583148
  517559
  523903
  568635
  351473
  431760
  515618
  487860
  570755
  588347
  588322
  599588
  590148
  600888
  742026
  456188
  462245
  479393
  502852
  515596
  820195
  485069
  695375
  697763
  689879
]
2.76 ms
(1.35%)
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
  351473
  389832
  403418
  407418
  417466
  418034
  418720
  428229
  431760
  432461
  450069
  452588
  452590
  453854
  455619
  456188
  461105
  462245
  467859
  471041
  479393
  483855
  485069
  487860
  493408
  493914
  494514
  495583
  497853
  502852
  503471
  503472
  505530
  507154
  507862
  508272
  508283
  510725
  511341
  514005
  515596
  515615
  515618
  515629
  515631
  517143
  517559
  522512
  522666
  522961
  523903
  525619
  545497
  545673
  547998
  550505
  552755
  552806
  554529
  558909
  564275
  568233
  568635
  568699
  570755
  583148
  585473
  586579
  588322
  588325
  588347
  590148
  591823
  599588
  600855
  600878
  600888
  607870
  618376
  621464
  625282
  628514
  642934
  643672
  664522
  669639
  672190
  689879
  695353
  695375
  695424
  697763
  698618
  718717
  727317
  730738
  730743
  733987
  734860
  735862
  741062
  742026
  746066
  752920
  753636
  760879
  760886
  762521
  766480
  768963
  781049
  796489
  809052
  811174
  811721
  814706
  820195
  825925
  828660
]
2.00 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш вебкамер"
]
1.86 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office webcam"
]
1.57 ms
(0.77%)
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.