Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.59 ms
(48.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy skirt"
]
189.73 ms
(45.00%)
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
  400508
  422511
  423675
  424411
  436074
  439301
  439326
  439695
  439736
  440139
  447412
  448083
  462346
  462930
  463016
  464835
  471515
  473505
  475483
  476223
  477339
  482737
  492170
  496554
  500366
  502315
  510891
  510908
  511678
  513844
  514413
  514715
  515705
  518750
  519248
  521102
  522111
  523833
  525064
  525669
  527142
  528535
  529216
  536938
  544150
  545819
  546370
  547658
  549248
  549255
  549682
  550744
  552664
  555429
  559095
  559725
  561944
  563098
  563456
  563852
  565322
  568078
  568382
  571198
  571244
  572273
  576629
  578399
  578703
  579795
  580125
  580256
  581616
  581806
  583139
  584637
  586009
  590408
  591378
  595256
  595454
  598545
  598609
  601935
  604205
  604873
  605058
  605372
  605398
  605639
  605746
  609729
  610628
  611500
  613282
  614743
  618787
  618823
  619165
  619308
  619423
  621355
  621980
  622987
  623920
  624935
  626136
  626448
  632569
  640690
  647090
  648575
  654322
  654464
  655087
  658281
  659115
  671104
  683508
  685791
]
19.45 ms
(4.61%)
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
  515705
  523833
  547658
  578399
  583139
  584637
  591378
  613282
  622987
  605746
  626448
  436074
  529216
  422511
  463016
  471515
  475483
  513844
  528535
  502315
  522111
  518750
  521102
  462930
  549682
  544150
  552664
  559095
  545819
  561944
  563098
  580125
  647090
  598609
  605639
  619165
  623920
  640690
  621355
  586009
  618787
  619423
  439301
  439326
  462346
  400508
  440139
  424411
  439695
  448083
  464835
  447412
  510908
  525669
  500366
  477339
  492170
  496554
  514715
  519248
  555429
  579795
  655087
  685791
  572273
  576629
  595256
  605372
  605058
  439736
  536938
  511678
  514413
  527142
  571198
  590408
  473505
  423675
  568078
  578703
  550744
  580256
  654464
  683508
  659115
  563456
  581806
  626136
  604205
  605398
  618823
  632569
  619308
  601935
  476223
  482737
  581616
  546370
  648575
  654322
  671104
  658281
  568382
  571244
  614743
  595454
  610628
  624935
  598545
  611500
  604873
  609729
  621980
  525064
  510891
  549248
  563852
  565322
  549255
  559725
]
2.45 ms
(0.58%)
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
  400508
  422511
  423675
  424411
  436074
  439301
  439326
  439695
  439736
  440139
  447412
  448083
  462346
  462930
  463016
  464835
  471515
  473505
  475483
  476223
  477339
  482737
  492170
  496554
  500366
  502315
  510891
  510908
  511678
  513844
  514413
  514715
  515705
  518750
  519248
  521102
  522111
  523833
  525064
  525669
  527142
  528535
  529216
  536938
  544150
  545819
  546370
  547658
  549248
  549255
  549682
  550744
  552664
  555429
  559095
  559725
  561944
  563098
  563456
  563852
  565322
  568078
  568382
  571198
  571244
  572273
  576629
  578399
  578703
  579795
  580125
  580256
  581616
  581806
  583139
  584637
  586009
  590408
  591378
  595256
  595454
  598545
  598609
  601935
  604205
  604873
  605058
  605372
  605398
  605639
  605746
  609729
  610628
  611500
  613282
  614743
  618787
  618823
  619165
  619308
  619423
  621355
  621980
  622987
  623920
  624935
  626136
  626448
  632569
  640690
  647090
  648575
  654322
  654464
  655087
  658281
  659115
  671104
  683508
  685791
]
1.86 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак юбк"
]
1.80 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак юбк"
]
1.78 ms
(0.42%)
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.