Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.08 ms
(82.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
  381817
  384463
  386189
  389729
  400491
  411321
  411325
  419531
  420311
  421832
  422803
  425724
  426295
  426919
  429872
  431643
  438013
  440761
  441094
  442072
  442128
  444915
  450268
  450287
  452331
  452354
  454156
  454507
  455151
  456312
  458770
  460444
  461129
  462461
  463825
  463832
  464889
  466226
  466341
  466855
  467835
  468269
  468675
  468836
  471162
  471605
  472943
  473533
  474117
  476321
  476676
  477223
  478269
  484648
  485695
  486969
  497203
  500429
  500914
  502467
  502578
  506057
  506252
  509261
  509590
  509836
  510546
  515266
  517735
  518598
  519068
  521107
  527476
  532700
  532893
  534138
  537893
  538021
  549836
  557327
  558177
  561354
  562346
  563448
  565306
  574459
  578180
  579224
  581165
  581749
  586578
  587124
  594300
  600946
  604933
  605679
  617115
  619604
  624905
  646243
  649523
  659385
  665288
  667496
  667543
  667898
  669387
  698102
  705424
  710161
  714927
  730975
  744202
  748255
  781990
  796877
  796881
  808151
  815789
]
17.34 ms
(11.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
  454507
  456312
  506057
  502578
  521107
  484648
  381817
  468269
  605679
  730975
  477223
  472943
  386189
  509836
  461129
  532700
  532893
  462461
  698102
  450268
  422803
  815789
  473533
  452354
  471162
  476321
  500429
  510546
  517735
  534138
  578180
  624905
  466226
  464889
  425724
  440761
  665288
  667543
  549836
  600946
  594300
  429872
  466341
  420311
  442072
  441094
  442128
  466855
  537893
  538021
  527476
  563448
  649523
  659385
  619604
  586578
  796881
  787989
  781990
  796877
  808151
  389729
  411325
  463832
  467835
  486969
  506252
  497203
  455151
  476676
  604933
  500914
  667496
  400491
  474117
  384463
  705424
  485695
  463825
  515266
  574459
  646243
  667898
  748255
  454156
  438013
  509590
  587124
  450287
  557327
  561354
  669387
  714927
  419531
  426295
  431643
  458770
  468675
  518598
  558177
  581165
  579224
  565306
  581749
  710161
  617115
  478269
  426919
  460444
  444915
  471605
  452331
  421832
  468836
  502467
  519068
  509261
  744202
  562346
  411321
]
2.63 ms
(1.68%)
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
  381817
  384463
  386189
  389729
  400491
  411321
  411325
  419531
  420311
  421832
  422803
  425724
  426295
  426919
  429872
  431643
  438013
  440761
  441094
  442072
  442128
  444915
  450268
  450287
  452331
  452354
  454156
  454507
  455151
  456312
  458770
  460444
  461129
  462461
  463825
  463832
  464889
  466226
  466341
  466855
  467835
  468269
  468675
  468836
  471162
  471605
  472943
  473533
  474117
  476321
  476676
  477223
  478269
  484648
  485695
  486969
  497203
  500429
  500914
  502467
  502578
  506057
  506252
  509261
  509590
  509836
  510546
  515266
  517735
  518598
  519068
  521107
  527476
  532700
  532893
  534138
  537893
  538021
  549836
  557327
  558177
  561354
  562346
  563448
  565306
  574459
  578180
  579224
  581165
  581749
  586578
  587124
  594300
  600946
  604933
  605679
  617115
  619604
  624905
  646243
  649523
  659385
  665288
  667496
  667543
  667898
  669387
  698102
  705424
  710161
  714927
  730975
  744202
  748255
  781990
  796877
  796881
  808151
  815789
]
1.92 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby big dildo"
]
1.83 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby большие дилд"
]
1.50 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby большие дилд"
]
1.44 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.