Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.51 ms
(87.82%)
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
  78976
  223551
  401537
  402551
  428111
  446537
  449596
  457586
  462061
  465252
  473823
  473854
  482420
  483495
  485470
  485854
  486005
  486562
  492567
  494215
  496709
  503989
  505298
  506428
  508257
  508775
  509836
  511018
  511319
  511328
  512876
  514057
  514250
  519979
  521249
  524036
  525806
  526589
  528562
  528603
  528760
  528761
  529122
  536745
  536756
  538175
  540711
  545154
  545522
  547575
  550809
  556868
  559290
  566310
  569796
  573367
  578801
  580302
  580347
  582163
  582743
  583288
  584428
  584438
  588129
  588715
  590977
  612846
  613358
  618268
  624425
  624462
  628192
  628582
  630411
  635719
  636705
  637512
  669270
  671462
  674330
  675607
  678793
  682850
  691046
  695353
  703827
  703828
  704122
  704981
  704998
  705008
  705009
  705024
  705025
  705031
  705112
  705647
  705830
  705853
  713197
  714850
  716726
  717387
  725533
  725551
  733210
  740153
  743548
  746345
  759909
  768656
  784069
  787262
  788125
  788437
  788755
  792731
  808304
  808309
]
14.04 ms
(7.11%)
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
  704998
  682850
  691046
  588129
  624462
  792731
  808304
  784069
  759909
  538175
  569796
  705853
  678793
  695353
  703828
  705112
  713197
  636705
  788755
  725533
  746345
  743548
  78976
  446537
  449596
  473823
  511018
  514057
  525806
  505298
  514250
  528603
  494215
  519979
  521249
  529122
  566310
  580347
  547575
  580302
  674330
  613358
  637512
  590977
  486562
  402551
  482420
  506428
  536745
  485854
  550809
  582163
  582743
  675607
  717387
  704981
  705008
  705009
  705024
  714850
  716726
  671462
  705025
  705647
  628192
  588715
  612846
  635719
  788125
  808309
  740153
  787262
  788437
  725551
  733210
  768656
  703827
  705031
  705830
  223551
  428111
  485470
  473854
  492567
  465252
  503989
  512876
  526589
  528761
  508775
  511319
  511328
  508257
  509836
  528562
  528760
  486005
  545522
  559290
  578801
  584438
  573367
  584428
  624425
  628582
  630411
  618268
  483495
  401537
  457586
  496709
  524036
  540711
  536756
  462061
  556868
  583288
  545154
  669270
  704122
]
3.40 ms
(1.72%)
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
  78976
  223551
  401537
  402551
  428111
  446537
  449596
  457586
  462061
  465252
  473823
  473854
  482420
  483495
  485470
  485854
  486005
  486562
  492567
  494215
  496709
  503989
  505298
  506428
  508257
  508775
  509836
  511018
  511319
  511328
  512876
  514057
  514250
  519979
  521249
  524036
  525806
  526589
  528562
  528603
  528760
  528761
  529122
  536745
  536756
  538175
  540711
  545154
  545522
  547575
  550809
  556868
  559290
  566310
  569796
  573367
  578801
  580302
  580347
  582163
  582743
  583288
  584428
  584438
  588129
  588715
  590977
  612846
  613358
  618268
  624425
  624462
  628192
  628582
  630411
  635719
  636705
  637512
  669270
  671462
  674330
  675607
  678793
  682850
  691046
  695353
  703827
  703828
  704122
  704981
  704998
  705008
  705009
  705024
  705025
  705031
  705112
  705647
  705830
  705853
  713197
  714850
  716726
  717387
  725533
  725551
  733210
  740153
  743548
  746345
  759909
  768656
  784069
  787262
  788125
  788437
  788755
  792731
  808304
  808309
]
1.86 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беремен"
]
1.80 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "беременность-"
]
1.53 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.72%)
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.