Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
109.49 ms
(78.67%)
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
  414946
  430204
  430621
  430635
  442332
  442726
  448034
  451928
  451929
  451940
  451951
  451957
  451974
  451983
  452014
  452018
  452034
  452048
  452053
  452082
  452084
  452092
  452093
  452097
  452109
  452131
  452519
  464329
  472237
  486938
  492322
  492565
  497452
  497865
  510443
  510557
  511733
  512058
  516029
  518248
  519318
  522035
  522191
  522975
  524324
  524613
  527000
  529290
  530478
  530726
  531481
  532164
  532499
  533426
  534288
  534316
  534334
  537251
  540441
  541630
  541632
  541634
  541638
  541646
  541647
  541651
  541656
  541712
  541721
  541728
  541740
  541748
  541749
  541751
  541773
  541774
  541780
  542189
  542192
  542193
  554568
  555798
  556415
  560195
  565277
  583533
  584481
  584703
  586594
  586674
  588283
  606748
  609783
  621858
  624502
  628398
  632565
  633130
  633158
  633166
  633176
  640710
  643113
  650155
  662020
  696233
  801907
]
19.19 ms
(13.78%)
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
  696233
  556415
  624502
  588283
  586674
  609783
  632565
  633130
  633176
  640710
  448034
  452093
  464329
  510443
  511733
  518248
  541728
  541749
  430204
  565277
  541751
  442726
  442332
  452092
  452131
  452519
  472237
  492322
  534316
  534334
  540441
  519318
  532164
  541712
  555798
  541634
  541656
  541773
  560195
  633158
  633166
  643113
  527000
  524613
  492565
  584481
  414946
  537251
  662020
  452018
  452082
  451983
  452097
  451929
  451940
  452053
  534288
  530726
  541748
  584703
  583533
  606748
  628398
  516029
  541651
  452109
  510557
  530478
  452034
  452048
  451951
  451974
  522191
  532499
  554568
  801907
  524324
  497865
  486938
  512058
  586594
  522035
  452084
  451957
  452014
  533426
  541638
  541780
  541630
  542193
  541740
  541774
  650155
  451928
  430621
  430635
  531481
  522975
  529290
  542189
  542192
  621858
  497452
  541632
  541647
  541721
  541646
]
2.90 ms
(2.08%)
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
  414946
  430204
  430621
  430635
  442332
  442726
  448034
  451928
  451929
  451940
  451951
  451957
  451974
  451983
  452014
  452018
  452034
  452048
  452053
  452082
  452084
  452092
  452093
  452097
  452109
  452131
  452519
  464329
  472237
  486938
  492322
  492565
  497452
  497865
  510443
  510557
  511733
  512058
  516029
  518248
  519318
  522035
  522191
  522975
  524324
  524613
  527000
  529290
  530478
  530726
  531481
  532164
  532499
  533426
  534288
  534316
  534334
  537251
  540441
  541630
  541632
  541634
  541638
  541646
  541647
  541651
  541656
  541712
  541721
  541728
  541740
  541748
  541749
  541751
  541773
  541774
  541780
  542189
  542192
  542193
  554568
  555798
  556415
  560195
  565277
  583533
  584481
  584703
  586594
  586674
  588283
  606748
  609783
  621858
  624502
  628398
  632565
  633130
  633158
  633166
  633176
  640710
  643113
  650155
  662020
  696233
  801907
]
2.16 ms
(1.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "full татуированные"
]
1.96 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "full tattoo"
]
1.81 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "full татуированные"
]

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.