Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
267.84 ms
(91.58%)
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
  233143
  382585
  391662
  392037
  392937
  396757
  403419
  427437
  428382
  437658
  441910
  443706
  444344
  453615
  455830
  457420
  460697
  462001
  465386
  465875
  476776
  476882
  484144
  487656
  490210
  492708
  493174
  493997
  495664
  495741
  498257
  504652
  505068
  505446
  506278
  506463
  509701
  511250
  512275
  517599
  518003
  521480
  521894
  522779
  523838
  542118
  552093
  552679
  555017
  560392
  561454
  564320
  577733
  592230
  595306
  599040
  605923
  612457
  612873
  621447
  628213
  652878
  654006
  656784
  657393
  659277
  661289
  668074
  673185
  682958
  689099
  692171
  707164
  712283
  713931
  721489
  722997
  728682
  730052
  736933
  737049
  741401
  742466
  745509
  745513
  747368
  751106
  754126
  758416
  763128
  763571
  764260
  767081
  768466
  772836
  772987
  777228
  779316
  779572
  785085
  785776
  786576
  788009
  788715
  789118
  789148
  789249
  801266
  802215
  809347
  816178
  816185
  818031
  818135
  820228
  821593
  821807
  821819
  823366
  825319
]
14.00 ms
(4.79%)
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
  682958
  668074
  692171
  786576
  779572
  751106
  768466
  490210
  505446
  518003
  396757
  403419
  652878
  605923
  612873
  788009
  745509
  742466
  754126
  785776
  441910
  555017
  560392
  592230
  476776
  465875
  523838
  487656
  521894
  444344
  437658
  465386
  392037
  512275
  564320
  443706
  505068
  453615
  476882
  511250
  498257
  821807
  816185
  818135
  821593
  659277
  654006
  707164
  595306
  789118
  789249
  772987
  764260
  767081
  730052
  612457
  233143
  506278
  484144
  552679
  428382
  460697
  522779
  504652
  506463
  661289
  747368
  457420
  495664
  391662
  392937
  818031
  820228
  821819
  825319
  823366
  542118
  657393
  689099
  656784
  673185
  621447
  628213
  788715
  777228
  779316
  802215
  736933
  737049
  772836
  741401
  745513
  758416
  728682
  722997
  785085
  789148
  801266
  713931
  721489
  809347
  763128
  763571
  577733
  552093
  599040
  427437
  455830
  517599
  492708
  493174
  493997
  495741
  816178
  712283
  462001
  509701
  521480
  382585
  561454
]
2.76 ms
(0.94%)
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
  233143
  382585
  391662
  392037
  392937
  396757
  403419
  427437
  428382
  437658
  441910
  443706
  444344
  453615
  455830
  457420
  460697
  462001
  465386
  465875
  476776
  476882
  484144
  487656
  490210
  492708
  493174
  493997
  495664
  495741
  498257
  504652
  505068
  505446
  506278
  506463
  509701
  511250
  512275
  517599
  518003
  521480
  521894
  522779
  523838
  542118
  552093
  552679
  555017
  560392
  561454
  564320
  577733
  592230
  595306
  599040
  605923
  612457
  612873
  621447
  628213
  652878
  654006
  656784
  657393
  659277
  661289
  668074
  673185
  682958
  689099
  692171
  707164
  712283
  713931
  721489
  722997
  728682
  730052
  736933
  737049
  741401
  742466
  745509
  745513
  747368
  751106
  754126
  758416
  763128
  763571
  764260
  767081
  768466
  772836
  772987
  777228
  779316
  779572
  785085
  785776
  786576
  788009
  788715
  789118
  789148
  789249
  801266
  802215
  809347
  816178
  816185
  818031
  818135
  820228
  821593
  821807
  821819
  823366
  825319
]
2.39 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian bathroom sex"
]
2.17 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск ван секс"
]
1.66 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск ван секс"
]
1.65 ms
(0.56%)
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.