Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
271.77 ms
(52.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
  146855
  282006
  391209
  395389
  398022
  400418
  407567
  410524
  410953
  415209
  415487
  417343
  417758
  419561
  423994
  425670
  437963
  443443
  444653
  445941
  447124
  447494
  451275
  456110
  457556
  458937
  460488
  460801
  461482
  463300
  464096
  464492
  465938
  466197
  466673
  468166
  470313
  471327
  471962
  473073
  475353
  476681
  481183
  483026
  483322
  483430
  484350
  488135
  488282
  491188
  491729
  497247
  500698
  500905
  501755
  502047
  506144
  506287
  506445
  506463
  508546
  508836
  509648
  511235
  512232
  513724
  513771
  513877
  514408
  516605
  519021
  519871
  521368
  521934
  522971
  524084
  524757
  524855
  525543
  525766
  542936
  546001
  546639
  552079
  552116
  552404
  554173
  554570
  555806
  557507
  558520
  562324
  563801
  566728
  568359
  570667
  574700
  574961
  593382
  595359
  598066
  599317
  605515
  605833
  613129
  622932
  629124
  642816
  654446
  657603
  659091
  659656
  660476
  681756
  730918
  736185
  754829
  760067
  785923
  804193
]
211.32 ms
(41.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие девушк красивая"
]
20.89 ms
(4.07%)
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
  593382
  605833
  466673
  475353
  417343
  447494
  464096
  471327
  525543
  804193
  407567
  483322
  451275
  443443
  500698
  522971
  146855
  398022
  488135
  500905
  506144
  654446
  598066
  415487
  461482
  395389
  460801
  417758
  476681
  410953
  502047
  484350
  483026
  519021
  521368
  521934
  483430
  464492
  554570
  524084
  415209
  516605
  514408
  557507
  525766
  785923
  760067
  524855
  391209
  425670
  574700
  622932
  599317
  613129
  566728
  444653
  574961
  659656
  660476
  657603
  659091
  681756
  629124
  730918
  736185
  754829
  595359
  457556
  410524
  471962
  491188
  497247
  554173
  546001
  552404
  463300
  465938
  468166
  282006
  445941
  470313
  419561
  437963
  458937
  481183
  512232
  513877
  519871
  491729
  506287
  511235
  513724
  506463
  508546
  509648
  524757
  488282
  501755
  508836
  513771
  546639
  400418
  456110
  460488
  555806
  563801
  568359
  542936
  570667
  552079
  552116
  558520
  562324
  642816
  605515
  423994
  466197
  473073
  447124
  506445
]
2.96 ms
(0.58%)
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
  146855
  282006
  391209
  395389
  398022
  400418
  407567
  410524
  410953
  415209
  415487
  417343
  417758
  419561
  423994
  425670
  437963
  443443
  444653
  445941
  447124
  447494
  451275
  456110
  457556
  458937
  460488
  460801
  461482
  463300
  464096
  464492
  465938
  466197
  466673
  468166
  470313
  471327
  471962
  473073
  475353
  476681
  481183
  483026
  483322
  483430
  484350
  488135
  488282
  491188
  491729
  497247
  500698
  500905
  501755
  502047
  506144
  506287
  506445
  506463
  508546
  508836
  509648
  511235
  512232
  513724
  513771
  513877
  514408
  516605
  519021
  519871
  521368
  521934
  522971
  524084
  524757
  524855
  525543
  525766
  542936
  546001
  546639
  552079
  552116
  552404
  554173
  554570
  555806
  557507
  558520
  562324
  563801
  566728
  568359
  570667
  574700
  574961
  593382
  595359
  598066
  599317
  605515
  605833
  613129
  622932
  629124
  642816
  654446
  657603
  659091
  659656
  660476
  681756
  730918
  736185
  754829
  760067
  785923
  804193
]
2.04 ms
(0.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие девушк красивая"
]
2.03 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big girl beautiful"
]

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.