Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
357.95 ms
(60.79%)
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
  95943
  188699
  321460
  384804
  389593
  391539
  397425
  397671
  400430
  401965
  403754
  414184
  423845
  434582
  443123
  445480
  453085
  455221
  455832
  456650
  459158
  460868
  469503
  469900
  472038
  472768
  473268
  475516
  475971
  476535
  476547
  477156
  477693
  479482
  480620
  481318
  481774
  483412
  483428
  484089
  485463
  487093
  487917
  489679
  489697
  492559
  495977
  496926
  503313
  506492
  511066
  512136
  514953
  519385
  522261
  522864
  525082
  527281
  527318
  537292
  542832
  543133
  543603
  546439
  546747
  548058
  551189
  551193
  554649
  555233
  557402
  559150
  559247
  562149
  562607
  563650
  565353
  565394
  567235
  568871
  572949
  574659
  576197
  576698
  576722
  578581
  589833
  591202
  591289
  593812
  598884
  604278
  610972
  617021
  619823
  620898
  624859
  625607
  626139
  626915
  655601
  658935
  661281
  669233
  673925
  685389
  705715
  705729
  705781
  705812
  709938
  712672
  719849
  722575
  725262
  752800
  774095
  778949
  785418
  788102
]
207.71 ms
(35.27%)
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
  95943
  188699
  321460
  384804
  389593
  391539
  397425
  397671
  400430
  401965
  403754
  414184
  423845
  434582
  443123
  445480
  453085
  455221
  455832
  456650
  459158
  460868
  469503
  469900
  472038
  472768
  473268
  475516
  475971
  476535
  476547
  477156
  477693
  479482
  480620
  481318
  481774
  483412
  483428
  484089
  485463
  487093
  487917
  489679
  489697
  492559
  495977
  496926
  503313
  506492
  511066
  512136
  514953
  519385
  522261
  522864
  525082
  527281
  527318
  537292
  542832
  543133
  543603
  546439
  546747
  548058
  551189
  551193
  554649
  555233
  557402
  559150
  559247
  562149
  562607
  563650
  565353
  565394
  567235
  568871
  572949
  574659
  576197
  576698
  576722
  578581
  589833
  591202
  591289
  593812
  598884
  604278
  610972
  617021
  619823
  620898
  624859
  625607
  626139
  626915
  655601
  658935
  661281
  669233
  673925
  685389
  705715
  705729
  705781
  705812
  709938
  712672
  719849
  722575
  725262
  752800
  774095
  778949
  785418
  788102
]
16.06 ms
(2.73%)
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
  389593
  591202
  565353
  514953
  453085
  543133
  554649
  619823
  414184
  574659
  598884
  778949
  576698
  626915
  572949
  476535
  477156
  512136
  576722
  661281
  489697
  555233
  568871
  658935
  593812
  95943
  489679
  527281
  685389
  543603
  551193
  562149
  610972
  423845
  620898
  722575
  705729
  589833
  617021
  475516
  472038
  469900
  548058
  546439
  456650
  527318
  321460
  511066
  384804
  391539
  673925
  472768
  506492
  559150
  476547
  455832
  477693
  496926
  469503
  522261
  655601
  719849
  725262
  788102
  752800
  774095
  785418
  522864
  559247
  578581
  705715
  705812
  525082
  403754
  519385
  624859
  591289
  400430
  563650
  401965
  480620
  485463
  487917
  546747
  625607
  483428
  542832
  626139
  397671
  397425
  479482
  434582
  483412
  551189
  565394
  567235
  443123
  484089
  492559
  562607
  669233
  709938
  473268
  459158
  445480
  495977
  481318
  481774
  503313
  537292
  475971
  487093
  188699
  460868
  576197
  557402
  705781
  712672
  604278
  455221
]
1.92 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "forest blowjob"
]
1.86 ms
(0.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лес природ минет оральн секс"
]
1.79 ms
(0.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.26%)
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.