Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.76 ms
(84.72%)
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
  384593
  385137
  393424
  395705
  396456
  397548
  399195
  399889
  410147
  411184
  413299
  415897
  418375
  418578
  420133
  428724
  428977
  428987
  429906
  445568
  446780
  447150
  447152
  461624
  468712
  472246
  475472
  479689
  486301
  489005
  491673
  498619
  515070
  516429
  519079
  524763
  525222
  528901
  532340
  533216
  534269
  538361
  542681
  547570
  549519
  552998
  554387
  554704
  556203
  557931
  560474
  560487
  564000
  564583
  564784
  564799
  566282
  568150
  568560
  573384
  573530
  589200
  593128
  593775
  595025
  596659
  597441
  597547
  600587
  603833
  604063
  607728
  609870
  611265
  613778
  617308
  617825
  625206
  630569
  644078
  654132
  655121
  672335
  672588
  673074
  674400
  674688
  678980
  680260
  680743
  683587
  693166
  693935
  724050
  729933
  744790
  757442
  762594
  766818
  776988
  789887
  799008
  807243
  807606
  808046
  809238
  810191
  810967
  811511
  813471
  813914
  814046
  814657
  818282
  820336
  820346
  820422
  821120
  821201
  823527
]
14.16 ms
(8.77%)
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
  479689
  418578
  461624
  486301
  491673
  429906
  428987
  399195
  813914
  821120
  823527
  820336
  820422
  446780
  532340
  573530
  564784
  560474
  674688
  693935
  683587
  566282
  630569
  593128
  593775
  597441
  607728
  597547
  644078
  724050
  729933
  744790
  789887
  810191
  813471
  762594
  617825
  799008
  807243
  413299
  393424
  420133
  472246
  418375
  525222
  519079
  447152
  447150
  596659
  397548
  428724
  516429
  384593
  385137
  395705
  396456
  399889
  410147
  428977
  415897
  411184
  814657
  821201
  818282
  820346
  814046
  468712
  445568
  475472
  489005
  498619
  524763
  515070
  528901
  534269
  538361
  533216
  542681
  557931
  564583
  568150
  573384
  549519
  560487
  564799
  552998
  564000
  568560
  673074
  680743
  655121
  672588
  674400
  678980
  693166
  654132
  672335
  680260
  547570
  554387
  554704
  556203
  595025
  609870
  611265
  613778
  603833
  604063
  625206
  600587
  589200
  617308
  776988
  807606
  808046
  810967
  811511
  809238
  766818
  757442
]
2.92 ms
(1.81%)
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
  384593
  385137
  393424
  395705
  396456
  397548
  399195
  399889
  410147
  411184
  413299
  415897
  418375
  418578
  420133
  428724
  428977
  428987
  429906
  445568
  446780
  447150
  447152
  461624
  468712
  472246
  475472
  479689
  486301
  489005
  491673
  498619
  515070
  516429
  519079
  524763
  525222
  528901
  532340
  533216
  534269
  538361
  542681
  547570
  549519
  552998
  554387
  554704
  556203
  557931
  560474
  560487
  564000
  564583
  564784
  564799
  566282
  568150
  568560
  573384
  573530
  589200
  593128
  593775
  595025
  596659
  597441
  597547
  600587
  603833
  604063
  607728
  609870
  611265
  613778
  617308
  617825
  625206
  630569
  644078
  654132
  655121
  672335
  672588
  673074
  674400
  674688
  678980
  680260
  680743
  683587
  693166
  693935
  724050
  729933
  744790
  757442
  762594
  766818
  776988
  789887
  799008
  807243
  807606
  808046
  809238
  810191
  810967
  811511
  813471
  813914
  814046
  814657
  818282
  820336
  820346
  820422
  821120
  821201
  823527
]
2.21 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская худые"
]
1.92 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina skinny"
]
1.75 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.06%)
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.