Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.96 ms
(84.15%)
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
  387287
  397331
  413595
  430072
  434624
  439218
  440680
  442691
  443652
  443990
  446624
  446771
  447073
  449435
  449562
  449886
  450670
  453935
  454658
  457770
  460295
  473915
  476054
  477362
  478833
  484433
  484866
  495480
  504418
  505623
  507601
  514806
  515690
  515724
  517941
  525119
  527200
  527454
  530010
  531242
  531657
  533747
  536058
  536914
  538510
  541676
  542606
  544523
  545190
  545223
  545415
  548614
  552463
  553750
  554288
  555135
  555882
  556115
  556407
  556899
  556901
  559355
  559568
  559914
  560106
  561416
  562377
  565262
  568260
  570090
  572867
  574704
  575154
  575941
  578778
  579026
  586157
  586914
  587260
  587397
  589057
  589378
  591874
  592319
  592380
  594267
  597113
  597242
  599108
  601558
  604259
  606269
  606686
  606947
  622391
  627814
  633497
  635902
  647844
  660405
  660412
  666016
  666886
  669035
  671045
  672992
  676769
  685013
  695868
  696210
  702168
  722543
  747612
  750546
  751880
  761510
  780642
  790951
  807011
  821605
]
18.40 ms
(9.87%)
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
  553750
  556899
  542606
  568260
  578778
  672992
  722543
  676769
  685013
  696210
  545415
  556407
  556901
  559914
  575941
  606269
  599108
  606686
  594267
  601558
  589057
  604259
  790951
  750546
  761510
  751880
  747612
  606947
  635902
  446771
  495480
  538510
  554288
  622391
  587397
  387287
  450670
  478833
  536914
  531657
  536058
  548614
  552463
  560106
  545190
  574704
  575154
  544523
  545223
  556115
  559355
  559568
  561416
  572867
  579026
  660405
  666886
  695868
  647844
  660412
  666016
  669035
  671045
  555135
  555882
  562377
  570090
  586914
  587260
  589378
  592380
  597242
  586157
  597113
  591874
  592319
  780642
  807011
  476054
  447073
  460295
  453935
  439218
  541676
  517941
  533747
  702168
  565262
  627814
  633497
  484866
  397331
  443990
  440680
  430072
  434624
  443652
  413595
  442691
  821605
  446624
  454658
  473915
  477362
  449435
  449562
  457770
  484433
  449886
  505623
  530010
  531242
  515724
  525119
  527454
  504418
  507601
  514806
  515690
  527200
]
3.28 ms
(1.76%)
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
  387287
  397331
  413595
  430072
  434624
  439218
  440680
  442691
  443652
  443990
  446624
  446771
  447073
  449435
  449562
  449886
  450670
  453935
  454658
  457770
  460295
  473915
  476054
  477362
  478833
  484433
  484866
  495480
  504418
  505623
  507601
  514806
  515690
  515724
  517941
  525119
  527200
  527454
  530010
  531242
  531657
  533747
  536058
  536914
  538510
  541676
  542606
  544523
  545190
  545223
  545415
  548614
  552463
  553750
  554288
  555135
  555882
  556115
  556407
  556899
  556901
  559355
  559568
  559914
  560106
  561416
  562377
  565262
  568260
  570090
  572867
  574704
  575154
  575941
  578778
  579026
  586157
  586914
  587260
  587397
  589057
  589378
  591874
  592319
  592380
  594267
  597113
  597242
  599108
  601558
  604259
  606269
  606686
  606947
  622391
  627814
  633497
  635902
  647844
  660405
  660412
  666016
  666886
  669035
  671045
  672992
  676769
  685013
  695868
  696210
  702168
  722543
  747612
  750546
  751880
  761510
  780642
  790951
  807011
  821605
]
2.35 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny big ass"
]
1.91 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые большая большие жоп"
]
1.84 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.95%)
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.