Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.34 ms
(88.44%)
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
  400571
  412852
  414662
  421993
  432824
  432974
  434443
  443233
  443251
  443317
  448031
  452815
  452824
  454793
  459170
  462840
  466476
  469125
  469451
  470412
  471129
  471335
  473450
  475920
  477502
  486772
  493763
  494530
  500263
  500333
  505093
  511864
  512072
  514257
  516640
  518505
  526061
  531578
  531844
  531891
  534114
  534443
  534537
  535438
  538045
  541377
  541451
  542124
  545438
  548153
  548454
  548834
  550895
  550916
  553130
  553646
  556871
  559783
  560269
  567120
  575589
  576848
  578731
  579673
  583694
  586995
  587292
  588466
  588514
  589042
  591884
  594053
  596610
  598882
  601367
  602241
  607683
  607685
  608869
  619322
  626044
  631740
  634071
  634750
  641806
  658802
  665958
  678707
  687347
  697543
  709542
  720200
  722428
  740523
  743455
  744033
  749067
  749264
  752603
  752652
  752681
  752712
  752753
  752921
  757434
  758163
  766941
  770262
  784066
  784310
  785816
  785979
  788939
  789436
  792706
  808068
  811723
  813487
  824340
  827395
]
14.44 ms
(7.04%)
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
  576848
  619322
  626044
  432824
  432974
  421993
  709542
  470412
  462840
  486772
  475920
  531891
  534443
  687347
  607683
  634750
  785816
  784310
  813487
  740523
  811723
  758163
  766941
  784066
  785979
  789436
  792706
  448031
  594053
  641806
  471335
  514257
  545438
  749264
  752753
  827395
  678707
  443317
  443251
  477502
  454793
  512072
  511864
  500333
  516640
  531578
  505093
  567120
  471129
  631740
  607685
  808068
  534114
  534537
  722428
  548153
  587292
  598882
  743455
  434443
  575589
  634071
  443233
  459170
  400571
  412852
  414662
  469451
  473450
  493763
  452824
  500263
  531844
  535438
  538045
  542124
  560269
  583694
  541451
  550895
  553646
  559783
  556871
  591884
  602241
  608869
  588514
  601367
  586995
  596610
  744033
  469125
  466476
  452815
  494530
  518505
  526061
  824340
  550916
  541377
  548454
  548834
  658802
  720200
  665958
  697543
  553130
  578731
  579673
  588466
  589042
  788939
  752603
  752681
  752921
  757434
  749067
  752652
  752712
  770262
]
2.53 ms
(1.23%)
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
  400571
  412852
  414662
  421993
  432824
  432974
  434443
  443233
  443251
  443317
  448031
  452815
  452824
  454793
  459170
  462840
  466476
  469125
  469451
  470412
  471129
  471335
  473450
  475920
  477502
  486772
  493763
  494530
  500263
  500333
  505093
  511864
  512072
  514257
  516640
  518505
  526061
  531578
  531844
  531891
  534114
  534443
  534537
  535438
  538045
  541377
  541451
  542124
  545438
  548153
  548454
  548834
  550895
  550916
  553130
  553646
  556871
  559783
  560269
  567120
  575589
  576848
  578731
  579673
  583694
  586995
  587292
  588466
  588514
  589042
  591884
  594053
  596610
  598882
  601367
  602241
  607683
  607685
  608869
  619322
  626044
  631740
  634071
  634750
  641806
  658802
  665958
  678707
  687347
  697543
  709542
  720200
  722428
  740523
  743455
  744033
  749067
  749264
  752603
  752652
  752681
  752712
  752753
  752921
  757434
  758163
  766941
  770262
  784066
  784310
  785816
  785979
  788939
  789436
  792706
  808068
  811723
  813487
  824340
  827395
]
2.08 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge dildo homemade"
]
1.59 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные дилд домашн любительск"
]
1.59 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.71%)
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.