Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.33 ms
(84.33%)
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
  187840
  187964
  188515
  233292
  327523
  381757
  385638
  385991
  386044
  388318
  395938
  396865
  397220
  397224
  398466
  398551
  398567
  421524
  454203
  480077
  488311
  514823
  515060
  531940
  540568
  548052
  550652
  554322
  577832
  591265
  592791
  599277
  607607
  619600
  633345
  635610
  639652
  651621
  662898
  664389
  664793
  665235
  665419
  665486
  666153
  667254
  667294
  667607
  678757
  678761
  693254
  695634
  698497
  710011
  717700
  719925
  720610
  721002
  721454
  724290
  725504
  726910
  726965
  728254
  731767
  731785
  732179
  732986
  733134
  733946
  735028
  735442
  739174
  742274
  744339
  744797
  745444
  749232
  752888
  755256
  755684
  770121
  770203
  773900
  776131
  781679
  781693
  781919
  781933
  781963
  781967
  781978
  784632
  785436
  788285
  789197
  789301
  796807
  799162
  799171
  801053
  802439
  802759
  804453
  807605
  807626
  808163
  814621
  817393
  817721
  817980
  818648
  819628
  820284
  823976
  824938
  825036
  825241
  827629
  827668
]
13.04 ms
(9.14%)
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
  731785
  749232
  770121
  770203
  773900
  755256
  776131
  781679
  781919
  781933
  781967
  788285
  799162
  802759
  807605
  807626
  808163
  388318
  607607
  398466
  824938
  818648
  488311
  781978
  732179
  735028
  454203
  386044
  188515
  381757
  814621
  825036
  827629
  817980
  480077
  514823
  531940
  540568
  515060
  550652
  554322
  577832
  666153
  667294
  667607
  717700
  662898
  664793
  665235
  678757
  695634
  698497
  720610
  721454
  665419
  665486
  667254
  678761
  591265
  592791
  599277
  633345
  619600
  639652
  781963
  789197
  801053
  781693
  789301
  799171
  802439
  744339
  744797
  755684
  785436
  804453
  726910
  733946
  739174
  732986
  735442
  745444
  724290
  731767
  742274
  710011
  721002
  784632
  796807
  233292
  398551
  327523
  693254
  719925
  725504
  728254
  726965
  385638
  421524
  825241
  651621
  664389
  548052
  635610
  752888
  733134
  187840
  385991
  187964
  395938
  396865
  397220
  397224
  398567
  820284
  823976
  817721
  817393
  819628
  827668
]
2.20 ms
(1.54%)
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
  187840
  187964
  188515
  233292
  327523
  381757
  385638
  385991
  386044
  388318
  395938
  396865
  397220
  397224
  398466
  398551
  398567
  421524
  454203
  480077
  488311
  514823
  515060
  531940
  540568
  548052
  550652
  554322
  577832
  591265
  592791
  599277
  607607
  619600
  633345
  635610
  639652
  651621
  662898
  664389
  664793
  665235
  665419
  665486
  666153
  667254
  667294
  667607
  678757
  678761
  693254
  695634
  698497
  710011
  717700
  719925
  720610
  721002
  721454
  724290
  725504
  726910
  726965
  728254
  731767
  731785
  732179
  732986
  733134
  733946
  735028
  735442
  739174
  742274
  744339
  744797
  745444
  749232
  752888
  755256
  755684
  770121
  770203
  773900
  776131
  781679
  781693
  781919
  781933
  781963
  781967
  781978
  784632
  785436
  788285
  789197
  789301
  796807
  799162
  799171
  801053
  802439
  802759
  804453
  807605
  807626
  808163
  814621
  817393
  817721
  817980
  818648
  819628
  820284
  823976
  824938
  825036
  825241
  827629
  827668
]
1.85 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопу бабки"
]
1.80 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп бабушк"
]
1.80 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп бабушк"
]
1.67 ms
(1.17%)
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.