Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.62 ms
(85.52%)
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
  12880
  13035
  13373
  14105
  163310
  176148
  292790
  327134
  345303
  351291
  387374
  397971
  409597
  419221
  444446
  456235
  465687
  469495
  475728
  475731
  484236
  488640
  500500
  509678
  509874
  517018
  519069
  522109
  525433
  529317
  529491
  531561
  531867
  532718
  534007
  535247
  536376
  538756
  546392
  550180
  555149
  556767
  565760
  568838
  577935
  578505
  580472
  583398
  584985
  586164
  588404
  588741
  589392
  589996
  590041
  590063
  590807
  591700
  592665
  595355
  596041
  600838
  601198
  605510
  605692
  606818
  608121
  621344
  622730
  624189
  624204
  629422
  658787
  660849
  682942
  686101
  701610
  714011
  727458
  728277
  731226
  732208
  733219
  733249
  750154
  752405
  755579
  755583
  759914
  760238
  761030
  761451
  765273
  766821
  767209
  767268
  769524
  776466
  786205
  789408
  790861
  795010
  795052
  795977
  796861
  797472
  798207
  798271
  799708
  800579
  800595
  800855
  801146
  801576
  803346
  806100
  808053
  808061
  811045
  811557
]
13.05 ms
(8.35%)
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
  714011
  586164
  601198
  608121
  624189
  595355
  606818
  621344
  629422
  590063
  591700
  588741
  605510
  798207
  800579
  750154
  759914
  795977
  801576
  766821
  752405
  760238
  761030
  767268
  469495
  465687
  475731
  801146
  806100
  525433
  509678
  580472
  555149
  624204
  731226
  292790
  12880
  13373
  13035
  532718
  529317
  517018
  701610
  596041
  786205
  799708
  800595
  803346
  789408
  800855
  808053
  765273
  795052
  797472
  798271
  808061
  811045
  732208
  755579
  767209
  727458
  728277
  755583
  733219
  733249
  790861
  796861
  811557
  351291
  345303
  387374
  397971
  14105
  444446
  456235
  163310
  176148
  327134
  534007
  577935
  682942
  776466
  761451
  769524
  795010
  419221
  409597
  584985
  509874
  522109
  529491
  531867
  536376
  538756
  500500
  519069
  531561
  535247
  475728
  484236
  488640
  550180
  578505
  583398
  556767
  565760
  660849
  686101
  658787
  546392
  568838
  588404
  590041
  590807
  592665
  605692
  589392
  589996
  600838
  622730
]
2.57 ms
(1.65%)
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
  12880
  13035
  13373
  14105
  163310
  176148
  292790
  327134
  345303
  351291
  387374
  397971
  409597
  419221
  444446
  456235
  465687
  469495
  475728
  475731
  484236
  488640
  500500
  509678
  509874
  517018
  519069
  522109
  525433
  529317
  529491
  531561
  531867
  532718
  534007
  535247
  536376
  538756
  546392
  550180
  555149
  556767
  565760
  568838
  577935
  578505
  580472
  583398
  584985
  586164
  588404
  588741
  589392
  589996
  590041
  590063
  590807
  591700
  592665
  595355
  596041
  600838
  601198
  605510
  605692
  606818
  608121
  621344
  622730
  624189
  624204
  629422
  658787
  660849
  682942
  686101
  701610
  714011
  727458
  728277
  731226
  732208
  733219
  733249
  750154
  752405
  755579
  755583
  759914
  760238
  761030
  761451
  765273
  766821
  767209
  767268
  769524
  776466
  786205
  789408
  790861
  795010
  795052
  795977
  796861
  797472
  798207
  798271
  799708
  800579
  800595
  800855
  801146
  801576
  803346
  806100
  808053
  808061
  811045
  811557
]
1.85 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп"
]
1.81 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "but ass"
]
1.71 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.