Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.95 ms
(80.74%)
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
  88410
  396640
  401904
  416192
  418135
  419783
  419816
  421678
  430709
  446641
  448575
  448825
  450410
  452014
  454754
  461438
  470064
  471115
  476649
  479669
  481142
  484278
  487721
  494006
  495558
  495559
  495793
  496585
  511313
  522284
  522307
  526164
  527915
  529054
  529792
  530479
  531123
  531252
  533049
  534381
  536248
  536388
  536645
  537203
  537236
  540348
  541423
  541863
  543840
  545488
  550672
  555121
  556045
  569359
  572777
  579523
  582314
  586407
  587085
  591692
  594534
  600218
  600317
  600337
  603725
  605333
  613843
  617424
  620223
  620901
  623262
  628334
  632628
  633813
  634780
  639326
  639741
  640751
  641956
  644327
  644913
  646176
  647307
  647972
  648861
  649514
  668505
  672686
  676023
  676088
  677676
  678117
  683261
  694415
  700257
  714562
  720287
  722264
  722692
  724194
  737082
  743383
  751452
  758216
  763724
  777843
  782633
  784054
  786120
  791916
  795393
  795690
  808988
  814924
  815270
  815396
  818532
  821877
  823607
  826672
]
19.05 ms
(12.31%)
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
  487721
  613843
  633813
  758216
  529792
  623262
  481142
  541863
  678117
  676088
  668505
  676023
  677676
  556045
  628334
  600337
  641956
  617424
  640751
  88410
  786120
  826672
  821877
  815270
  815396
  818532
  823607
  479669
  526164
  555121
  572777
  541423
  722264
  700257
  722692
  672686
  569359
  582314
  587085
  620901
  594534
  644327
  782633
  795393
  795690
  808988
  737082
  724194
  751452
  605333
  714562
  791916
  454754
  529054
  639741
  470064
  579523
  536645
  534381
  763724
  522284
  531252
  648861
  591692
  603725
  396640
  401904
  496585
  536388
  600317
  418135
  530479
  720287
  694415
  586407
  639326
  743383
  446641
  461438
  419816
  484278
  537203
  511313
  777843
  494006
  683261
  419783
  448825
  452014
  537236
  531123
  543840
  545488
  634780
  421678
  620223
  522307
  450410
  430709
  495558
  495793
  784054
  527915
  471115
  476649
  495559
  416192
  448575
  644913
  536248
  647972
  646176
  647307
  649514
  600218
  632628
  814924
  533049
  540348
  550672
]
2.31 ms
(1.49%)
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
  88410
  396640
  401904
  416192
  418135
  419783
  419816
  421678
  430709
  446641
  448575
  448825
  450410
  452014
  454754
  461438
  470064
  471115
  476649
  479669
  481142
  484278
  487721
  494006
  495558
  495559
  495793
  496585
  511313
  522284
  522307
  526164
  527915
  529054
  529792
  530479
  531123
  531252
  533049
  534381
  536248
  536388
  536645
  537203
  537236
  540348
  541423
  541863
  543840
  545488
  550672
  555121
  556045
  569359
  572777
  579523
  582314
  586407
  587085
  591692
  594534
  600218
  600317
  600337
  603725
  605333
  613843
  617424
  620223
  620901
  623262
  628334
  632628
  633813
  634780
  639326
  639741
  640751
  641956
  644327
  644913
  646176
  647307
  647972
  648861
  649514
  668505
  672686
  676023
  676088
  677676
  678117
  683261
  694415
  700257
  714562
  720287
  722264
  722692
  724194
  737082
  743383
  751452
  758216
  763724
  777843
  782633
  784054
  786120
  791916
  795393
  795690
  808988
  814924
  815270
  815396
  818532
  821877
  823607
  826672
]
2.22 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty anal dildo"
]
2.17 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty анал дилд"
]
2.07 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty анал дилд"
]

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.