Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.70 ms
(81.99%)
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
  21575
  249926
  318892
  393233
  396273
  414635
  416367
  418422
  420629
  421627
  422629
  425875
  438889
  443305
  443599
  443699
  445237
  446252
  446461
  447650
  447809
  447919
  448760
  451700
  453228
  455140
  456909
  459228
  459801
  460769
  460770
  461617
  462123
  463839
  464177
  465152
  465741
  466022
  466588
  468462
  468585
  468597
  470238
  470446
  470530
  470764
  471359
  472592
  473058
  473079
  473771
  474011
  474380
  474585
  476421
  478873
  479197
  480807
  482929
  484842
  484849
  485461
  487038
  488700
  489050
  489507
  489566
  491195
  491585
  491640
  494499
  495358
  497039
  497067
  499782
  500926
  502292
  502678
  505952
  506387
  508043
  510436
  510510
  512576
  516743
  517692
  518982
  520949
  522599
  523703
  527607
  533394
  536674
  537577
  539396
  540304
  540334
  540422
  540574
  540788
  541099
  546662
  549979
  559912
  693847
  709919
  729626
  730715
  738245
  741980
  778239
  799980
  804704
  810850
  811863
  817451
  828058
]
16.19 ms
(10.73%)
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
  522599
  527607
  478873
  709919
  730715
  729626
  738245
  393233
  396273
  443305
  470238
  21575
  443699
  455140
  474011
  422629
  447919
  459801
  465152
  465741
  468585
  470446
  473058
  470530
  470764
  516743
  494499
  500926
  517692
  482929
  489507
  495358
  512576
  502678
  693847
  485461
  540574
  823062
  533394
  537577
  546662
  540788
  539396
  799980
  810850
  741980
  823105
  822348
  828058
  510510
  549979
  778239
  804704
  249926
  438889
  443599
  421627
  416367
  420629
  817451
  446252
  487038
  491195
  491585
  453228
  460770
  473771
  446461
  466588
  474585
  497039
  520949
  540334
  540422
  497067
  536674
  518982
  540304
  472592
  489050
  541099
  559912
  811863
  414635
  425875
  447809
  448760
  456909
  459228
  460769
  476421
  480807
  447650
  463839
  471359
  473079
  474380
  418422
  461617
  318892
  462123
  468462
  479197
  445237
  451700
  464177
  466022
  468597
  523703
  484842
  499782
  505952
  508043
  484849
  488700
  489566
  491640
  502292
  506387
  510436
]
3.15 ms
(2.09%)
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
  21575
  249926
  318892
  393233
  396273
  414635
  416367
  418422
  420629
  421627
  422629
  425875
  438889
  443305
  443599
  443699
  445237
  446252
  446461
  447650
  447809
  447919
  448760
  451700
  453228
  455140
  456909
  459228
  459801
  460769
  460770
  461617
  462123
  463839
  464177
  465152
  465741
  466022
  466588
  468462
  468585
  468597
  470238
  470446
  470530
  470764
  471359
  472592
  473058
  473079
  473771
  474011
  474380
  474585
  476421
  478873
  479197
  480807
  482929
  484842
  484849
  485461
  487038
  488700
  489050
  489507
  489566
  491195
  491585
  491640
  494499
  495358
  497039
  497067
  499782
  500926
  502292
  502678
  505952
  506387
  508043
  510436
  510510
  512576
  516743
  517692
  518982
  520949
  522599
  523703
  527607
  533394
  536674
  537577
  539396
  540304
  540334
  540422
  540574
  540788
  541099
  546662
  549979
  559912
  693847
  709919
  729626
  730715
  738245
  741980
  778239
  799980
  804704
  810850
  811863
  817451
  828058
]
2.42 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white skinny"
]
1.98 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white худые"
]
1.81 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white худые"
]

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.