Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.36 ms
(81.40%)
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
  33309
  188266
  387856
  394439
  398561
  400807
  412985
  420178
  426131
  439813
  445668
  450172
  452385
  453074
  453127
  453471
  454274
  454526
  455026
  455051
  455964
  456068
  459643
  460338
  460762
  462074
  462083
  462096
  462101
  462104
  462106
  462107
  462183
  462268
  462315
  462319
  462695
  463698
  465317
  465356
  465363
  466077
  466135
  467055
  468075
  470296
  470762
  470763
  470779
  471062
  472555
  476237
  476341
  477707
  478017
  478339
  478790
  480731
  481930
  485374
  485700
  485735
  485751
  485774
  485989
  486432
  486530
  486821
  489323
  489399
  493093
  498442
  498457
  509293
  513333
  514335
  514902
  515086
  516653
  518844
  518862
  518864
  518874
  521448
  524898
  525501
  526176
  526729
  527947
  529380
  531316
  534579
  537824
  541570
  542241
  543924
  545902
  549223
  549776
  551886
  552062
  554518
  571135
  573727
  578823
  597867
  610002
  615907
  618776
  628354
  628693
  629837
  710505
  744359
  748236
  784475
  790986
  807980
  808168
  810775
]
21.97 ms
(12.56%)
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
  472555
  628693
  485989
  710505
  455964
  498442
  462106
  476237
  478790
  453127
  188266
  456068
  552062
  394439
  498457
  460762
  471062
  398561
  478339
  529380
  462183
  744359
  462083
  465363
  476341
  516653
  454526
  629837
  463698
  462268
  450172
  808168
  551886
  518844
  465356
  527947
  466077
  790986
  514902
  470296
  618776
  485751
  439813
  412985
  420178
  545902
  459643
  549223
  462107
  610002
  480731
  537824
  486821
  518862
  466135
  478017
  534579
  549776
  486530
  468075
  509293
  462104
  455051
  531316
  515086
  462319
  541570
  454274
  467055
  470779
  784475
  526729
  485774
  518864
  810775
  493093
  597867
  615907
  485374
  543924
  489323
  542241
  453074
  452385
  387856
  628354
  400807
  470763
  33309
  462101
  462695
  455026
  470762
  521448
  460338
  445668
  524898
  526176
  514335
  518874
  807980
  453471
  571135
  748236
  465317
  485700
  554518
  462074
  462096
  525501
  462315
  477707
  485735
  426131
  486432
  573727
  481930
  513333
  578823
  489399
]
3.63 ms
(2.07%)
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
  33309
  188266
  387856
  394439
  398561
  400807
  412985
  420178
  426131
  439813
  445668
  450172
  452385
  453074
  453127
  453471
  454274
  454526
  455026
  455051
  455964
  456068
  459643
  460338
  460762
  462074
  462083
  462096
  462101
  462104
  462106
  462107
  462183
  462268
  462315
  462319
  462695
  463698
  465317
  465356
  465363
  466077
  466135
  467055
  468075
  470296
  470762
  470763
  470779
  471062
  472555
  476237
  476341
  477707
  478017
  478339
  478790
  480731
  481930
  485374
  485700
  485735
  485751
  485774
  485989
  486432
  486530
  486821
  489323
  489399
  493093
  498442
  498457
  509293
  513333
  514335
  514902
  515086
  516653
  518844
  518862
  518864
  518874
  521448
  524898
  525501
  526176
  526729
  527947
  529380
  531316
  534579
  537824
  541570
  542241
  543924
  545902
  549223
  549776
  551886
  552062
  554518
  571135
  573727
  578823
  597867
  610002
  615907
  618776
  628354
  628693
  629837
  710505
  744359
  748236
  784475
  790986
  807980
  808168
  810775
]
1.98 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "granny blowjob homemade"
]
1.80 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "granny минет оральн секс домашн любительск"
]
1.41 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "granny минет оральн секс домашн любительск"
]

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.