Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
220.87 ms
(90.26%)
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
  391592
  397918
  399176
  400816
  421815
  421817
  421847
  421870
  421885
  422152
  432650
  433240
  433351
  433372
  433375
  435356
  435747
  440979
  448955
  449692
  449893
  457455
  457980
  458438
  459519
  460226
  461843
  465385
  467952
  468369
  469372
  469389
  471407
  473511
  474778
  479669
  483654
  485057
  493174
  494327
  494967
  495222
  495227
  500796
  502813
  507003
  516226
  516478
  516712
  517711
  518807
  520861
  521220
  522992
  523832
  524486
  524497
  524540
  532932
  538003
  538022
  538970
  542706
  544120
  546955
  549846
  549849
  549850
  550672
  555263
  557969
  559737
  572697
  582339
  587158
  591355
  595483
  600798
  603890
  605026
  606266
  612079
  620245
  635834
  669080
  671465
  686807
  700975
  701192
  738503
  739985
  743890
  744968
  748690
  750893
  757277
  766612
  769990
  775172
  775855
  776940
  784279
  784804
  786525
  787488
  788860
  788946
  791501
  791916
  794375
  795988
  801409
  803046
  803524
  806789
  806952
  818532
  823607
  824121
  826571
]
14.98 ms
(6.12%)
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
  686807
  620245
  612079
  795988
  806952
  748690
  769990
  739985
  750893
  775172
  788946
  459519
  572697
  788860
  826571
  449893
  474778
  524540
  555263
  557969
  542706
  700975
  591355
  744968
  635834
  468369
  399176
  435356
  521220
  784279
  701192
  458438
  467952
  544120
  549850
  433351
  421815
  421885
  448955
  457455
  460226
  421817
  433240
  469372
  421870
  461843
  516478
  523832
  538003
  494327
  494967
  500796
  502813
  524486
  433375
  522992
  516226
  595483
  435747
  824121
  818532
  823607
  479669
  532932
  582339
  559737
  587158
  787488
  791501
  757277
  766612
  791916
  794375
  806789
  483654
  485057
  465385
  473511
  457980
  524497
  546955
  549849
  550672
  671465
  669080
  549846
  606266
  600798
  605026
  786525
  775855
  801409
  803524
  743890
  784804
  738503
  603890
  776940
  803046
  469389
  422152
  440979
  471407
  400816
  421847
  433372
  449692
  516712
  517711
  538022
  538970
  518807
  493174
  507003
  495222
  495227
  520861
  391592
  397918
  432650
]
2.27 ms
(0.93%)
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
  391592
  397918
  399176
  400816
  421815
  421817
  421847
  421870
  421885
  422152
  432650
  433240
  433351
  433372
  433375
  435356
  435747
  440979
  448955
  449692
  449893
  457455
  457980
  458438
  459519
  460226
  461843
  465385
  467952
  468369
  469372
  469389
  471407
  473511
  474778
  479669
  483654
  485057
  493174
  494327
  494967
  495222
  495227
  500796
  502813
  507003
  516226
  516478
  516712
  517711
  518807
  520861
  521220
  522992
  523832
  524486
  524497
  524540
  532932
  538003
  538022
  538970
  542706
  544120
  546955
  549846
  549849
  549850
  550672
  555263
  557969
  559737
  572697
  582339
  587158
  591355
  595483
  600798
  603890
  605026
  606266
  612079
  620245
  635834
  669080
  671465
  686807
  700975
  701192
  738503
  739985
  743890
  744968
  748690
  750893
  757277
  766612
  769990
  775172
  775855
  776940
  784279
  784804
  786525
  787488
  788860
  788946
  791501
  791916
  794375
  795988
  801409
  803046
  803524
  806789
  806952
  818532
  823607
  824121
  826571
]
1.71 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom anal homemade"
]
1.67 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom анал домашн любительск"
]
1.54 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom анал домашн любительск"
]

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.