Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.91 ms
(54.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "очкастая на улиц"
]
151.83 ms
(39.26%)
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
  191602
  229270
  386671
  389597
  396898
  408472
  408988
  421573
  460477
  470864
  471365
  477156
  481557
  484756
  485463
  489679
  491238
  504909
  505425
  515733
  526252
  527374
  530094
  531929
  532492
  535053
  541606
  541802
  543056
  543612
  543943
  544937
  549660
  551173
  551527
  551685
  551922
  552589
  554892
  556001
  558718
  560754
  565970
  570521
  584376
  589747
  592320
  594283
  597083
  599357
  601998
  603286
  603307
  605033
  607388
  610290
  613463
  613995
  614292
  614390
  614913
  618239
  620238
  630883
  633171
  650453
  662410
  669566
  669707
  676147
  678232
  695993
  700304
  702464
  703086
  705715
  707284
  713319
  714024
  714054
  717090
  718742
  720444
  720445
  720450
  727015
  734446
  734839
  737350
  739556
  743010
  743477
  745343
  750000
  750739
  752800
  753183
  757880
  761298
  763726
  764250
  774575
  778468
  788244
  789036
  789642
  790430
  790436
  791528
  797335
  798151
  798827
  801370
  803859
  804257
  806403
  816415
  819633
  823224
  826020
]
14.55 ms
(3.76%)
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
  505425
  477156
  229270
  386671
  532492
  484756
  543056
  551685
  560754
  702464
  714054
  707284
  614913
  778468
  790430
  804257
  734839
  757880
  743477
  745343
  753183
  790436
  489679
  551922
  599357
  481557
  592320
  589747
  597083
  720445
  191602
  515733
  470864
  549660
  610290
  823224
  531929
  530094
  565970
  662410
  717090
  700304
  551173
  554892
  584376
  630883
  791528
  788244
  750000
  727015
  737350
  614292
  797335
  544937
  504909
  552589
  543612
  618239
  485463
  541606
  396898
  826020
  527374
  543943
  558718
  718742
  720444
  676147
  695993
  603307
  789036
  734446
  743010
  601998
  614390
  408472
  556001
  471365
  613995
  541802
  703086
  705715
  713319
  720450
  650453
  669707
  714024
  678232
  798827
  789642
  801370
  752800
  761298
  763726
  408988
  491238
  421573
  819633
  460477
  535053
  551527
  570521
  669566
  633171
  594283
  806403
  798151
  803859
  750739
  739556
  764250
  605033
  620238
  774575
  389597
  526252
  613463
  607388
  603286
  816415
]
3.03 ms
(0.78%)
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
  191602
  229270
  386671
  389597
  396898
  408472
  408988
  421573
  460477
  470864
  471365
  477156
  481557
  484756
  485463
  489679
  491238
  504909
  505425
  515733
  526252
  527374
  530094
  531929
  532492
  535053
  541606
  541802
  543056
  543612
  543943
  544937
  549660
  551173
  551527
  551685
  551922
  552589
  554892
  556001
  558718
  560754
  565970
  570521
  584376
  589747
  592320
  594283
  597083
  599357
  601998
  603286
  603307
  605033
  607388
  610290
  613463
  613995
  614292
  614390
  614913
  618239
  620238
  630883
  633171
  650453
  662410
  669566
  669707
  676147
  678232
  695993
  700304
  702464
  703086
  705715
  707284
  713319
  714024
  714054
  717090
  718742
  720444
  720445
  720450
  727015
  734446
  734839
  737350
  739556
  743010
  743477
  745343
  750000
  750739
  752800
  753183
  757880
  761298
  763726
  764250
  774575
  778468
  788244
  789036
  789642
  790430
  790436
  791528
  797335
  798151
  798827
  801370
  803859
  804257
  806403
  816415
  819633
  823224
  826020
]
2.43 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "glasses public"
]
2.01 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(0.50%)
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.