Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.76 ms
(86.03%)
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
  265677
  381863
  382898
  384162
  418069
  429518
  446171
  447029
  452854
  463973
  465431
  466934
  467089
  476692
  479867
  494546
  499391
  501374
  506057
  520179
  528608
  530924
  531051
  532423
  535159
  539564
  541847
  541855
  545349
  547766
  556471
  556971
  567718
  579396
  581873
  589444
  590084
  592584
  593325
  596033
  597645
  601049
  601553
  602258
  603385
  604426
  607533
  607782
  609644
  616258
  620647
  622160
  628518
  628537
  631321
  636444
  639282
  641252
  645928
  649300
  650264
  651648
  668694
  675444
  681355
  696480
  697473
  697543
  697718
  705424
  708698
  711651
  716000
  716241
  720545
  726946
  742063
  742351
  747771
  749999
  751310
  752221
  754731
  757496
  757521
  758279
  766270
  770169
  770190
  770226
  772547
  772549
  772584
  772644
  778151
  782079
  782135
  782152
  782541
  783008
  785396
  785552
  785967
  786470
  787342
  787469
  794727
  796845
  797000
  800799
  801545
  803104
  806928
  806955
  807424
  808319
  808979
  819223
  821808
  826498
]
14.70 ms
(8.28%)
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
  651648
  447029
  452854
  593325
  418069
  506057
  528608
  597645
  499391
  826498
  821808
  531051
  535159
  567718
  541847
  645928
  720545
  697473
  697718
  668694
  697543
  596033
  628518
  603385
  785967
  794727
  782541
  806955
  808979
  770169
  772547
  772584
  806928
  747771
  754731
  770190
  772549
  758279
  609644
  711651
  778151
  782079
  783008
  787342
  797000
  384162
  601049
  696480
  616258
  620647
  631321
  786470
  742351
  766270
  726946
  749999
  446171
  501374
  601553
  785552
  556471
  581873
  494546
  579396
  602258
  628537
  466934
  479867
  530924
  532423
  545349
  541855
  708698
  649300
  650264
  681355
  589444
  622160
  641252
  590084
  592584
  636444
  639282
  807424
  782135
  772644
  782152
  787469
  801545
  742063
  757496
  757521
  751310
  607533
  607782
  796845
  803104
  716000
  467089
  556971
  705424
  429518
  604426
  675444
  465431
  382898
  520179
  476692
  800799
  539564
  808319
  770226
  265677
  381863
  819223
  716241
  785396
  752221
  463973
  547766
]
2.59 ms
(1.46%)
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
  265677
  381863
  382898
  384162
  418069
  429518
  446171
  447029
  452854
  463973
  465431
  466934
  467089
  476692
  479867
  494546
  499391
  501374
  506057
  520179
  528608
  530924
  531051
  532423
  535159
  539564
  541847
  541855
  545349
  547766
  556471
  556971
  567718
  579396
  581873
  589444
  590084
  592584
  593325
  596033
  597645
  601049
  601553
  602258
  603385
  604426
  607533
  607782
  609644
  616258
  620647
  622160
  628518
  628537
  631321
  636444
  639282
  641252
  645928
  649300
  650264
  651648
  668694
  675444
  681355
  696480
  697473
  697543
  697718
  705424
  708698
  711651
  716000
  716241
  720545
  726946
  742063
  742351
  747771
  749999
  751310
  752221
  754731
  757496
  757521
  758279
  766270
  770169
  770190
  770226
  772547
  772549
  772584
  772644
  778151
  782079
  782135
  782152
  782541
  783008
  785396
  785552
  785967
  786470
  787342
  787469
  794727
  796845
  797000
  800799
  801545
  803104
  806928
  806955
  807424
  808319
  808979
  819223
  821808
  826498
]
1.98 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел соло жоп"
]
1.97 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties solo ass"
]
1.94 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел соло жоп"
]
1.62 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.