Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.39 ms
(85.81%)
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
  187595
  187699
  188266
  193928
  274930
  305626
  384220
  384752
  388765
  391546
  404030
  407810
  411909
  429839
  432249
  446854
  448628
  451797
  452377
  453146
  456731
  464321
  464447
  465513
  466939
  467032
  467083
  467095
  471713
  472143
  472705
  473510
  474409
  474851
  476325
  478573
  480755
  483090
  483137
  483459
  483921
  485720
  485745
  487340
  487347
  496346
  496547
  499865
  502023
  506846
  506848
  508163
  511559
  515059
  515074
  515265
  515911
  516042
  517383
  518843
  518855
  519136
  520271
  524078
  525493
  525500
  525832
  526214
  529778
  534001
  534245
  536320
  539483
  540509
  541897
  544503
  545247
  546941
  547942
  549227
  549228
  550651
  552250
  554407
  557436
  558174
  563424
  578158
  578187
  580739
  583664
  591134
  599737
  610016
  636426
  664828
  667290
  668412
  691254
  712823
  713193
  725369
  728191
  728316
  728328
  732355
  744229
  745951
  748151
  770111
  770179
  774176
  776217
  781980
  788978
  790986
  796441
  796723
  806311
  810770
]
17.97 ms
(9.16%)
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
  464321
  506848
  539483
  518843
  534245
  506846
  524078
  508163
  515059
  515074
  515265
  516042
  534001
  536320
  540509
  467032
  483137
  578158
  544503
  547942
  578187
  552250
  554407
  580739
  668412
  713193
  712823
  664828
  691254
  546941
  610016
  591134
  599737
  636426
  790986
  810770
  776217
  796441
  725369
  770179
  788978
  796723
  728316
  748151
  728191
  728328
  745951
  774176
  732355
  744229
  770111
  781980
  806311
  187595
  193928
  391546
  453146
  456731
  465513
  384220
  388765
  472705
  448628
  496346
  520271
  483921
  496547
  499865
  502023
  525493
  517383
  529778
  550651
  526214
  384752
  188266
  187699
  274930
  305626
  404030
  407810
  432249
  429839
  411909
  466939
  474409
  485720
  487347
  451797
  452377
  464447
  472143
  474851
  480755
  485745
  446854
  473510
  478573
  483090
  511559
  515911
  518855
  525500
  519136
  525832
  467083
  467095
  471713
  476325
  483459
  487340
  541897
  545247
  549227
  549228
  558174
  557436
  583664
  563424
  667290
]
3.13 ms
(1.59%)
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
  187595
  187699
  188266
  193928
  274930
  305626
  384220
  384752
  388765
  391546
  404030
  407810
  411909
  429839
  432249
  446854
  448628
  451797
  452377
  453146
  456731
  464321
  464447
  465513
  466939
  467032
  467083
  467095
  471713
  472143
  472705
  473510
  474409
  474851
  476325
  478573
  480755
  483090
  483137
  483459
  483921
  485720
  485745
  487340
  487347
  496346
  496547
  499865
  502023
  506846
  506848
  508163
  511559
  515059
  515074
  515265
  515911
  516042
  517383
  518843
  518855
  519136
  520271
  524078
  525493
  525500
  525832
  526214
  529778
  534001
  534245
  536320
  539483
  540509
  541897
  544503
  545247
  546941
  547942
  549227
  549228
  550651
  552250
  554407
  557436
  558174
  563424
  578158
  578187
  580739
  583664
  591134
  599737
  610016
  636426
  664828
  667290
  668412
  691254
  712823
  713193
  725369
  728191
  728316
  728328
  732355
  744229
  745951
  748151
  770111
  770179
  774176
  776217
  781980
  788978
  790986
  796441
  796723
  806311
  810770
]
1.93 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy granny"
]
1.78 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy granny"
]
1.52 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy granny"
]

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.