Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
240.86 ms
(49.95%)
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
  392077
  393222
  395622
  397102
  398701
  415836
  416523
  416689
  419325
  423338
  427159
  432752
  438613
  439844
  441611
  447955
  456201
  456627
  456706
  459360
  464648
  470742
  471515
  477441
  486814
  492313
  495527
  495929
  496076
  498822
  501148
  503953
  504297
  507395
  511803
  516615
  517691
  519472
  521971
  523138
  524877
  526024
  527808
  529488
  537630
  537774
  541902
  543790
  543960
  546680
  547191
  552766
  554017
  554646
  555819
  557983
  559009
  565844
  565914
  567429
  567863
  571259
  572004
  592538
  600455
  614330
  617259
  630639
  639889
  652125
  652622
  660787
  661652
  666415
  683011
  693875
  694131
  701344
  701970
  704984
  712955
  716311
  731404
  736012
  739557
  747501
  750653
  752547
  756149
  756690
  760083
  765920
  766852
  771903
  777489
  778303
  779561
  780363
  783955
  784500
  787536
  787933
  790036
  790349
  791181
  791475
  796994
  798711
  802985
  803991
  807068
  810816
  813314
  817378
  818241
  823352
  823367
  824764
  825795
  826713
]
230.10 ms
(47.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
  504297
  503953
  527808
  392077
  818241
  817378
  517691
  507395
  554017
  701344
  660787
  780363
  766852
  731404
  747501
  783955
  438613
  416689
  495929
  419325
  441611
  486814
  529488
  547191
  652622
  791181
  423338
  393222
  565844
  694131
  807068
  778303
  760083
  756149
  796994
  398701
  543790
  543960
  557983
  630639
  739557
  523138
  572004
  447955
  477441
  470742
  519472
  516615
  521971
  498822
  416523
  825795
  541902
  552766
  683011
  701970
  693875
  704984
  592538
  600455
  752547
  787536
  427159
  397102
  826713
  823367
  824764
  712955
  614330
  802985
  771903
  617259
  777489
  779561
  813314
  459360
  471515
  495527
  567429
  546680
  554646
  790036
  395622
  456627
  511803
  823352
  492313
  639889
  790349
  784500
  810816
  716311
  415836
  432752
  456201
  501148
  524877
  555819
  567863
  652125
  559009
  565914
  456706
  439844
  526024
  464648
  496076
  537630
  537774
  571259
  661652
  666415
  791475
  798711
  765920
  756690
  736012
  750653
  787933
  803991
]
4.01 ms
(0.83%)
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
  392077
  393222
  395622
  397102
  398701
  415836
  416523
  416689
  419325
  423338
  427159
  432752
  438613
  439844
  441611
  447955
  456201
  456627
  456706
  459360
  464648
  470742
  471515
  477441
  486814
  492313
  495527
  495929
  496076
  498822
  501148
  503953
  504297
  507395
  511803
  516615
  517691
  519472
  521971
  523138
  524877
  526024
  527808
  529488
  537630
  537774
  541902
  543790
  543960
  546680
  547191
  552766
  554017
  554646
  555819
  557983
  559009
  565844
  565914
  567429
  567863
  571259
  572004
  592538
  600455
  614330
  617259
  630639
  639889
  652125
  652622
  660787
  661652
  666415
  683011
  693875
  694131
  701344
  701970
  704984
  712955
  716311
  731404
  736012
  739557
  747501
  750653
  752547
  756149
  756690
  760083
  765920
  766852
  771903
  777489
  778303
  779561
  780363
  783955
  784500
  787536
  787933
  790036
  790349
  791181
  791475
  796994
  798711
  802985
  803991
  807068
  810816
  813314
  817378
  818241
  823352
  823367
  824764
  825795
  826713
]
2.44 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер young девушк"
]
1.73 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam young girls"
]
1.59 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер young девушк"
]
1.48 ms
(0.31%)
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.