Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.72 ms
(84.27%)
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
  192968
  365989
  388280
  388346
  388568
  389639
  390218
  391519
  391965
  397908
  413949
  414432
  416599
  418244
  419537
  424007
  424425
  426959
  426985
  429001
  434655
  435364
  436530
  436830
  439926
  442625
  443028
  443269
  443940
  444346
  445192
  447509
  447562
  448853
  450648
  450657
  451462
  451502
  451542
  458475
  459099
  460512
  460921
  462017
  466890
  468307
  471107
  472400
  473971
  474485
  475177
  475873
  475877
  475913
  476280
  476936
  477667
  477695
  480487
  481747
  483370
  483435
  484377
  486086
  487607
  489405
  490709
  490849
  491715
  494688
  495706
  498734
  501647
  504172
  505884
  509434
  511054
  514041
  515448
  516378
  518789
  521933
  521951
  522046
  524105
  525441
  533609
  534678
  551269
  555065
  555135
  558126
  558914
  559954
  564964
  565460
  566214
  567081
  567399
  567881
  568317
  568349
  570291
  571691
  572441
  573789
  573875
  573901
  575160
  579467
  581220
  591747
  597494
  597813
  598599
  598703
  600157
  626850
  659340
  721395
]
15.09 ms
(9.10%)
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
  476280
  475913
  447509
  447562
  451542
  483370
  501647
  487607
  573875
  573901
  572441
  591747
  419537
  451502
  498734
  533609
  477695
  413949
  443269
  450648
  476936
  495706
  391965
  388346
  598703
  434655
  460921
  466890
  477667
  473971
  474485
  468307
  480487
  414432
  445192
  458475
  481747
  518789
  521951
  483435
  521933
  524105
  475873
  365989
  436530
  390218
  391519
  450657
  418244
  424007
  426959
  472400
  490709
  575160
  598599
  388568
  435364
  436830
  475877
  462017
  475177
  388280
  397908
  443028
  516378
  514041
  559954
  192968
  504172
  444346
  486086
  525441
  558126
  565460
  568349
  571691
  597813
  439926
  429001
  459099
  484377
  568317
  566214
  448853
  443940
  426985
  494688
  534678
  460512
  558914
  567081
  581220
  564964
  567881
  570291
  579467
  659340
  551269
  555065
  555135
  567399
  573789
  600157
  597494
  626850
  721395
  416599
  451462
  389639
  424425
  471107
  442625
  505884
  515448
  489405
  509434
  511054
  522046
  490849
  491715
]
2.77 ms
(1.67%)
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
  192968
  365989
  388280
  388346
  388568
  389639
  390218
  391519
  391965
  397908
  413949
  414432
  416599
  418244
  419537
  424007
  424425
  426959
  426985
  429001
  434655
  435364
  436530
  436830
  439926
  442625
  443028
  443269
  443940
  444346
  445192
  447509
  447562
  448853
  450648
  450657
  451462
  451502
  451542
  458475
  459099
  460512
  460921
  462017
  466890
  468307
  471107
  472400
  473971
  474485
  475177
  475873
  475877
  475913
  476280
  476936
  477667
  477695
  480487
  481747
  483370
  483435
  484377
  486086
  487607
  489405
  490709
  490849
  491715
  494688
  495706
  498734
  501647
  504172
  505884
  509434
  511054
  514041
  515448
  516378
  518789
  521933
  521951
  522046
  524105
  525441
  533609
  534678
  551269
  555065
  555135
  558126
  558914
  559954
  564964
  565460
  566214
  567081
  567399
  567881
  568317
  568349
  570291
  571691
  572441
  573789
  573875
  573901
  575160
  579467
  581220
  591747
  597494
  597813
  598599
  598703
  600157
  626850
  659340
  721395
]
2.17 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская блондинка в в%…"
]
2.17 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск беловолосая в в"
]
1.98 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.