Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.29 ms
(79.91%)
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
  307654
  395547
  396877
  399088
  399874
  410936
  419034
  421394
  422617
  424675
  428664
  429427
  444885
  446713
  447462
  450885
  451710
  452916
  457840
  458645
  459381
  463153
  463370
  464842
  466702
  467972
  468122
  468975
  469576
  471991
  472251
  473004
  473472
  473748
  475796
  477182
  479330
  479333
  481154
  481485
  481612
  481635
  482087
  485998
  487877
  489640
  491294
  492026
  492374
  492389
  495691
  497581
  502648
  503151
  503914
  506437
  509341
  509969
  509970
  511076
  511454
  515152
  515193
  515812
  516744
  516903
  518296
  519081
  519721
  520025
  520600
  522597
  522647
  523918
  524162
  525432
  526006
  527124
  528263
  529501
  535521
  538251
  540902
  540914
  542218
  546978
  549176
  552217
  552344
  553032
  557205
  557848
  557853
  558543
  561985
  563742
  567087
  570076
  572888
  574504
  575731
  579098
  579592
  579935
  580153
  582352
  582481
  586263
  586426
  586517
  589571
  606652
  607388
  611001
  623162
  678769
  683598
  720056
  811440
  825812
]
18.99 ms
(12.72%)
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
  511076
  399088
  473748
  451710
  457840
  458645
  472251
  468122
  546978
  574504
  582481
  586263
  586517
  479333
  479330
  540902
  487877
  491294
  466702
  535521
  567087
  580153
  582352
  586426
  606652
  463370
  477182
  450885
  523918
  519081
  497581
  506437
  481635
  572888
  557853
  811440
  428664
  516903
  520025
  307654
  444885
  473004
  515193
  678769
  683598
  481154
  447462
  503914
  482087
  520600
  518296
  522597
  419034
  579935
  471991
  464842
  540914
  489640
  495691
  446713
  463153
  481485
  485998
  575731
  481612
  429427
  528263
  511454
  519721
  538251
  492389
  557205
  557848
  459381
  524162
  492026
  526006
  529501
  509969
  422617
  396877
  399874
  395547
  421394
  553032
  611001
  468975
  503151
  589571
  509970
  825812
  492374
  561985
  509341
  579098
  515812
  522647
  515152
  469576
  720056
  467972
  410936
  542218
  552344
  552217
  558543
  570076
  424675
  563742
  525432
  473472
  475796
  549176
  607388
  502648
  452916
  623162
  516744
  527124
  579592
]
3.11 ms
(2.08%)
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
  307654
  395547
  396877
  399088
  399874
  410936
  419034
  421394
  422617
  424675
  428664
  429427
  444885
  446713
  447462
  450885
  451710
  452916
  457840
  458645
  459381
  463153
  463370
  464842
  466702
  467972
  468122
  468975
  469576
  471991
  472251
  473004
  473472
  473748
  475796
  477182
  479330
  479333
  481154
  481485
  481612
  481635
  482087
  485998
  487877
  489640
  491294
  492026
  492374
  492389
  495691
  497581
  502648
  503151
  503914
  506437
  509341
  509969
  509970
  511076
  511454
  515152
  515193
  515812
  516744
  516903
  518296
  519081
  519721
  520025
  520600
  522597
  522647
  523918
  524162
  525432
  526006
  527124
  528263
  529501
  535521
  538251
  540902
  540914
  542218
  546978
  549176
  552217
  552344
  553032
  557205
  557848
  557853
  558543
  561985
  563742
  567087
  570076
  572888
  574504
  575731
  579098
  579592
  579935
  580153
  582352
  582481
  586263
  586426
  586517
  589571
  606652
  607388
  611001
  623162
  678769
  683598
  720056
  811440
  825812
]
2.24 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl with glasses"
]
2.01 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк очкастая"
]
1.76 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.