Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.84 ms
(83.60%)
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
  417212
  421071
  427346
  430404
  434601
  446631
  463780
  466404
  470613
  472388
  474509
  481881
  481904
  481910
  482507
  484017
  489328
  491021
  493180
  495038
  496118
  502304
  502512
  508525
  508673
  510251
  517923
  520697
  521135
  522911
  522914
  522917
  524969
  534219
  536695
  536712
  539351
  541587
  541588
  541630
  541631
  541639
  541650
  541664
  541673
  541740
  541759
  541774
  541821
  541822
  541864
  541884
  542199
  542954
  544800
  550579
  551069
  556834
  557558
  569132
  571434
  574384
  575661
  576690
  576713
  583913
  587901
  600003
  600022
  601046
  601324
  604517
  605521
  606202
  607355
  607594
  615909
  616411
  619407
  623641
  626347
  628332
  632595
  632646
  632680
  632694
  634178
  634212
  635243
  636033
  637092
  639722
  639790
  641644
  642746
  643061
  651607
  652539
  656303
  665776
  666850
  676428
  686843
  699397
  711283
  770225
  784152
  788262
  803455
  807191
  815383
]
20.80 ms
(11.09%)
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
  784152
  607355
  632694
  788262
  510251
  508525
  502304
  522917
  430404
  489328
  541630
  628332
  521135
  434601
  463780
  481904
  522914
  474509
  541884
  556834
  557558
  569132
  575661
  576690
  576713
  550579
  571434
  651607
  665776
  656303
  606202
  623641
  601046
  616411
  634212
  639790
  641644
  770225
  632646
  421071
  472388
  524969
  574384
  605521
  466404
  541650
  496118
  493180
  446631
  481910
  534219
  583913
  541759
  551069
  699397
  711283
  615909
  632680
  643061
  600003
  637092
  600022
  807191
  427346
  417212
  495038
  491021
  652539
  539351
  536695
  481881
  520697
  502512
  607594
  470613
  482507
  517923
  536712
  541821
  544800
  626347
  634178
  632595
  636033
  803455
  604517
  541822
  541587
  542954
  541673
  541664
  541740
  541774
  676428
  686843
  635243
  587901
  815383
  541639
  541588
  666850
  601324
  508673
  541631
  484017
  542199
  541864
  619407
  639722
  522911
  642746
]
2.60 ms
(1.38%)
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
  417212
  421071
  427346
  430404
  434601
  446631
  463780
  466404
  470613
  472388
  474509
  481881
  481904
  481910
  482507
  484017
  489328
  491021
  493180
  495038
  496118
  502304
  502512
  508525
  508673
  510251
  517923
  520697
  521135
  522911
  522914
  522917
  524969
  534219
  536695
  536712
  539351
  541587
  541588
  541630
  541631
  541639
  541650
  541664
  541673
  541740
  541759
  541774
  541821
  541822
  541864
  541884
  542199
  542954
  544800
  550579
  551069
  556834
  557558
  569132
  571434
  574384
  575661
  576690
  576713
  583913
  587901
  600003
  600022
  601046
  601324
  604517
  605521
  606202
  607355
  607594
  615909
  616411
  619407
  623641
  626347
  628332
  632595
  632646
  632680
  632694
  634178
  634212
  635243
  636033
  637092
  639722
  639790
  641644
  642746
  643061
  651607
  652539
  656303
  665776
  666850
  676428
  686843
  699397
  711283
  770225
  784152
  788262
  803455
  807191
  815383
]
2.10 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature mom compilation"
]
1.88 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature mom подборк"
]
1.73 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature mom подборк"
]
1.65 ms
(0.88%)
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.