Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.24 ms
(87.46%)
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
  79862
  384327
  386862
  389110
  391511
  393662
  397106
  400867
  401386
  402026
  402244
  402249
  412137
  415537
  424054
  439838
  444928
  448098
  451545
  453785
  455186
  458354
  459493
  460098
  461474
  462167
  462943
  465850
  472385
  472564
  475087
  477017
  481105
  483878
  485043
  487481
  488565
  488789
  488905
  501923
  502568
  505945
  507152
  511013
  513411
  513774
  520573
  523956
  525523
  527364
  529077
  534426
  542116
  549769
  551251
  552903
  556176
  556307
  562102
  563679
  568796
  570004
  570627
  571381
  579320
  584645
  584845
  588897
  595384
  599830
  602495
  613971
  615590
  617435
  625519
  626846
  630866
  654940
  659424
  661922
  666895
  675182
  678641
  684379
  691112
  692842
  695127
  695728
  704361
  705084
  719215
  720128
  722184
  722717
  725343
  726939
  733190
  736500
  739616
  744637
  747825
  752509
  766800
  767801
  769800
  772307
  772361
  777175
  777817
  777961
  781034
  781090
  782087
  782339
  783078
  786754
  787116
  787258
  803485
  821793
]
15.22 ms
(7.51%)
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
  782339
  477017
  507152
  782087
  461474
  412137
  684379
  719215
  661922
  626846
  781090
  787258
  733190
  767801
  777961
  659424
  384327
  766800
  570004
  584645
  617435
  704361
  691112
  602495
  787116
  726939
  772361
  451545
  424054
  595384
  654940
  739616
  722184
  551251
  502568
  501923
  402244
  720128
  692842
  402249
  722717
  534426
  475087
  615590
  529077
  458354
  523956
  481105
  568796
  678641
  520573
  821793
  599830
  781034
  747825
  415537
  549769
  625519
  695127
  389110
  562102
  695728
  584845
  393662
  459493
  588897
  563679
  769800
  513411
  488789
  571381
  439838
  744637
  402026
  570627
  391511
  613971
  462167
  472564
  579320
  803485
  472385
  483878
  513774
  525523
  488905
  448098
  401386
  777175
  397106
  675182
  772307
  736500
  777817
  786754
  453785
  666895
  465850
  386862
  552903
  79862
  752509
  462943
  485043
  505945
  460098
  455186
  444928
  487481
  705084
  783078
  725343
  630866
  511013
  400867
  527364
  556307
  488565
  542116
  556176
]
3.01 ms
(1.49%)
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
  79862
  384327
  386862
  389110
  391511
  393662
  397106
  400867
  401386
  402026
  402244
  402249
  412137
  415537
  424054
  439838
  444928
  448098
  451545
  453785
  455186
  458354
  459493
  460098
  461474
  462167
  462943
  465850
  472385
  472564
  475087
  477017
  481105
  483878
  485043
  487481
  488565
  488789
  488905
  501923
  502568
  505945
  507152
  511013
  513411
  513774
  520573
  523956
  525523
  527364
  529077
  534426
  542116
  549769
  551251
  552903
  556176
  556307
  562102
  563679
  568796
  570004
  570627
  571381
  579320
  584645
  584845
  588897
  595384
  599830
  602495
  613971
  615590
  617435
  625519
  626846
  630866
  654940
  659424
  661922
  666895
  675182
  678641
  684379
  691112
  692842
  695127
  695728
  704361
  705084
  719215
  720128
  722184
  722717
  725343
  726939
  733190
  736500
  739616
  744637
  747825
  752509
  766800
  767801
  769800
  772307
  772361
  777175
  777817
  777961
  781034
  781090
  782087
  782339
  783078
  786754
  787116
  787258
  803485
  821793
]
1.98 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахают в рот молодую…"
]
1.77 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс в рот молодая девушк"
]
1.71 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.84%)
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.