Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.99 ms
(87.30%)
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
  382301
  383098
  392978
  412632
  417272
  419058
  419271
  426560
  427143
  427513
  429291
  429508
  430567
  433679
  441798
  441952
  446783
  448059
  451670
  457593
  464348
  473935
  477764
  482566
  490267
  491357
  494734
  496336
  497806
  504060
  510841
  512792
  513120
  513982
  521219
  521230
  522413
  522617
  523071
  523726
  524268
  525396
  527196
  528150
  528770
  528936
  530747
  531533
  533841
  536375
  536460
  536470
  540039
  540084
  540474
  543849
  546202
  546829
  547321
  550952
  556319
  557452
  559192
  559668
  567349
  573193
  607819
  611730
  613825
  616787
  621433
  623656
  629388
  631301
  631503
  641938
  642260
  653396
  662009
  668512
  701234
  702149
  705711
  706569
  717367
  738487
  738818
  739860
  741548
  744904
  745007
  748479
  754162
  758261
  758992
  759243
  759785
  762140
  764034
  766830
  781646
  781663
  782017
  782203
  782252
  784504
  785491
  786472
  791394
  802842
  804859
  807516
  810715
  814640
  814704
  815150
  816091
  817753
  819421
  826180
]
13.81 ms
(7.58%)
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
  464348
  383098
  392978
  382301
  427513
  427143
  433679
  417272
  429508
  429291
  817753
  819421
  826180
  815150
  814640
  448059
  451670
  477764
  490267
  510841
  512792
  528150
  530747
  504060
  513120
  522617
  523071
  540039
  524268
  531533
  533841
  540084
  540474
  494734
  522413
  546829
  547321
  556319
  559192
  567349
  653396
  701234
  702149
  705711
  668512
  717367
  557452
  559668
  611730
  623656
  641938
  642260
  621433
  782203
  786472
  810715
  738487
  754162
  781663
  784504
  802842
  759243
  744904
  745007
  738818
  762140
  764034
  748479
  758261
  758992
  607819
  629388
  631301
  706569
  781646
  782017
  782252
  785491
  791394
  804859
  419058
  441798
  457593
  473935
  412632
  446783
  528936
  496336
  527196
  491357
  497806
  543849
  441952
  536460
  513982
  536375
  536470
  550952
  573193
  662009
  546202
  807516
  741548
  766830
  739860
  613825
  523726
  616787
  525396
  528770
  521219
  521230
  631503
  759785
  430567
  426560
  419271
  816091
  814704
  482566
]
2.73 ms
(1.50%)
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
  382301
  383098
  392978
  412632
  417272
  419058
  419271
  426560
  427143
  427513
  429291
  429508
  430567
  433679
  441798
  441952
  446783
  448059
  451670
  457593
  464348
  473935
  477764
  482566
  490267
  491357
  494734
  496336
  497806
  504060
  510841
  512792
  513120
  513982
  521219
  521230
  522413
  522617
  523071
  523726
  524268
  525396
  527196
  528150
  528770
  528936
  530747
  531533
  533841
  536375
  536460
  536470
  540039
  540084
  540474
  543849
  546202
  546829
  547321
  550952
  556319
  557452
  559192
  559668
  567349
  573193
  607819
  611730
  613825
  616787
  621433
  623656
  629388
  631301
  631503
  641938
  642260
  653396
  662009
  668512
  701234
  702149
  705711
  706569
  717367
  738487
  738818
  739860
  741548
  744904
  745007
  748479
  754162
  758261
  758992
  759243
  759785
  762140
  764034
  766830
  781646
  781663
  782017
  782203
  782252
  784504
  785491
  786472
  791394
  802842
  804859
  807516
  810715
  814640
  814704
  815150
  816091
  817753
  819421
  826180
]
1.86 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass bondage"
]
1.67 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп бдсм"
]
1.63 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.78%)
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.