Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.62 ms
(84.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
  6640
  382280
  384128
  389757
  391950
  394670
  398940
  399966
  400513
  404491
  411820
  413335
  413525
  415786
  419523
  421918
  422200
  425601
  428112
  433240
  433341
  433351
  433376
  439648
  439651
  439707
  439772
  439780
  439786
  439792
  440614
  440693
  440726
  441782
  441785
  441788
  442377
  442912
  443744
  444045
  454508
  454548
  457439
  457443
  457455
  457462
  459951
  466248
  468369
  470203
  472699
  473457
  477725
  478597
  480497
  484645
  486798
  487937
  488377
  494327
  494967
  495226
  497516
  498492
  506000
  507041
  509043
  509204
  514473
  515964
  516478
  517834
  521220
  523367
  523832
  524486
  536443
  537846
  549731
  549850
  551052
  552294
  555914
  558490
  563010
  563075
  563098
  565110
  583572
  588393
  589590
  628656
  632107
  641000
  658461
  695108
  696983
  697203
  701005
  707477
  724039
  724260
  727507
  728718
  730357
  733571
  741752
  741784
  744987
  745938
  747052
  765672
  788542
  795916
  796504
  799951
  826267
  826414
  826520
  826710
]
14.96 ms
(8.85%)
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
  443744
  454548
  497516
  506000
  478597
  555914
  552294
  558490
  563075
  549850
  563010
  583572
  632107
  433351
  439648
  439707
  457455
  421918
  433240
  433376
  399966
  457439
  516478
  523832
  495226
  494327
  494967
  498492
  524486
  384128
  389757
  404491
  413525
  433341
  411820
  428112
  826267
  486798
  472699
  457462
  487937
  488377
  507041
  515964
  523367
  537846
  459951
  549731
  565110
  707477
  788542
  741752
  741784
  745938
  799951
  744987
  382280
  468369
  466248
  480497
  398940
  454508
  400513
  415786
  457443
  521220
  441785
  826520
  826414
  724039
  727507
  391950
  826710
  517834
  701005
  695108
  658461
  551052
  588393
  641000
  724260
  747052
  765672
  728718
  730357
  733571
  795916
  796504
  394670
  440726
  439772
  439651
  473457
  563098
  589590
  419523
  422200
  439786
  440614
  440693
  470203
  477725
  439780
  439792
  442912
  442377
  444045
  509204
  509043
  536443
  484645
  514473
  6640
  413335
  441782
  441788
  425601
  696983
  697203
  628656
]
3.43 ms
(2.03%)
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
  6640
  382280
  384128
  389757
  391950
  394670
  398940
  399966
  400513
  404491
  411820
  413335
  413525
  415786
  419523
  421918
  422200
  425601
  428112
  433240
  433341
  433351
  433376
  439648
  439651
  439707
  439772
  439780
  439786
  439792
  440614
  440693
  440726
  441782
  441785
  441788
  442377
  442912
  443744
  444045
  454508
  454548
  457439
  457443
  457455
  457462
  459951
  466248
  468369
  470203
  472699
  473457
  477725
  478597
  480497
  484645
  486798
  487937
  488377
  494327
  494967
  495226
  497516
  498492
  506000
  507041
  509043
  509204
  514473
  515964
  516478
  517834
  521220
  523367
  523832
  524486
  536443
  537846
  549731
  549850
  551052
  552294
  555914
  558490
  563010
  563075
  563098
  565110
  583572
  588393
  589590
  628656
  632107
  641000
  658461
  695108
  696983
  697203
  701005
  707477
  724039
  724260
  727507
  728718
  730357
  733571
  741752
  741784
  744987
  745938
  747052
  765672
  788542
  795916
  796504
  799951
  826267
  826414
  826520
  826710
]
1.91 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby anal mature"
]
1.73 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby анал mature"
]
1.66 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby анал mature"
]

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.