Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.40 ms
(83.41%)
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
  21279
  188600
  395246
  397838
  400307
  435563
  442050
  446645
  454292
  469479
  475676
  475752
  477535
  480317
  480476
  485527
  487537
  497421
  499306
  499904
  501170
  502793
  503255
  505283
  508895
  510591
  510946
  512902
  513967
  514837
  514921
  515230
  515959
  520180
  520985
  524294
  525446
  525727
  526077
  528348
  529828
  532176
  533922
  539319
  539673
  540864
  541889
  542610
  548855
  548859
  553720
  554407
  554410
  554733
  555396
  557468
  559047
  560935
  560943
  563325
  567427
  570409
  571358
  577214
  577916
  578198
  579432
  585806
  585999
  586157
  586981
  588228
  589615
  591299
  592533
  592585
  593003
  593486
  594144
  595158
  595209
  603109
  604426
  604651
  605579
  605686
  605734
  605979
  606901
  610031
  613919
  614827
  621275
  623076
  626885
  633018
  634519
  647241
  648056
  649678
  653538
  655030
  655648
  656457
  663722
  663924
  664306
  671780
  675453
  679657
  683054
  685001
  702365
  721451
  748031
  751046
  757121
  760566
  763879
  778377
]
18.28 ms
(10.48%)
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
  577916
  579432
  605734
  606901
  603109
  525446
  533922
  554407
  648056
  605686
  526077
  548859
  604651
  510946
  499904
  520180
  515230
  487537
  480476
  502793
  513967
  528348
  554410
  653538
  563325
  605579
  593486
  614827
  514921
  671780
  675453
  435563
  555396
  560935
  559047
  586157
  446645
  501170
  514837
  560943
  595158
  593003
  570409
  778377
  508895
  578198
  588228
  604426
  469479
  454292
  623076
  683054
  497421
  503255
  524294
  475676
  571358
  554733
  610031
  485527
  685001
  586981
  594144
  595209
  477535
  512902
  529828
  663722
  679657
  515959
  585999
  592585
  542610
  567427
  626885
  475752
  557468
  480317
  591299
  634519
  510591
  188600
  748031
  553720
  541889
  633018
  656457
  539319
  21279
  532176
  655030
  647241
  548855
  655648
  751046
  760566
  395246
  664306
  592533
  605979
  525727
  621275
  397838
  763879
  442050
  400307
  589615
  505283
  577214
  585806
  757121
  539673
  520985
  540864
  499306
  702365
  649678
  663924
  721451
  613919
]
3.02 ms
(1.73%)
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
  21279
  188600
  395246
  397838
  400307
  435563
  442050
  446645
  454292
  469479
  475676
  475752
  477535
  480317
  480476
  485527
  487537
  497421
  499306
  499904
  501170
  502793
  503255
  505283
  508895
  510591
  510946
  512902
  513967
  514837
  514921
  515230
  515959
  520180
  520985
  524294
  525446
  525727
  526077
  528348
  529828
  532176
  533922
  539319
  539673
  540864
  541889
  542610
  548855
  548859
  553720
  554407
  554410
  554733
  555396
  557468
  559047
  560935
  560943
  563325
  567427
  570409
  571358
  577214
  577916
  578198
  579432
  585806
  585999
  586157
  586981
  588228
  589615
  591299
  592533
  592585
  593003
  593486
  594144
  595158
  595209
  603109
  604426
  604651
  605579
  605686
  605734
  605979
  606901
  610031
  613919
  614827
  621275
  623076
  626885
  633018
  634519
  647241
  648056
  649678
  653538
  655030
  655648
  656457
  663722
  663924
  664306
  671780
  675453
  679657
  683054
  685001
  702365
  721451
  748031
  751046
  757121
  760566
  763879
  778377
]
2.27 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопы раздвигают"
]
1.98 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп раздвига"
]
1.54 ms
(0.88%)
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.