Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.58 ms
(81.50%)
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
  382735
  400892
  418138
  421780
  423721
  424255
  428603
  429445
  439480
  440838
  440862
  443091
  449652
  450158
  450787
  456858
  457245
  459972
  461973
  462266
  472683
  474809
  475860
  475907
  475986
  478060
  480191
  487753
  490816
  490862
  495730
  500794
  506230
  506940
  507627
  508431
  510111
  511820
  513589
  514131
  515391
  519335
  521725
  523296
  526385
  527175
  527316
  527772
  528324
  529174
  530307
  533653
  534119
  535050
  537971
  541396
  542094
  552798
  554952
  555701
  558230
  560438
  561509
  564488
  565769
  565771
  565903
  566371
  573559
  574387
  574424
  574562
  575539
  578255
  579215
  581213
  588609
  591494
  591728
  598466
  598840
  600476
  604257
  608645
  619822
  622785
  622830
  623085
  625532
  625771
  627061
  635050
  650276
  650605
  651572
  657177
  660137
  665990
  671888
  672752
  677106
  684029
  696429
  700590
  700727
  712763
  716693
  717410
  724696
  739900
  740095
  758268
  763442
  767018
  773864
  779591
  780517
  781779
  783237
  817230
]
17.88 ms
(11.42%)
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
  514131
  490816
  500794
  519335
  515391
  523296
  527316
  424255
  487753
  527772
  560438
  650605
  552798
  527175
  573559
  574562
  700590
  763442
  740095
  526385
  542094
  507627
  440838
  472683
  622785
  780517
  428603
  657177
  724696
  627061
  382735
  461973
  510111
  400892
  439480
  440862
  443091
  421780
  423721
  817230
  449652
  456858
  474809
  480191
  450787
  478060
  490862
  457245
  459972
  475986
  495730
  513589
  528324
  534119
  521725
  537971
  508431
  511820
  529174
  533653
  506230
  506940
  530307
  535050
  541396
  574424
  575539
  558230
  565903
  574387
  578255
  581213
  554952
  555701
  564488
  566371
  650276
  651572
  660137
  672752
  700727
  677106
  684029
  696429
  717410
  665990
  671888
  716693
  561509
  565769
  565771
  579215
  591728
  598840
  608645
  623085
  619822
  600476
  604257
  588609
  591494
  598466
  625771
  779591
  783237
  781779
  767018
  773864
  758268
  739900
  622830
  625532
  635050
  712763
  429445
  475860
  475907
  450158
  418138
  462266
]
3.51 ms
(2.24%)
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
  382735
  400892
  418138
  421780
  423721
  424255
  428603
  429445
  439480
  440838
  440862
  443091
  449652
  450158
  450787
  456858
  457245
  459972
  461973
  462266
  472683
  474809
  475860
  475907
  475986
  478060
  480191
  487753
  490816
  490862
  495730
  500794
  506230
  506940
  507627
  508431
  510111
  511820
  513589
  514131
  515391
  519335
  521725
  523296
  526385
  527175
  527316
  527772
  528324
  529174
  530307
  533653
  534119
  535050
  537971
  541396
  542094
  552798
  554952
  555701
  558230
  560438
  561509
  564488
  565769
  565771
  565903
  566371
  573559
  574387
  574424
  574562
  575539
  578255
  579215
  581213
  588609
  591494
  591728
  598466
  598840
  600476
  604257
  608645
  619822
  622785
  622830
  623085
  625532
  625771
  627061
  635050
  650276
  650605
  651572
  657177
  660137
  665990
  671888
  672752
  677106
  684029
  696429
  700590
  700727
  712763
  716693
  717410
  724696
  739900
  740095
  758268
  763442
  767018
  773864
  779591
  780517
  781779
  783237
  817230
]
2.16 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен porn"
]
1.99 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife porn"
]
1.79 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен porn"
]
1.63 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.