Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
418.79 ms
(74.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск milf домашн любительск"
]
118.81 ms
(21.04%)
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
  365875
  365907
  391980
  392095
  412157
  424129
  424197
  426870
  439584
  443958
  444223
  444670
  445425
  449981
  455357
  455428
  456892
  464954
  466338
  467781
  470620
  470705
  471108
  474242
  483961
  484391
  486209
  487235
  489117
  496058
  500038
  504152
  504216
  511083
  516668
  518615
  519585
  522485
  537024
  539341
  541767
  543644
  544459
  544952
  546580
  548049
  550234
  554237
  558315
  560238
  563615
  564549
  574307
  579608
  588738
  590528
  602707
  605958
  617625
  669504
  670005
  692280
  695087
  695786
  702237
  702239
  702306
  709503
  714564
  714598
  716033
  727587
  728900
  728992
  731670
  738365
  741504
  745662
  748453
  752742
  754185
  755605
  755633
  758003
  758185
  762276
  768114
  769135
  775889
  778109
  778559
  782342
  791742
  796552
  797316
  803845
  805338
  807270
  809575
  809604
  811131
  812452
  816099
  817532
  818761
  819739
  819859
  819940
  820212
  824066
  824140
  824448
  824546
  825180
  825711
  827339
  827432
]
19.13 ms
(3.39%)
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
  728992
  728900
  754185
  755605
  738365
  748453
  768114
  778559
  412157
  500038
  670005
  716033
  809575
  752742
  741551
  745662
  751981
  727587
  731670
  702306
  809604
  516668
  489117
  827432
  487235
  539341
  543644
  548049
  714564
  692280
  714598
  617625
  775889
  755633
  791742
  758003
  758185
  778109
  464954
  467781
  365907
  426870
  474242
  456892
  391980
  392095
  819739
  466338
  444670
  560238
  824140
  819859
  817532
  820212
  824066
  825711
  824448
  825180
  483961
  803845
  782342
  805338
  807270
  811131
  766118
  769135
  818761
  762276
  819940
  537024
  544952
  564549
  574307
  554237
  588738
  797316
  796552
  812452
  519585
  424197
  470620
  504216
  511083
  470705
  550234
  443958
  444223
  558315
  579608
  544459
  546580
  590528
  424129
  365875
  455357
  471108
  439584
  455428
  518615
  522485
  496058
  541767
  484391
  504152
  741504
  695087
  702239
  669504
  702237
  695786
  563615
  602707
  605958
  709503
  816099
  824546
  827339
  486209
  445425
  449981
]
2.34 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian milf homemade"
]
2.29 ms
(0.41%)
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
  365875
  365907
  391980
  392095
  412157
  424129
  424197
  426870
  439584
  443958
  444223
  444670
  445425
  449981
  455357
  455428
  456892
  464954
  466338
  467781
  470620
  470705
  471108
  474242
  483961
  484391
  486209
  487235
  489117
  496058
  500038
  504152
  504216
  511083
  516668
  518615
  519585
  522485
  537024
  539341
  541767
  543644
  544459
  544952
  546580
  548049
  550234
  554237
  558315
  560238
  563615
  564549
  574307
  579608
  588738
  590528
  602707
  605958
  617625
  669504
  670005
  692280
  695087
  695786
  702237
  702239
  702306
  709503
  714564
  714598
  716033
  727587
  728900
  728992
  731670
  738365
  741504
  745662
  748453
  752742
  754185
  755605
  755633
  758003
  758185
  762276
  768114
  769135
  775889
  778109
  778559
  782342
  791742
  796552
  797316
  803845
  805338
  807270
  809575
  809604
  811131
  812452
  816099
  817532
  818761
  819739
  819859
  819940
  820212
  824066
  824140
  824448
  824546
  825180
  825711
  827339
  827432
]
1.66 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск milf домашн любительск"
]

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.