Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.15 ms
(83.60%)
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
  150470
  263759
  321277
  382207
  386896
  391327
  414269
  419167
  420140
  420383
  420394
  421133
  427364
  427722
  432673
  432680
  438880
  439427
  443233
  446778
  448351
  449586
  449930
  454800
  457650
  465680
  467563
  467568
  467579
  467585
  467616
  467633
  467986
  471127
  473873
  475426
  476847
  482190
  499856
  503861
  511953
  514886
  515364
  515559
  516640
  518185
  518550
  518884
  521435
  521682
  525431
  525468
  526179
  526943
  527508
  528104
  531804
  532856
  534257
  540531
  554551
  566784
  571975
  580504
  592593
  592681
  595683
  596288
  598310
  601071
  619322
  623300
  626044
  631203
  639791
  640859
  641972
  660757
  667276
  678707
  679270
  728567
  738446
  738471
  738496
  739145
  740492
  742323
  742359
  743455
  749248
  753124
  756752
  757427
  760862
  766415
  772617
  782281
  784398
  790154
  796509
  796640
  796696
  796715
  796801
  797003
  800031
  807590
  808168
  808235
  808265
  808998
  811125
  812779
  813801
  814024
  816235
  816547
  817875
  826278
]
18.95 ms
(10.84%)
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
  580504
  595683
  808235
  473873
  420394
  641972
  796696
  465680
  826278
  321277
  263759
  420383
  813801
  814024
  816235
  467579
  532856
  526943
  540531
  534257
  678707
  596288
  639791
  592593
  598310
  601071
  796715
  790154
  796509
  797003
  753124
  772617
  784398
  812779
  728567
  738446
  743455
  760862
  742359
  640859
  782281
  528104
  554551
  811125
  467585
  518550
  391327
  516640
  471127
  626044
  438880
  432680
  525468
  467616
  467633
  808998
  382207
  526179
  619322
  150470
  432673
  448351
  796640
  518884
  482190
  475426
  446778
  427364
  679270
  419167
  457650
  592681
  807590
  808265
  766415
  739145
  738496
  443233
  521435
  420140
  660757
  623300
  454800
  439427
  467568
  531804
  386896
  421133
  467563
  476847
  449930
  511953
  527508
  514886
  521682
  427722
  816547
  571975
  518185
  631203
  525431
  414269
  817875
  449586
  467986
  515364
  499856
  503861
  515559
  667276
  566784
  796801
  800031
  808168
  738471
  740492
  742323
  756752
  757427
  749248
]
2.83 ms
(1.62%)
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
  150470
  263759
  321277
  382207
  386896
  391327
  414269
  419167
  420140
  420383
  420394
  421133
  427364
  427722
  432673
  432680
  438880
  439427
  443233
  446778
  448351
  449586
  449930
  454800
  457650
  465680
  467563
  467568
  467579
  467585
  467616
  467633
  467986
  471127
  473873
  475426
  476847
  482190
  499856
  503861
  511953
  514886
  515364
  515559
  516640
  518185
  518550
  518884
  521435
  521682
  525431
  525468
  526179
  526943
  527508
  528104
  531804
  532856
  534257
  540531
  554551
  566784
  571975
  580504
  592593
  592681
  595683
  596288
  598310
  601071
  619322
  623300
  626044
  631203
  639791
  640859
  641972
  660757
  667276
  678707
  679270
  728567
  738446
  738471
  738496
  739145
  740492
  742323
  742359
  743455
  749248
  753124
  756752
  757427
  760862
  766415
  772617
  782281
  784398
  790154
  796509
  796640
  796696
  796715
  796801
  797003
  800031
  807590
  808168
  808235
  808265
  808998
  811125
  812779
  813801
  814024
  816235
  816547
  817875
  826278
]
1.89 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные дилд жоп"
]
1.83 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные дилд жоп"
]
1.60 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge dildo ass"
]
1.57 ms
(0.90%)
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.