Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.80 ms
(84.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
  550177
  550905
  554799
  556745
  556898
  576469
  576605
  591780
  599773
  600718
  604037
  604487
  612622
  612913
  616850
  618242
  620545
  622046
  625782
  627512
  628761
  629427
  636440
  642526
  644135
  702985
  705485
  713325
  714407
  724985
  725269
  727527
  727534
  727914
  728919
  728983
  729294
  731268
  731811
  733023
  733292
  733734
  734284
  735126
  735256
  737866
  738469
  739168
  739186
  739300
  739316
  739805
  740228
  740662
  740841
  741130
  741974
  741978
  743324
  744233
  746480
  746487
  746711
  747252
  747415
  748511
  749885
  752074
  757176
  759338
  766669
  769097
  770811
  771207
  771698
  771860
  771898
  771935
  772439
  772866
  773390
  773640
  774099
  776412
  777122
  779202
  784509
  784829
  784985
  785786
  786008
  787550
  787813
  788640
  788931
  790242
  791883
  792229
  793108
  794431
  795344
  795401
  796309
  796367
  796370
  796411
  796738
  796750
  797850
  798331
  798455
  801197
  801830
  802279
  803362
  803364
  803576
  810821
  812231
  813060
]
11.78 ms
(8.62%)
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
  550177
  550905
  554799
  556745
  556898
  576469
  576605
  599773
  612622
  616850
  622046
  628761
  629427
  644135
  591780
  600718
  620545
  636440
  642526
  612913
  625782
  604037
  618242
  627512
  777122
  779202
  784509
  788931
  790242
  794431
  795344
  796309
  796411
  796738
  796750
  801830
  810821
  786008
  787550
  787813
  791883
  792229
  793108
  795401
  796367
  798331
  798455
  801197
  802279
  803362
  803364
  803576
  813060
  733734
  734284
  735126
  735256
  737866
  741974
  741978
  743324
  746711
  752074
  766669
  772439
  784985
  796370
  797850
  812231
  725269
  727534
  727914
  728919
  729294
  731268
  731811
  739168
  740228
  748511
  749885
  759338
  770811
  771207
  728983
  733023
  739805
  746480
  769097
  727527
  733292
  738469
  739186
  739300
  739316
  741130
  744233
  746487
  747252
  771698
  771898
  771935
  773390
  724985
  740662
  740841
  747415
  757176
  771860
  772866
  773640
  774099
  604487
  702985
  705485
  713325
  714407
  776412
  784829
  785786
  788640
]
3.15 ms
(2.30%)
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
  550177
  550905
  554799
  556745
  556898
  576469
  576605
  591780
  599773
  600718
  604037
  604487
  612622
  612913
  616850
  618242
  620545
  622046
  625782
  627512
  628761
  629427
  636440
  642526
  644135
  702985
  705485
  713325
  714407
  724985
  725269
  727527
  727534
  727914
  728919
  728983
  729294
  731268
  731811
  733023
  733292
  733734
  734284
  735126
  735256
  737866
  738469
  739168
  739186
  739300
  739316
  739805
  740228
  740662
  740841
  741130
  741974
  741978
  743324
  744233
  746480
  746487
  746711
  747252
  747415
  748511
  749885
  752074
  757176
  759338
  766669
  769097
  770811
  771207
  771698
  771860
  771898
  771935
  772439
  772866
  773390
  773640
  774099
  776412
  777122
  779202
  784509
  784829
  784985
  785786
  786008
  787550
  787813
  788640
  788931
  790242
  791883
  792229
  793108
  794431
  795344
  795401
  796309
  796367
  796370
  796411
  796738
  796750
  797850
  798331
  798455
  801197
  801830
  802279
  803362
  803364
  803576
  810821
  812231
  813060
]
2.14 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hole pussy"
]
1.60 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дырк pussy"
]
1.57 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дырк pussy"
]

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.