Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.82 ms
(86.64%)
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
  17066
  20180
  382280
  389093
  395701
  401134
  411615
  412756
  414646
  414778
  419872
  421519
  422237
  422710
  422909
  423000
  423040
  423767
  427383
  428302
  441004
  443465
  445903
  447103
  452018
  452095
  457406
  459366
  461620
  463118
  463919
  463948
  466801
  468718
  470211
  479836
  484069
  484483
  486485
  486534
  493255
  494695
  496524
  500686
  501831
  510756
  519592
  523367
  524706
  530690
  531488
  534317
  536675
  536743
  537184
  540434
  542864
  543659
  543858
  544206
  544840
  545409
  545519
  547605
  554321
  554370
  558040
  562491
  564407
  565156
  565163
  565254
  566819
  567338
  576393
  580646
  581349
  582179
  583507
  588264
  588818
  597272
  600237
  602607
  606721
  608431
  611567
  617165
  623011
  624173
  624504
  626553
  633801
  637123
  642043
  647898
  648257
  677698
  679810
  680108
  680116
  680255
  685055
  697025
  701051
  702621
  718710
  720186
  731869
  742798
  761088
  762257
  766807
  770124
  798671
  800563
  811630
  811826
  811872
  814235
]
15.80 ms
(8.36%)
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
  544206
  582179
  597272
  623011
  395701
  463948
  534317
  680108
  697025
  770124
  718710
  422237
  428302
  766807
  617165
  531488
  543659
  565156
  811826
  486485
  470211
  761088
  648257
  452095
  484069
  611567
  419872
  447103
  468718
  633801
  421519
  554321
  685055
  720186
  606721
  798671
  762257
  701051
  811630
  389093
  423040
  814235
  445903
  565163
  565254
  581349
  562491
  679810
  680255
  680116
  545519
  642043
  484483
  494695
  530690
  537184
  543858
  544840
  542864
  608431
  637123
  510756
  463919
  540434
  576393
  422710
  452018
  567338
  461620
  536743
  457406
  414778
  493255
  580646
  545409
  624173
  422909
  459366
  523367
  558040
  811872
  382280
  443465
  423767
  20180
  411615
  441004
  17066
  463118
  800563
  731869
  401134
  566819
  412756
  677698
  486534
  554370
  588264
  524706
  423000
  626553
  742798
  427383
  466801
  496524
  547605
  414646
  479836
  501831
  564407
  583507
  647898
  624504
  519592
  536675
  702621
  588818
  600237
  500686
  602607
]
3.07 ms
(1.62%)
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
  17066
  20180
  382280
  389093
  395701
  401134
  411615
  412756
  414646
  414778
  419872
  421519
  422237
  422710
  422909
  423000
  423040
  423767
  427383
  428302
  441004
  443465
  445903
  447103
  452018
  452095
  457406
  459366
  461620
  463118
  463919
  463948
  466801
  468718
  470211
  479836
  484069
  484483
  486485
  486534
  493255
  494695
  496524
  500686
  501831
  510756
  519592
  523367
  524706
  530690
  531488
  534317
  536675
  536743
  537184
  540434
  542864
  543659
  543858
  544206
  544840
  545409
  545519
  547605
  554321
  554370
  558040
  562491
  564407
  565156
  565163
  565254
  566819
  567338
  576393
  580646
  581349
  582179
  583507
  588264
  588818
  597272
  600237
  602607
  606721
  608431
  611567
  617165
  623011
  624173
  624504
  626553
  633801
  637123
  642043
  647898
  648257
  677698
  679810
  680108
  680116
  680255
  685055
  697025
  701051
  702621
  718710
  720186
  731869
  742798
  761088
  762257
  766807
  770124
  798671
  800563
  811630
  811826
  811872
  814235
]
1.79 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small young anal"
]
1.63 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая young анал"
]
1.38 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая young анал"
]

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.