Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.75 ms
(75.80%)
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
  389479
  395812
  395826
  399300
  414160
  415134
  415655
  421562
  422657
  424401
  431498
  431768
  439854
  446740
  447089
  452499
  461744
  463873
  471446
  472105
  473037
  473733
  473909
  474746
  479219
  483498
  484478
  486055
  487156
  491253
  491500
  491503
  495158
  508198
  510964
  511803
  512315
  512973
  513576
  514574
  516820
  517549
  518270
  520627
  521033
  521989
  522566
  524589
  525873
  526022
  526024
  526836
  527495
  528788
  531078
  545614
  548257
  550329
  550679
  550684
  551913
  554370
  554646
  555893
  558128
  558138
  560450
  560569
  561997
  563852
  564443
  565156
  565367
  565617
  566703
  566810
  575197
  575778
  576051
  576082
  579368
  580296
  580646
  581663
  581684
  590796
  595383
  595875
  598042
  598545
  598806
  600035
  600060
  600069
  600084
  603493
  605122
  605406
  605500
  606822
  609280
  609842
  610613
  611001
  611661
  611820
  612099
  612455
  620295
  621691
  621705
  623413
  624214
  624215
  625395
  628044
  655697
  657402
  682530
  683508
]
28.58 ms
(17.65%)
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
  495158
  514574
  527495
  531078
  395826
  431768
  414160
  422657
  484478
  452499
  473037
  510964
  576051
  576082
  550684
  564443
  579368
  554646
  566810
  611001
  395812
  463873
  473909
  474746
  389479
  472105
  439854
  471446
  508198
  521033
  512315
  522566
  525873
  491253
  491503
  511803
  526024
  483498
  520627
  524589
  526836
  431498
  446740
  558138
  565617
  575778
  565367
  598042
  421562
  424401
  415655
  517549
  487156
  512973
  513576
  491500
  415134
  566703
  558128
  683508
  611661
  621705
  399300
  473733
  461744
  516820
  550679
  606822
  598545
  620295
  600060
  600069
  526022
  548257
  555893
  563852
  580296
  580646
  560450
  565156
  581663
  560569
  581684
  655697
  657402
  682530
  561997
  625395
  624214
  600084
  605500
  612099
  628044
  595383
  600035
  611820
  621691
  610613
  447089
  479219
  518270
  521989
  486055
  528788
  545614
  550329
  551913
  554370
  575197
  603493
  609842
  623413
  624215
  595875
  612455
  598806
  605122
  590796
  605406
  609280
]
2.72 ms
(1.68%)
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
  389479
  395812
  395826
  399300
  414160
  415134
  415655
  421562
  422657
  424401
  431498
  431768
  439854
  446740
  447089
  452499
  461744
  463873
  471446
  472105
  473037
  473733
  473909
  474746
  479219
  483498
  484478
  486055
  487156
  491253
  491500
  491503
  495158
  508198
  510964
  511803
  512315
  512973
  513576
  514574
  516820
  517549
  518270
  520627
  521033
  521989
  522566
  524589
  525873
  526022
  526024
  526836
  527495
  528788
  531078
  545614
  548257
  550329
  550679
  550684
  551913
  554370
  554646
  555893
  558128
  558138
  560450
  560569
  561997
  563852
  564443
  565156
  565367
  565617
  566703
  566810
  575197
  575778
  576051
  576082
  579368
  580296
  580646
  581663
  581684
  590796
  595383
  595875
  598042
  598545
  598806
  600035
  600060
  600069
  600084
  603493
  605122
  605406
  605500
  606822
  609280
  609842
  610613
  611001
  611661
  611820
  612099
  612455
  620295
  621691
  621705
  623413
  624214
  624215
  625395
  628044
  655697
  657402
  682530
  683508
]
2.21 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый милашк"
]
2.17 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дед с милашкой"
]
1.70 ms
(1.05%)
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.