Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.28 ms
(85.06%)
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
  6763
  23524
  181315
  214238
  237173
  378309
  393856
  394610
  399222
  401001
  401877
  404124
  407698
  422810
  448701
  457702
  465485
  488119
  536978
  538749
  545478
  548116
  556940
  560103
  563895
  576985
  585107
  585227
  587565
  591778
  593588
  597757
  606524
  610218
  611712
  612060
  616432
  616829
  622401
  626316
  626702
  627772
  630561
  631098
  632540
  634902
  636726
  637579
  639376
  640671
  641174
  646424
  646602
  647005
  647784
  647816
  648433
  654187
  661005
  662910
  662914
  668098
  668182
  673224
  675025
  675276
  679234
  679512
  683636
  688242
  688458
  688960
  690364
  693643
  709326
  711531
  711728
  711988
  712744
  714798
  717064
  719927
  719961
  720715
  720753
  723239
  724061
  726633
  728388
  731071
  732815
  738146
  738241
  738881
  744365
  745808
  755418
  755674
  757308
  758756
  759954
  761500
  761754
  771331
  785661
  786093
  801745
  805311
  805489
  806202
  813486
  814661
  815332
  817215
  819397
  823380
  823557
  823845
  824679
  828589
]
14.74 ms
(8.69%)
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
  675025
  679234
  679512
  714798
  646424
  668182
  688458
  646602
  616432
  631098
  611712
  813486
  732815
  738881
  744365
  731071
  755418
  759954
  23524
  404124
  407698
  817215
  823845
  819397
  823380
  824679
  828589
  448701
  647816
  647784
  688960
  647005
  648433
  639376
  587565
  616829
  630561
  597757
  636726
  640671
  805489
  641174
  401877
  214238
  422810
  457702
  612060
  622401
  545478
  728388
  738146
  393856
  399222
  488119
  538749
  548116
  673224
  662910
  711728
  662914
  688242
  576985
  634902
  593588
  637579
  585227
  610218
  738241
  755674
  786093
  801745
  805311
  771331
  757308
  606524
  720715
  181315
  401001
  394610
  6763
  724061
  806202
  237173
  378309
  823557
  815332
  536978
  654187
  668098
  719961
  711988
  675276
  690364
  626316
  627772
  785661
  745808
  726633
  709326
  465485
  585107
  814661
  556940
  560103
  712744
  717064
  720753
  661005
  723239
  683636
  693643
  711531
  719927
  563895
  626702
  591778
  632540
  758756
  761500
  761754
]
2.78 ms
(1.64%)
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
  6763
  23524
  181315
  214238
  237173
  378309
  393856
  394610
  399222
  401001
  401877
  404124
  407698
  422810
  448701
  457702
  465485
  488119
  536978
  538749
  545478
  548116
  556940
  560103
  563895
  576985
  585107
  585227
  587565
  591778
  593588
  597757
  606524
  610218
  611712
  612060
  616432
  616829
  622401
  626316
  626702
  627772
  630561
  631098
  632540
  634902
  636726
  637579
  639376
  640671
  641174
  646424
  646602
  647005
  647784
  647816
  648433
  654187
  661005
  662910
  662914
  668098
  668182
  673224
  675025
  675276
  679234
  679512
  683636
  688242
  688458
  688960
  690364
  693643
  709326
  711531
  711728
  711988
  712744
  714798
  717064
  719927
  719961
  720715
  720753
  723239
  724061
  726633
  728388
  731071
  732815
  738146
  738241
  738881
  744365
  745808
  755418
  755674
  757308
  758756
  759954
  761500
  761754
  771331
  785661
  786093
  801745
  805311
  805489
  806202
  813486
  814661
  815332
  817215
  819397
  823380
  823557
  823845
  824679
  828589
]
2.32 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass cock"
]
1.94 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп cock"
]
1.91 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп cock"
]

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.