Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.86 ms
(83.43%)
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
  390294
  419453
  431750
  456856
  459934
  461668
  467948
  475662
  477591
  478638
  480891
  490665
  492537
  493413
  497332
  498544
  498623
  499079
  501377
  503291
  505579
  507521
  509258
  509530
  510855
  511058
  512466
  513966
  519117
  521713
  523348
  523483
  525192
  525343
  526687
  527133
  527382
  528396
  529366
  533111
  537531
  538484
  540068
  542744
  542792
  543278
  543786
  545835
  545905
  550489
  550688
  551872
  552350
  553494
  555019
  555938
  556677
  559222
  563116
  564112
  565808
  567158
  567505
  567528
  567641
  567720
  569969
  571137
  572702
  574763
  576991
  577005
  578593
  580973
  582000
  585097
  586326
  588277
  588679
  590356
  591327
  592580
  592713
  592921
  592973
  593069
  593497
  596057
  596147
  596517
  598839
  599621
  600341
  600651
  600966
  601672
  601983
  604783
  605094
  607142
  607558
  609531
  612828
  615006
  617075
  617575
  618754
  619705
  619816
  622927
  626436
  630457
  631238
  635694
  654129
  668464
  675637
  684343
  689120
]
16.41 ms
(10.54%)
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
  419453
  499079
  543278
  545835
  654129
  600966
  630457
  510855
  585097
  512466
  567528
  592713
  390294
  509258
  577005
  545905
  615006
  492537
  493413
  555019
  675637
  477591
  475662
  519117
  572702
  596057
  456856
  523483
  533111
  617075
  542744
  599621
  480891
  526687
  505579
  509530
  525192
  565808
  582000
  567641
  569969
  689120
  563116
  588679
  596517
  617575
  525343
  555938
  618754
  497332
  538484
  567158
  556677
  588277
  622927
  604783
  431750
  552350
  564112
  543786
  590356
  631238
  596147
  521713
  490665
  542792
  586326
  567505
  668464
  553494
  527382
  511058
  607558
  774682
  507521
  626436
  498544
  567720
  576991
  684343
  467948
  523348
  537531
  513966
  550688
  574763
  578593
  601672
  619705
  600651
  635694
  503291
  600341
  619816
  501377
  540068
  550489
  580973
  607142
  593497
  601983
  612828
  529366
  478638
  592580
  559222
  551872
  592921
  591327
  605094
  459934
  593069
  598839
  528396
  498623
  571137
  592973
  461668
  609531
  527133
]
2.81 ms
(1.81%)
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
  390294
  419453
  431750
  456856
  459934
  461668
  467948
  475662
  477591
  478638
  480891
  490665
  492537
  493413
  497332
  498544
  498623
  499079
  501377
  503291
  505579
  507521
  509258
  509530
  510855
  511058
  512466
  513966
  519117
  521713
  523348
  523483
  525192
  525343
  526687
  527133
  527382
  528396
  529366
  533111
  537531
  538484
  540068
  542744
  542792
  543278
  543786
  545835
  545905
  550489
  550688
  551872
  552350
  553494
  555019
  555938
  556677
  559222
  563116
  564112
  565808
  567158
  567505
  567528
  567641
  567720
  569969
  571137
  572702
  574763
  576991
  577005
  578593
  580973
  582000
  585097
  586326
  588277
  588679
  590356
  591327
  592580
  592713
  592921
  592973
  593069
  593497
  596057
  596147
  596517
  598839
  599621
  600341
  600651
  600966
  601672
  601983
  604783
  605094
  607142
  607558
  609531
  612828
  615006
  617075
  617575
  618754
  619705
  619816
  622927
  626436
  630457
  631238
  635694
  654129
  668464
  675637
  684343
  689120
]
1.80 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщины в носках"
]
1.67 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин в носк"
]
1.63 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.93%)
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.