Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
343.88 ms
(93.36%)
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
  383902
  385334
  405128
  415307
  418868
  425018
  432786
  433644
  440265
  443645
  451591
  452400
  453539
  454537
  454661
  454706
  455835
  456557
  456816
  458243
  459192
  474272
  475065
  476564
  479517
  484075
  484401
  485560
  486978
  487862
  488844
  488920
  491372
  491376
  492010
  492396
  493933
  494394
  494938
  496711
  497625
  499184
  501408
  502210
  503792
  505858
  508645
  509005
  510126
  511065
  518586
  518826
  522266
  525638
  525950
  527021
  528911
  528913
  531547
  532375
  534862
  537290
  544064
  544313
  545365
  547427
  548316
  551183
  554647
  559087
  562285
  562618
  563333
  564860
  565088
  565361
  565377
  566695
  568168
  569169
  569793
  572566
  574421
  577376
  577957
  581120
  585447
  587385
  588813
  594505
  599788
  603387
  606321
  608363
  624329
  626911
  631185
  633155
  643728
  650275
  659297
  667555
  673424
  680900
  681530
  690410
  691899
  698341
  701609
  712964
  717676
  718740
  741649
  778400
  787532
  789846
  793622
  811510
  815041
  825595
]
14.33 ms
(3.89%)
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
  418868
  793622
  491376
  486978
  532375
  497625
  488920
  778400
  569169
  603387
  425018
  527021
  508645
  574421
  455835
  681530
  624329
  815041
  454661
  459192
  562618
  525950
  787532
  562285
  503792
  691899
  545365
  488844
  452400
  789846
  505858
  667555
  701609
  673424
  551183
  599788
  385334
  741649
  456557
  572566
  698341
  680900
  588813
  499184
  476564
  534862
  564860
  690410
  518586
  631185
  415307
  494394
  528911
  502210
  565088
  491372
  493933
  433644
  511065
  451591
  405128
  626911
  581120
  608363
  825595
  811510
  501408
  496711
  525638
  383902
  650275
  484075
  453539
  454537
  717676
  587385
  566695
  492010
  718740
  585447
  522266
  537290
  458243
  547427
  544064
  563333
  577376
  577957
  594505
  484401
  659297
  454706
  509005
  544313
  518826
  548316
  440265
  443645
  510126
  559087
  606321
  494938
  456816
  487862
  528913
  565361
  565377
  479517
  432786
  475065
  554647
  712964
  633155
  568168
  569793
  485560
  492396
  531547
  643728
  474272
]
3.34 ms
(0.91%)
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
  383902
  385334
  405128
  415307
  418868
  425018
  432786
  433644
  440265
  443645
  451591
  452400
  453539
  454537
  454661
  454706
  455835
  456557
  456816
  458243
  459192
  474272
  475065
  476564
  479517
  484075
  484401
  485560
  486978
  487862
  488844
  488920
  491372
  491376
  492010
  492396
  493933
  494394
  494938
  496711
  497625
  499184
  501408
  502210
  503792
  505858
  508645
  509005
  510126
  511065
  518586
  518826
  522266
  525638
  525950
  527021
  528911
  528913
  531547
  532375
  534862
  537290
  544064
  544313
  545365
  547427
  548316
  551183
  554647
  559087
  562285
  562618
  563333
  564860
  565088
  565361
  565377
  566695
  568168
  569169
  569793
  572566
  574421
  577376
  577957
  581120
  585447
  587385
  588813
  594505
  599788
  603387
  606321
  608363
  624329
  626911
  631185
  633155
  643728
  650275
  659297
  667555
  673424
  680900
  681530
  690410
  691899
  698341
  701609
  712964
  717676
  718740
  741649
  778400
  787532
  789846
  793622
  811510
  815041
  825595
]
1.80 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex public"
]
1.79 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс на улиц"
]
1.51 ms
(0.41%)
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.