Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.08 ms
(83.01%)
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
  390571
  400858
  411345
  419523
  424431
  425931
  428148
  439727
  440693
  443770
  451445
  452624
  455184
  455995
  457416
  457455
  462084
  462100
  464533
  466310
  466341
  467248
  469117
  470196
  470221
  472398
  475115
  475266
  478375
  479128
  481830
  483655
  485273
  485377
  485438
  485741
  485946
  485968
  487758
  488980
  489171
  489384
  490731
  493177
  494192
  494204
  495040
  495499
  495878
  497210
  504174
  504665
  505855
  509199
  509204
  509528
  509651
  509842
  512145
  513107
  513341
  517075
  518355
  519342
  520810
  520875
  522519
  526454
  528347
  541078
  545972
  547987
  549720
  549731
  549734
  550220
  556556
  556559
  558295
  561333
  562168
  563127
  571399
  579196
  589680
  614523
  618507
  666464
  669324
  673420
  695691
  735834
  735875
  735882
  735959
  735987
  739900
  741688
  741692
  741739
  741749
  742359
  742373
  742398
  742410
  742765
  746642
  749604
  766264
  766503
  766509
  788545
  794864
  794876
  794900
  796487
  796566
  807304
  825751
  827936
]
16.68 ms
(10.73%)
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
  766264
  746642
  735882
  735987
  742765
  749604
  472398
  485377
  520875
  669324
  673420
  695691
  666464
  556556
  618507
  766509
  766503
  741688
  741692
  741739
  742373
  742410
  741749
  742359
  742398
  614523
  443770
  470221
  481830
  485438
  509528
  485968
  475115
  400858
  505855
  479128
  497210
  466310
  390571
  457416
  475266
  440693
  467248
  470196
  478375
  509204
  485273
  526454
  462100
  541078
  562168
  462084
  488980
  504174
  519342
  485741
  485946
  495878
  451445
  425931
  517075
  509842
  487758
  419523
  411345
  464533
  439727
  455995
  504665
  469117
  512145
  495499
  520810
  825751
  545972
  549731
  556559
  558295
  547987
  549734
  579196
  589680
  796566
  739900
  424431
  455184
  466341
  452624
  428148
  494192
  513341
  494204
  495040
  522519
  827936
  509199
  561333
  794876
  794864
  735959
  794900
  807304
  735875
  735834
  509651
  528347
  571399
  550220
  563127
  788545
  796487
  457455
  483655
  513107
  518355
  489384
  490731
  489171
  493177
  549720
]
3.07 ms
(1.97%)
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
  390571
  400858
  411345
  419523
  424431
  425931
  428148
  439727
  440693
  443770
  451445
  452624
  455184
  455995
  457416
  457455
  462084
  462100
  464533
  466310
  466341
  467248
  469117
  470196
  470221
  472398
  475115
  475266
  478375
  479128
  481830
  483655
  485273
  485377
  485438
  485741
  485946
  485968
  487758
  488980
  489171
  489384
  490731
  493177
  494192
  494204
  495040
  495499
  495878
  497210
  504174
  504665
  505855
  509199
  509204
  509528
  509651
  509842
  512145
  513107
  513341
  517075
  518355
  519342
  520810
  520875
  522519
  526454
  528347
  541078
  545972
  547987
  549720
  549731
  549734
  550220
  556556
  556559
  558295
  561333
  562168
  563127
  571399
  579196
  589680
  614523
  618507
  666464
  669324
  673420
  695691
  735834
  735875
  735882
  735959
  735987
  739900
  741688
  741692
  741739
  741749
  742359
  742373
  742398
  742410
  742765
  746642
  749604
  766264
  766503
  766509
  788545
  794864
  794876
  794900
  796487
  796566
  807304
  825751
  827936
]
1.75 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин русск полная"
]
1.70 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые русское полные…"
]
1.65 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.02%)
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.