Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.71 ms
(80.09%)
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
  31758
  32030
  32553
  64934
  386085
  388024
  388410
  391371
  418713
  475636
  477529
  490592
  498630
  504625
  505366
  510894
  518008
  525729
  528544
  529831
  533839
  535281
  542529
  544029
  544882
  545155
  546229
  548343
  550530
  552532
  553217
  553218
  553220
  553222
  553226
  554675
  554679
  554689
  554698
  556057
  559418
  560500
  561792
  562584
  572722
  572723
  572728
  576569
  576584
  576610
  577010
  577033
  583651
  588022
  602287
  638471
  640878
  642966
  651797
  660315
  662867
  666389
  669257
  670399
  673045
  685305
  709676
  732936
  733899
  734203
  734841
  738248
  740255
  742080
  743193
  748297
  753607
  753711
  760569
  761249
  767746
  769096
  781268
  781775
  784065
  784620
  786909
  791433
  791854
  794457
  802221
  804684
  806806
  809577
  809679
  810397
  812336
  816131
  817363
  817566
  818205
  819687
  820161
  823443
  823744
  824073
  824573
  824655
  824850
  824853
  824885
  824926
  826357
  826564
  826979
  827225
  827438
  827529
  828319
]
20.77 ms
(14.01%)
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
  391371
  510894
  490592
  826562
  418713
  505366
  477529
  556057
  577010
  550530
  560500
  583651
  812336
  498630
  528544
  828319
  791433
  553222
  761249
  518008
  542529
  475636
  673045
  546229
  553217
  576569
  544882
  824926
  823744
  818205
  576610
  64934
  640878
  732936
  827529
  823443
  820161
  824655
  529831
  576584
  638471
  525729
  554679
  824073
  553218
  559418
  561792
  743193
  738248
  32553
  31758
  32030
  554675
  802221
  760569
  388410
  826357
  827225
  827438
  817566
  824573
  826979
  535281
  548343
  552532
  554698
  545155
  562584
  572723
  572728
  651797
  660315
  685305
  666389
  669257
  670399
  553220
  553226
  572722
  577033
  794457
  806806
  804684
  733899
  769096
  781268
  809679
  734203
  753711
  767746
  740255
  734841
  753607
  602287
  781775
  791854
  662867
  588022
  386085
  816131
  709676
  554689
  786909
  784065
  784620
  810397
  748297
  742080
  642966
  809577
  388024
  826564
  817363
  824885
  819687
  824853
  824850
  504625
  533839
  544029
]
2.15 ms
(1.45%)
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
  31758
  32030
  32553
  64934
  386085
  388024
  388410
  391371
  418713
  475636
  477529
  490592
  498630
  504625
  505366
  510894
  518008
  525729
  528544
  529831
  533839
  535281
  542529
  544029
  544882
  545155
  546229
  548343
  550530
  552532
  553217
  553218
  553220
  553222
  553226
  554675
  554679
  554689
  554698
  556057
  559418
  560500
  561792
  562584
  572722
  572723
  572728
  576569
  576584
  576610
  577010
  577033
  583651
  588022
  602287
  638471
  640878
  642966
  651797
  660315
  662867
  666389
  669257
  670399
  673045
  685305
  709676
  732936
  733899
  734203
  734841
  738248
  740255
  742080
  743193
  748297
  753607
  753711
  760569
  761249
  767746
  769096
  781268
  781775
  784065
  784620
  786909
  791433
  791854
  794457
  802221
  804684
  806806
  809577
  809679
  810397
  812336
  816131
  817363
  817566
  818205
  819687
  820161
  823443
  823744
  824073
  824573
  824655
  824850
  824853
  824885
  824926
  826357
  826564
  826979
  827225
  827438
  827529
  828319
]
2.10 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "clit masturbation"
]
1.62 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "clit мастурбац"
]
1.50 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "clit мастурбац"
]

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.