Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.70 ms
(79.51%)
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
  391754
  417979
  420654
  423057
  424214
  424726
  426093
  427306
  431476
  435409
  435629
  437415
  442680
  444593
  444851
  445493
  446311
  447262
  452463
  452476
  453731
  454950
  456516
  456531
  458886
  459585
  464732
  469691
  475195
  475551
  478510
  481406
  483050
  483324
  484541
  487214
  489176
  489315
  490071
  490511
  492133
  494015
  494039
  495043
  496562
  497057
  498149
  500048
  500441
  501960
  502242
  502938
  503322
  504885
  504955
  506986
  509454
  514206
  514740
  514744
  515344
  516354
  516969
  517733
  519184
  519954
  520065
  520808
  523430
  526385
  526911
  528306
  528363
  528699
  533207
  534791
  534815
  536652
  537346
  540738
  540748
  541582
  550099
  550485
  554420
  556241
  559629
  560289
  560946
  562789
  569253
  571046
  572211
  575178
  577685
  578288
  578323
  578356
  579881
  580103
  584705
  585550
  588684
  588745
  590623
  594590
  594846
  595339
  597864
  597907
  606774
  609078
  620330
  623732
  634588
  634688
  655456
  664632
  675449
  678973
]
22.27 ms
(13.97%)
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
  559629
  562789
  597907
  678973
  515344
  541582
  550485
  458886
  444593
  426093
  483050
  454950
  578288
  424726
  588684
  475195
  498149
  502938
  536652
  580103
  634688
  597864
  554420
  496562
  506986
  489315
  424214
  519184
  456531
  634588
  528306
  560289
  578356
  437415
  504885
  516969
  444851
  519954
  609078
  490071
  489176
  606774
  427306
  500048
  534815
  459585
  435409
  520808
  590623
  494015
  464732
  503322
  571046
  453731
  572211
  514740
  446311
  456516
  517733
  495043
  445493
  569253
  560946
  528363
  504955
  588745
  500441
  452476
  420654
  490511
  514744
  523430
  442680
  585550
  526911
  584705
  533207
  579881
  528699
  423057
  577685
  514206
  483324
  452463
  509454
  664632
  487214
  478510
  520065
  675449
  431476
  578323
  417979
  494039
  447262
  595339
  501960
  435629
  497057
  484541
  540738
  469691
  594590
  502242
  575178
  550099
  526385
  655456
  594846
  481406
  516354
  620330
  492133
  540748
  556241
  623732
  537346
  475551
  391754
  534791
]
2.71 ms
(1.70%)
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
  391754
  417979
  420654
  423057
  424214
  424726
  426093
  427306
  431476
  435409
  435629
  437415
  442680
  444593
  444851
  445493
  446311
  447262
  452463
  452476
  453731
  454950
  456516
  456531
  458886
  459585
  464732
  469691
  475195
  475551
  478510
  481406
  483050
  483324
  484541
  487214
  489176
  489315
  490071
  490511
  492133
  494015
  494039
  495043
  496562
  497057
  498149
  500048
  500441
  501960
  502242
  502938
  503322
  504885
  504955
  506986
  509454
  514206
  514740
  514744
  515344
  516354
  516969
  517733
  519184
  519954
  520065
  520808
  523430
  526385
  526911
  528306
  528363
  528699
  533207
  534791
  534815
  536652
  537346
  540738
  540748
  541582
  550099
  550485
  554420
  556241
  559629
  560289
  560946
  562789
  569253
  571046
  572211
  575178
  577685
  578288
  578323
  578356
  579881
  580103
  584705
  585550
  588684
  588745
  590623
  594590
  594846
  595339
  597864
  597907
  606774
  609078
  620330
  623732
  634588
  634688
  655456
  664632
  675449
  678973
]
2.16 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс девушки в маске"
]
1.98 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс девушк в маск"
]
1.81 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс девушк в маск"
]
1.74 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.