Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.23 ms
(59.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "very hair"
]
117.47 ms
(33.29%)
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
  411909
  416367
  430397
  434014
  446790
  449093
  450096
  453032
  454452
  454852
  454926
  457886
  459061
  462109
  465151
  470882
  477517
  480732
  485744
  487436
  490598
  504751
  505433
  506765
  508907
  509945
  510459
  518287
  520437
  523952
  525427
  525806
  527874
  529426
  535251
  538196
  543151
  544117
  547865
  548721
  549805
  554514
  555508
  558457
  558874
  559216
  561416
  562326
  564724
  566307
  567091
  572342
  572765
  573098
  574502
  574681
  576020
  578734
  579990
  580239
  581465
  584406
  585097
  585381
  586648
  591810
  592355
  592562
  593764
  597258
  597274
  598277
  598914
  600806
  601898
  602967
  604941
  607892
  612675
  614588
  615688
  617375
  617704
  622399
  623312
  624391
  625460
  630777
  643488
  653461
  654394
  665929
  668701
  672806
  673314
  675858
  677362
  678929
  679087
  679102
  689436
  692293
  706939
  723131
  726478
  726510
  732899
  738641
  747976
  750602
  750776
  787393
  790742
  795406
  797078
  799049
  805041
  809023
  811994
  817449
]
16.66 ms
(4.72%)
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
  525427
  506765
  509945
  523952
  487436
  527874
  538196
  434014
  416367
  411909
  430397
  585097
  817449
  449093
  453032
  485744
  454452
  459061
  470882
  480732
  446790
  450096
  454852
  454926
  457886
  477517
  490598
  504751
  505433
  508907
  525806
  518287
  520437
  535251
  510459
  529426
  462109
  465151
  559216
  572765
  574681
  578734
  581465
  543151
  547865
  554514
  558457
  564724
  567091
  576020
  584406
  544117
  548721
  555508
  558874
  561416
  562326
  579990
  580239
  654394
  673314
  679087
  689436
  723131
  653461
  665929
  679102
  706939
  668701
  672806
  675858
  677362
  678929
  692293
  549805
  566307
  572342
  573098
  574502
  600806
  614588
  617375
  622399
  625460
  586648
  597258
  623312
  643488
  591810
  592355
  598914
  601898
  602967
  604941
  607892
  615688
  630777
  585381
  592562
  593764
  597274
  598277
  612675
  617704
  624391
  799049
  809023
  811994
  787393
  790742
  795406
  797078
  805041
  726510
  750776
  732899
  747976
  726478
  738641
  750602
]
2.58 ms
(0.73%)
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
  411909
  416367
  430397
  434014
  446790
  449093
  450096
  453032
  454452
  454852
  454926
  457886
  459061
  462109
  465151
  470882
  477517
  480732
  485744
  487436
  490598
  504751
  505433
  506765
  508907
  509945
  510459
  518287
  520437
  523952
  525427
  525806
  527874
  529426
  535251
  538196
  543151
  544117
  547865
  548721
  549805
  554514
  555508
  558457
  558874
  559216
  561416
  562326
  564724
  566307
  567091
  572342
  572765
  573098
  574502
  574681
  576020
  578734
  579990
  580239
  581465
  584406
  585097
  585381
  586648
  591810
  592355
  592562
  593764
  597258
  597274
  598277
  598914
  600806
  601898
  602967
  604941
  607892
  612675
  614588
  615688
  617375
  617704
  622399
  623312
  624391
  625460
  630777
  643488
  653461
  654394
  665929
  668701
  672806
  673314
  675858
  677362
  678929
  679087
  679102
  689436
  692293
  706939
  723131
  726478
  726510
  732899
  738641
  747976
  750602
  750776
  787393
  790742
  795406
  797078
  799049
  805041
  809023
  811994
  817449
]
1.82 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "very hair"
]
1.46 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "very hair"
]

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.