Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.11 ms
(88.69%)
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
  398535
  464689
  479786
  486444
  490254
  491674
  491870
  496206
  497834
  505108
  506348
  510975
  512049
  513030
  514123
  514263
  514677
  516862
  517615
  518364
  518957
  519458
  519577
  521326
  521642
  523041
  523209
  524096
  524150
  524203
  524987
  525085
  525122
  525125
  526029
  526264
  526675
  527779
  528862
  529447
  534130
  537017
  537292
  538927
  540247
  541239
  542123
  542754
  543599
  546063
  546442
  551110
  556822
  557182
  557848
  558511
  561391
  565353
  567163
  568177
  569678
  571154
  571682
  571822
  571832
  573758
  573923
  575804
  576391
  576650
  576697
  578445
  578494
  578971
  579537
  585637
  586662
  587448
  588510
  588633
  590739
  592651
  593299
  593879
  595070
  597887
  598420
  599324
  600736
  603863
  605413
  605770
  608497
  616909
  618399
  620153
  622369
  625088
  625798
  630405
  652673
  660963
  661280
  680733
  681370
  685477
  694534
  704222
  720647
  736681
  743043
  765916
  778462
  779160
  784580
  799621
  821115
  824708
  827482
]
12.78 ms
(6.44%)
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
  608497
  514263
  541239
  497834
  526029
  514677
  565353
  593299
  599324
  605770
  524203
  579537
  523209
  529447
  595070
  600736
  576391
  597887
  784580
  743043
  567163
  464689
  521326
  527940
  542123
  571822
  685477
  557848
  561391
  573923
  578971
  603863
  585637
  592651
  622369
  625798
  680733
  524150
  588633
  514123
  525122
  588510
  519577
  527779
  506348
  523041
  578445
  576650
  652673
  546442
  618399
  491674
  543599
  537292
  528862
  518364
  576697
  505108
  571154
  661280
  513030
  521642
  526675
  542754
  571832
  571682
  525085
  534130
  512049
  517615
  575804
  569678
  558511
  660963
  616909
  625088
  491870
  540247
  546063
  630405
  821115
  799621
  720647
  779160
  765916
  519458
  524987
  524096
  556822
  573758
  605413
  490254
  590739
  578494
  496206
  537017
  557182
  598420
  479786
  568177
  551110
  586662
  587448
  704222
  398535
  736681
  778462
  526264
  525125
  694534
  620153
  593879
  824708
  827482
  538927
  518957
  510975
  681370
  486444
  516862
]
2.37 ms
(1.19%)
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
  398535
  464689
  479786
  486444
  490254
  491674
  491870
  496206
  497834
  505108
  506348
  510975
  512049
  513030
  514123
  514263
  514677
  516862
  517615
  518364
  518957
  519458
  519577
  521326
  521642
  523041
  523209
  524096
  524150
  524203
  524987
  525085
  525122
  525125
  526029
  526264
  526675
  527779
  528862
  529447
  534130
  537017
  537292
  538927
  540247
  541239
  542123
  542754
  543599
  546063
  546442
  551110
  556822
  557182
  557848
  558511
  561391
  565353
  567163
  568177
  569678
  571154
  571682
  571822
  571832
  573758
  573923
  575804
  576391
  576650
  576697
  578445
  578494
  578971
  579537
  585637
  586662
  587448
  588510
  588633
  590739
  592651
  593299
  593879
  595070
  597887
  598420
  599324
  600736
  603863
  605413
  605770
  608497
  616909
  618399
  620153
  622369
  625088
  625798
  630405
  652673
  660963
  661280
  680733
  681370
  685477
  694534
  704222
  720647
  736681
  743043
  765916
  778462
  779160
  784580
  799621
  821115
  824708
  827482
]
2.08 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "камшот сиськи"
]
1.93 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм сиськ"
]
1.59 ms
(0.80%)
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.