Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.70 ms
(87.27%)
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
  420730
  422392
  426680
  427406
  446125
  447076
  447094
  453638
  455356
  456387
  456858
  462533
  466491
  472765
  474809
  475860
  475907
  475986
  479955
  479962
  479964
  480191
  485258
  485619
  490816
  490945
  491391
  492158
  492341
  492986
  493367
  497574
  499018
  499021
  499073
  500134
  500576
  501415
  503165
  504220
  506230
  507625
  507627
  507630
  509110
  510122
  510521
  511820
  513344
  514131
  518970
  519335
  520093
  520361
  521725
  522513
  524105
  524180
  524314
  524359
  526865
  526872
  527175
  527316
  527851
  528590
  528660
  530307
  530578
  533653
  534119
  534744
  535050
  535640
  535746
  535748
  537971
  552798
  555701
  565420
  565769
  566371
  566585
  569788
  572943
  574387
  575539
  575557
  581213
  582920
  584465
  591275
  591389
  591728
  597152
  602944
  603783
  604257
  609235
  610952
  612068
  622830
  623211
  623495
  623815
  625771
  626015
  650197
  660664
  665990
  670056
  671886
  671888
  690943
  691137
  696429
  712763
  727828
  733319
  783237
]
15.39 ms
(8.31%)
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
  462533
  455356
  510521
  524180
  492158
  507625
  514131
  519335
  524359
  527316
  420730
  490816
  671886
  650197
  610952
  727828
  497574
  524314
  491391
  530578
  534119
  509110
  575539
  581213
  696429
  665990
  671888
  591728
  604257
  712763
  500134
  533653
  506230
  535050
  572943
  555701
  660664
  479962
  520093
  528590
  485619
  507630
  527175
  537971
  511820
  534744
  535746
  530307
  569788
  552798
  565769
  783237
  622830
  527851
  535640
  492341
  499018
  456387
  480191
  475986
  521725
  566585
  574387
  566371
  625771
  475907
  479964
  479955
  447076
  504220
  510122
  513344
  526865
  522513
  524105
  492986
  499021
  520361
  427406
  456858
  474809
  623495
  591389
  623815
  475860
  422392
  426680
  528660
  485258
  490945
  499073
  453638
  518970
  503165
  565420
  472765
  623211
  612068
  493367
  691137
  582920
  597152
  602944
  603783
  733319
  507627
  575557
  690943
  626015
  609235
  535748
  591275
  447094
  500576
  501415
  584465
  670056
  466491
  446125
  526872
]
2.48 ms
(1.34%)
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
  420730
  422392
  426680
  427406
  446125
  447076
  447094
  453638
  455356
  456387
  456858
  462533
  466491
  472765
  474809
  475860
  475907
  475986
  479955
  479962
  479964
  480191
  485258
  485619
  490816
  490945
  491391
  492158
  492341
  492986
  493367
  497574
  499018
  499021
  499073
  500134
  500576
  501415
  503165
  504220
  506230
  507625
  507627
  507630
  509110
  510122
  510521
  511820
  513344
  514131
  518970
  519335
  520093
  520361
  521725
  522513
  524105
  524180
  524314
  524359
  526865
  526872
  527175
  527316
  527851
  528590
  528660
  530307
  530578
  533653
  534119
  534744
  535050
  535640
  535746
  535748
  537971
  552798
  555701
  565420
  565769
  566371
  566585
  569788
  572943
  574387
  575539
  575557
  581213
  582920
  584465
  591275
  591389
  591728
  597152
  602944
  603783
  604257
  609235
  610952
  612068
  622830
  623211
  623495
  623815
  625771
  626015
  650197
  660664
  665990
  670056
  671886
  671888
  690943
  691137
  696429
  712763
  727828
  733319
  783237
]
1.72 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur porn"
]
1.31 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск porn"
]
1.14 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск porn"
]

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.