Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.41 ms
(88.25%)
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
  96269
  96484
  129748
  218768
  307458
  348409
  382766
  383375
  384847
  385970
  386072
  388635
  388690
  388789
  395446
  395706
  395824
  396744
  398909
  399094
  399926
  400138
  403021
  404257
  405174
  406457
  408692
  409184
  410090
  410093
  411047
  417179
  419702
  420094
  420392
  429713
  440624
  443810
  457782
  458331
  459999
  461210
  467749
  469913
  474488
  474955
  475933
  476426
  484131
  484385
  492261
  508405
  508967
  513780
  523689
  548788
  550416
  553153
  555689
  556016
  566038
  569134
  569549
  570698
  593894
  595786
  596990
  600173
  600225
  603166
  603178
  606587
  613864
  617217
  619247
  621976
  622131
  631954
  632698
  633807
  636322
  640700
  641965
  645999
  653177
  653594
  661970
  667757
  673143
  676777
  679770
  691995
  705160
  711998
  719001
  721298
  722822
  724507
  728386
  734506
  737394
  742199
  744649
  756775
  758969
  762221
  766129
  775928
  784859
  785096
  787344
  790034
  801894
  804462
  807514
  807635
  808999
  809647
  809931
  810827
]
12.96 ms
(6.79%)
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
  550416
  553153
  555689
  566038
  570698
  676777
  691995
  719001
  653177
  667757
  673143
  679770
  705160
  711998
  645999
  653594
  661970
  722822
  548788
  556016
  569134
  569549
  600173
  603178
  606587
  631954
  632698
  595786
  622131
  593894
  596990
  603166
  613864
  619247
  600225
  617217
  621976
  640700
  790034
  809931
  775928
  807514
  808999
  737394
  762221
  807635
  810827
  728386
  756775
  724507
  734506
  742199
  758969
  744649
  766129
  633807
  636322
  641965
  721298
  784859
  785096
  787344
  804462
  809647
  385970
  408692
  420392
  429713
  458331
  476426
  96269
  218768
  383375
  388690
  395706
  400138
  403021
  404257
  409184
  410093
  440624
  443810
  461210
  467749
  474488
  388635
  395446
  398909
  399094
  399926
  405174
  388789
  395824
  396744
  406457
  410090
  411047
  419702
  457782
  459999
  469913
  474955
  417179
  420094
  475933
  484385
  492261
  508967
  513780
  508405
  523689
  484131
  801894
  386072
  382766
  96484
  384847
  129748
  348409
  307458
]
2.73 ms
(1.43%)
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
  96269
  96484
  129748
  218768
  307458
  348409
  382766
  383375
  384847
  385970
  386072
  388635
  388690
  388789
  395446
  395706
  395824
  396744
  398909
  399094
  399926
  400138
  403021
  404257
  405174
  406457
  408692
  409184
  410090
  410093
  411047
  417179
  419702
  420094
  420392
  429713
  440624
  443810
  457782
  458331
  459999
  461210
  467749
  469913
  474488
  474955
  475933
  476426
  484131
  484385
  492261
  508405
  508967
  513780
  523689
  548788
  550416
  553153
  555689
  556016
  566038
  569134
  569549
  570698
  593894
  595786
  596990
  600173
  600225
  603166
  603178
  606587
  613864
  617217
  619247
  621976
  622131
  631954
  632698
  633807
  636322
  640700
  641965
  645999
  653177
  653594
  661970
  667757
  673143
  676777
  679770
  691995
  705160
  711998
  719001
  721298
  722822
  724507
  728386
  734506
  737394
  742199
  744649
  756775
  758969
  762221
  766129
  775928
  784859
  785096
  787344
  790034
  801894
  804462
  807514
  807635
  808999
  809647
  809931
  810827
]
2.16 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно секс ролики"
]
1.63 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн секс ролик"
]
1.61 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.70%)
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.