Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.79 ms
(88.73%)
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
  209931
  407538
  409121
  411131
  414849
  415928
  418707
  420266
  423928
  429239
  431316
  456411
  456883
  459156
  460724
  473099
  477763
  486147
  486970
  489087
  495623
  497130
  498880
  501475
  508924
  512932
  516138
  522306
  524618
  527309
  534719
  539086
  540637
  541783
  545740
  546809
  546829
  550333
  551227
  555462
  555607
  559414
  572108
  572403
  572424
  572682
  576326
  584378
  592451
  606097
  609567
  611366
  614244
  619650
  625774
  629695
  631743
  631762
  644296
  649832
  651479
  660270
  663938
  665287
  665789
  667360
  670761
  681187
  682763
  685935
  688047
  695270
  705712
  707323
  707981
  709489
  710536
  714007
  722158
  728984
  732184
  738010
  746125
  747950
  752918
  752940
  753761
  758268
  768013
  769004
  770146
  772454
  788245
  789686
  792412
  794413
  794535
  795353
  797459
  802255
  802641
  802874
  804368
  806958
  808642
  813598
  813726
  814162
  814761
  817498
  818620
  818884
  818991
  819095
  822797
  823030
  823078
  826163
  826842
]
13.00 ms
(6.68%)
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
  813598
  539086
  546829
  649832
  665287
  682763
  710536
  681187
  714007
  707323
  707981
  631762
  802255
  770146
  806958
  752918
  738010
  802641
  576326
  407538
  508924
  414849
  418707
  456883
  524618
  555462
  555607
  758268
  431316
  512932
  794413
  545740
  572682
  722158
  559414
  629695
  606097
  794535
  732184
  728984
  795353
  415928
  473099
  498880
  516138
  477763
  705712
  651479
  746125
  769004
  792412
  804368
  486970
  584378
  489087
  527309
  753761
  486147
  663938
  459156
  823030
  540637
  550333
  670761
  619650
  614244
  611366
  592451
  797459
  752940
  644296
  411131
  497130
  495623
  572108
  551227
  768013
  423928
  429239
  420266
  501475
  209931
  409121
  814162
  814761
  817498
  818991
  822797
  826163
  819095
  826842
  818884
  813726
  818620
  823078
  828024
  456411
  460724
  534719
  522306
  541783
  572403
  685935
  688047
  667360
  695270
  709489
  660270
  665789
  546809
  572424
  631743
  609567
  625774
  789686
  808642
  747950
  772454
  788245
  802874
]
2.47 ms
(1.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
  209931
  407538
  409121
  411131
  414849
  415928
  418707
  420266
  423928
  429239
  431316
  456411
  456883
  459156
  460724
  473099
  477763
  486147
  486970
  489087
  495623
  497130
  498880
  501475
  508924
  512932
  516138
  522306
  524618
  527309
  534719
  539086
  540637
  541783
  545740
  546809
  546829
  550333
  551227
  555462
  555607
  559414
  572108
  572403
  572424
  572682
  576326
  584378
  592451
  606097
  609567
  611366
  614244
  619650
  625774
  629695
  631743
  631762
  644296
  649832
  651479
  660270
  663938
  665287
  665789
  667360
  670761
  681187
  682763
  685935
  688047
  695270
  705712
  707323
  707981
  709489
  710536
  714007
  722158
  728984
  732184
  738010
  746125
  747950
  752918
  752940
  753761
  758268
  768013
  769004
  770146
  772454
  788245
  789686
  792412
  794413
  794535
  795353
  797459
  802255
  802641
  802874
  804368
  806958
  808642
  813598
  813726
  814162
  814761
  817498
  818620
  818884
  818991
  819095
  822797
  823030
  823078
  826163
  826842
]
1.82 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public hairy pussy"
]
1.60 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц волосатая pussy"
]
1.58 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц волосатая pussy"
]
1.48 ms
(0.76%)
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.