Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.16 ms
(81.98%)
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
  383643
  425486
  428532
  453472
  453746
  462370
  464219
  472396
  472778
  475454
  476721
  477049
  477073
  477131
  481679
  487479
  493307
  495737
  496686
  496772
  499207
  499485
  503996
  506783
  510024
  512340
  512459
  512687
  512923
  513125
  518919
  521613
  521750
  521773
  522576
  524618
  525176
  525273
  526026
  526909
  526961
  527280
  529322
  529545
  529551
  530610
  530713
  531133
  533195
  533932
  534757
  535261
  537240
  537912
  538624
  540073
  540690
  541890
  542369
  542422
  542945
  543179
  543595
  543867
  546830
  546838
  546856
  546857
  546936
  549287
  549391
  549922
  551041
  551044
  551049
  551063
  551535
  551984
  555264
  557391
  558819
  560281
  562884
  566563
  569423
  569698
  569742
  571671
  571998
  573230
  574421
  577970
  578492
  585366
  591565
  591590
  594896
  595789
  598125
  600501
  602099
  619204
  621387
  622345
  624229
  626376
  626872
  629730
  629886
  631503
  638416
  649147
  650350
  650793
  666532
  710403
  732917
  733364
  804487
  806113
]
16.92 ms
(11.54%)
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
  526909
  526961
  534757
  540690
  496772
  499207
  503996
  506783
  512459
  513125
  518919
  522576
  525176
  525273
  527280
  529322
  530610
  530713
  531133
  533932
  537240
  538624
  540073
  495737
  496686
  499485
  510024
  512340
  512687
  512923
  521613
  521750
  521773
  524618
  526026
  529545
  529551
  533195
  535261
  537912
  462370
  464219
  472396
  472778
  477049
  477073
  487479
  493307
  542422
  542945
  543595
  546838
  549287
  549922
  551041
  551984
  555264
  557391
  558819
  569742
  542369
  543179
  546936
  551044
  566563
  569423
  574421
  541890
  543867
  546830
  546856
  549391
  551535
  560281
  569698
  573230
  649147
  650350
  666532
  650793
  546857
  551049
  551063
  562884
  571671
  571998
  577970
  578492
  621387
  624229
  629730
  585366
  622345
  626376
  626872
  638416
  594896
  595789
  600501
  619204
  629886
  631503
  591565
  591590
  598125
  804487
  806113
  732917
  733364
  602099
  710403
  383643
  453472
  453746
  475454
  476721
  477131
  481679
  425486
  428532
]
2.45 ms
(1.67%)
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
  383643
  425486
  428532
  453472
  453746
  462370
  464219
  472396
  472778
  475454
  476721
  477049
  477073
  477131
  481679
  487479
  493307
  495737
  496686
  496772
  499207
  499485
  503996
  506783
  510024
  512340
  512459
  512687
  512923
  513125
  518919
  521613
  521750
  521773
  522576
  524618
  525176
  525273
  526026
  526909
  526961
  527280
  529322
  529545
  529551
  530610
  530713
  531133
  533195
  533932
  534757
  535261
  537240
  537912
  538624
  540073
  540690
  541890
  542369
  542422
  542945
  543179
  543595
  543867
  546830
  546838
  546856
  546857
  546936
  549287
  549391
  549922
  551041
  551044
  551049
  551063
  551535
  551984
  555264
  557391
  558819
  560281
  562884
  566563
  569423
  569698
  569742
  571671
  571998
  573230
  574421
  577970
  578492
  585366
  591565
  591590
  594896
  595789
  598125
  600501
  602099
  619204
  621387
  622345
  624229
  626376
  626872
  629730
  629886
  631503
  638416
  649147
  650350
  650793
  666532
  710403
  732917
  733364
  804487
  806113
]
1.93 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf domination"
]
1.78 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf domination"
]
1.73 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf domination"
]

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.