Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.31 ms
(88.16%)
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
  22843
  131602
  212793
  346126
  383225
  397173
  397670
  468232
  488359
  491244
  517035
  520148
  530398
  531742
  533206
  533250
  536756
  537785
  539316
  540077
  540129
  543679
  547412
  548945
  553144
  553185
  554888
  555205
  555210
  555227
  555724
  558541
  558631
  560912
  561954
  567470
  567982
  568211
  574172
  574319
  575253
  575885
  576482
  579783
  581551
  582729
  583301
  584031
  584219
  592219
  593271
  594321
  599242
  606123
  609757
  609761
  611496
  619989
  627671
  628358
  633715
  636765
  637328
  641627
  643458
  647530
  649356
  650719
  651158
  651322
  652984
  659015
  661619
  663284
  664191
  664477
  666116
  666491
  667738
  669655
  669876
  678776
  682829
  690300
  696960
  701909
  702354
  702377
  706666
  714076
  726133
  740823
  744129
  749426
  750371
  750507
  751185
  753613
  753617
  772329
  774730
  777164
  779263
  781934
  784929
  790447
  802305
  805699
  807053
  807283
  811219
  812284
  813114
  824112
  825800
  826973
  827498
  827553
  827630
  827712
]
10.56 ms
(5.74%)
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
  517035
  540077
  533206
  553185
  574172
  575885
  579783
  581551
  650719
  669655
  678776
  682829
  701909
  652984
  696960
  702377
  664191
  558541
  574319
  575253
  582729
  584219
  619989
  606123
  627671
  636765
  643458
  594321
  609757
  774730
  807283
  777164
  813114
  740823
  805699
  811219
  772329
  744129
  753617
  749426
  750507
  753613
  609761
  702354
  779263
  790447
  802305
  807053
  397670
  468232
  488359
  561954
  690300
  531742
  548945
  558631
  383225
  397173
  827630
  824112
  825800
  491244
  520148
  530398
  537785
  539316
  536756
  540129
  547412
  553144
  576482
  555205
  555210
  555724
  567470
  568211
  651158
  664477
  666116
  659015
  667738
  560912
  628358
  592219
  593271
  781934
  784929
  750371
  812284
  726133
  751185
  706666
  212793
  131602
  346126
  22843
  826973
  827498
  827553
  827712
  533250
  583301
  584031
  543679
  554888
  555227
  649356
  661619
  714076
  647530
  651322
  663284
  666491
  669876
  567982
  641627
  599242
  611496
  633715
  637328
]
3.39 ms
(1.84%)
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
  22843
  131602
  212793
  346126
  383225
  397173
  397670
  468232
  488359
  491244
  517035
  520148
  530398
  531742
  533206
  533250
  536756
  537785
  539316
  540077
  540129
  543679
  547412
  548945
  553144
  553185
  554888
  555205
  555210
  555227
  555724
  558541
  558631
  560912
  561954
  567470
  567982
  568211
  574172
  574319
  575253
  575885
  576482
  579783
  581551
  582729
  583301
  584031
  584219
  592219
  593271
  594321
  599242
  606123
  609757
  609761
  611496
  619989
  627671
  628358
  633715
  636765
  637328
  641627
  643458
  647530
  649356
  650719
  651158
  651322
  652984
  659015
  661619
  663284
  664191
  664477
  666116
  666491
  667738
  669655
  669876
  678776
  682829
  690300
  696960
  701909
  702354
  702377
  706666
  714076
  726133
  740823
  744129
  749426
  750371
  750507
  751185
  753613
  753617
  772329
  774730
  777164
  779263
  781934
  784929
  790447
  802305
  805699
  807053
  807283
  811219
  812284
  813114
  824112
  825800
  826973
  827498
  827553
  827630
  827712
]
2.41 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло девушк shower"
]
2.17 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo girl shower"
]
1.72 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло девушк shower"
]

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.