Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.99 ms
(88.74%)
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
  365546
  392676
  418382
  419081
  419312
  425095
  428598
  432380
  436631
  438455
  438490
  440659
  442842
  447217
  450588
  452754
  454106
  457913
  459403
  460593
  463827
  474968
  478145
  487987
  492967
  497853
  505097
  511435
  517641
  519206
  525937
  527842
  528844
  530368
  531561
  535072
  535698
  535984
  546331
  546903
  547565
  560399
  566915
  568181
  577865
  587337
  589931
  595071
  595208
  595991
  600616
  605699
  626217
  627010
  633207
  633537
  634215
  643249
  656635
  656891
  662886
  672343
  673954
  693761
  699444
  700693
  714079
  715436
  728926
  735004
  735382
  736207
  738353
  741702
  742653
  743790
  745915
  746235
  752669
  756776
  756841
  757690
  758777
  759356
  760454
  765767
  768233
  770522
  770817
  772035
  772053
  776032
  779720
  781262
  783849
  787466
  787516
  795211
  796327
  801003
  803543
  803635
  803877
  804114
  804159
  804527
  804557
  804568
  806075
  806422
  806834
  807112
  807310
  807362
  808091
  808971
  811700
  813215
  814492
]
12.47 ms
(6.29%)
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
  595991
  633537
  634215
  589931
  787466
  795211
  807362
  811700
  776032
  804557
  806075
  806422
  808091
  808971
  756841
  781262
  803543
  770817
  756776
  759356
  772053
  738353
  742653
  765767
  770522
  633207
  715436
  779720
  803877
  804114
  807112
  425095
  428598
  454106
  492967
  519206
  517641
  568181
  547565
  560399
  595208
  546331
  365546
  442842
  814492
  459403
  447217
  463827
  457913
  460593
  487987
  511435
  497853
  528844
  535072
  535984
  505097
  530368
  531561
  546903
  566915
  577865
  656635
  656891
  672343
  693761
  700693
  662886
  673954
  595071
  600616
  643249
  587337
  626217
  627010
  783849
  801003
  804527
  804568
  736207
  768233
  772035
  787516
  803635
  813215
  741702
  752669
  758777
  745915
  760454
  728926
  735004
  735382
  746235
  757690
  699444
  714079
  796327
  804159
  806834
  807310
  432380
  450588
  392676
  440659
  438455
  525937
  605699
  474968
  527842
  743790
  826077
  438490
  418382
  419081
  436631
  419312
  535698
  452754
  478145
]
2.92 ms
(1.47%)
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
  365546
  392676
  418382
  419081
  419312
  425095
  428598
  432380
  436631
  438455
  438490
  440659
  442842
  447217
  450588
  452754
  454106
  457913
  459403
  460593
  463827
  474968
  478145
  487987
  492967
  497853
  505097
  511435
  517641
  519206
  525937
  527842
  528844
  530368
  531561
  535072
  535698
  535984
  546331
  546903
  547565
  560399
  566915
  568181
  577865
  587337
  589931
  595071
  595208
  595991
  600616
  605699
  626217
  627010
  633207
  633537
  634215
  643249
  656635
  656891
  662886
  672343
  673954
  693761
  699444
  700693
  714079
  715436
  728926
  735004
  735382
  736207
  738353
  741702
  742653
  743790
  745915
  746235
  752669
  756776
  756841
  757690
  758777
  759356
  760454
  765767
  768233
  770522
  770817
  772035
  772053
  776032
  779720
  781262
  783849
  787466
  787516
  795211
  796327
  801003
  803543
  803635
  803877
  804114
  804159
  804527
  804557
  804568
  806075
  806422
  806834
  807112
  807310
  807362
  808091
  808971
  811700
  813215
  814492
]
2.11 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife riding"
]
1.72 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен riding"
]
1.64 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен riding"
]
1.47 ms
(0.74%)
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.