Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.98 ms
(84.47%)
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
  30703
  70636
  154692
  365978
  382815
  392572
  398307
  402563
  403162
  408435
  408447
  410855
  410872
  410874
  418434
  419991
  423337
  425654
  429482
  429545
  434933
  438208
  442685
  442754
  447007
  454969
  458329
  458784
  459025
  462554
  466091
  467668
  470522
  471500
  474297
  480047
  481021
  483359
  484330
  485420
  485750
  490452
  491424
  493458
  494448
  495436
  498326
  498621
  500249
  501005
  501916
  505659
  505940
  506339
  506755
  507763
  510420
  513133
  514011
  517924
  522922
  523746
  524121
  525586
  526385
  528800
  531770
  538784
  544248
  545725
  548738
  553616
  553687
  557951
  564656
  574051
  579940
  581518
  586431
  587918
  593603
  597884
  608336
  612387
  617124
  624377
  624550
  629461
  634004
  634223
  636329
  642221
  666376
  666429
  680308
  681777
  690923
  708888
  709939
  712664
  713407
  716268
  730060
  734217
  735003
  738182
  739933
  740703
  746854
  748082
  753240
  759854
  768731
  769555
  780878
  785585
  785897
  785997
  802038
  810375
]
12.93 ms
(8.96%)
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
  418434
  500249
  408435
  485420
  617124
  501916
  544248
  634223
  517924
  498326
  402563
  423337
  442685
  410874
  410855
  447007
  523746
  524121
  553687
  548738
  612387
  458784
  462554
  467668
  471500
  425654
  442754
  484330
  495436
  490452
  494448
  507763
  522922
  780878
  408447
  70636
  410872
  608336
  398307
  470522
  505659
  480047
  666429
  459025
  474297
  438208
  506339
  506755
  485750
  501005
  514011
  525586
  528800
  429545
  597884
  481021
  769555
  708888
  712664
  593603
  634004
  759854
  636329
  690923
  498621
  526385
  466091
  739933
  30703
  802038
  510420
  483359
  365978
  538784
  574051
  709939
  624377
  734217
  753240
  738182
  746854
  713407
  429482
  491424
  581518
  553616
  557951
  545725
  564656
  579940
  587918
  458329
  454969
  434933
  493458
  505940
  513133
  586431
  624550
  419991
  681777
  392572
  716268
  730060
  740703
  154692
  382815
  531770
  680308
  666376
  629461
  642221
  785897
  810375
  785997
  748082
  735003
  768731
  785585
  403162
]
2.40 ms
(1.66%)
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
  30703
  70636
  154692
  365978
  382815
  392572
  398307
  402563
  403162
  408435
  408447
  410855
  410872
  410874
  418434
  419991
  423337
  425654
  429482
  429545
  434933
  438208
  442685
  442754
  447007
  454969
  458329
  458784
  459025
  462554
  466091
  467668
  470522
  471500
  474297
  480047
  481021
  483359
  484330
  485420
  485750
  490452
  491424
  493458
  494448
  495436
  498326
  498621
  500249
  501005
  501916
  505659
  505940
  506339
  506755
  507763
  510420
  513133
  514011
  517924
  522922
  523746
  524121
  525586
  526385
  528800
  531770
  538784
  544248
  545725
  548738
  553616
  553687
  557951
  564656
  574051
  579940
  581518
  586431
  587918
  593603
  597884
  608336
  612387
  617124
  624377
  624550
  629461
  634004
  634223
  636329
  642221
  666376
  666429
  680308
  681777
  690923
  708888
  709939
  712664
  713407
  716268
  730060
  734217
  735003
  738182
  739933
  740703
  746854
  748082
  753240
  759854
  768731
  769555
  780878
  785585
  785897
  785997
  802038
  810375
]
2.16 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "подруга домашнее"
]
1.90 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подружк домашн любительск"
]
1.43 ms
(0.99%)
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.