Query Metrics
7
Database Queries
7
Different statements
258.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
219.21 ms (84.77%) |
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 387937 397960 400946 403641 404175 404368 405054 405468 406304 409921 413263 414358 416787 416794 416820 418478 419804 421093 421200 421557 423655 426032 429763 429766 435624 437526 455851 475262 476143 480429 488897 497901 499668 506529 507696 511318 512823 512984 514798 519085 519091 519194 521741 521970 524213 526073 526502 527452 529257 529286 530019 530022 530054 530110 530385 530627 530766 530779 530911 531126 531175 531189 531206 532241 532783 532804 532847 532952 532988 532989 533051 533376 533870 534041 534150 534161 534590 534650 534993 535005 536287 536344 536872 537590 537675 537685 537899 537928 539420 540980 573094 580449 583960 586587 601599 604444 617410 624190 633749 639757 644940 644971 666875 674975 676022 677307 677781 678127 678153 693987 710805 722541 730105 734073 734795 741935 769978 789831 800287 805498 ] |
||||||||||||||||||||||||||||||
|
26.70 ms (10.33%) |
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 521970 526073 536872 499668 512823 488897 519085 521741 527452 529257 741935 532847 666875 674975 421093 540980 722541 580449 604444 789831 800287 693987 730105 734795 769978 734073 537685 532952 534590 573094 710805 639757 601599 624190 805498 532241 531126 537675 537928 583960 677781 678127 617410 633749 480429 524213 519194 676022 677307 678153 586587 387937 397960 400946 403641 404368 406304 405054 405468 404175 413263 416787 418478 426032 437526 409921 416794 416820 419804 414358 435624 421200 423655 429763 429766 421557 644940 644971 476143 475262 455851 497901 530022 530110 530385 530627 530911 531189 531206 532783 532804 534041 534150 534650 536287 519091 530766 530779 531175 532988 532989 533051 533376 533870 534161 534993 535005 536344 537590 537899 539420 506529 507696 511318 512984 514798 526502 529286 530019 530054 ] |
||||||||||||||||||||||||||||||
|
4.58 ms (1.77%) |
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 387937 397960 400946 403641 404175 404368 405054 405468 406304 409921 413263 414358 416787 416794 416820 418478 419804 421093 421200 421557 423655 426032 429763 429766 435624 437526 455851 475262 476143 480429 488897 497901 499668 506529 507696 511318 512823 512984 514798 519085 519091 519194 521741 521970 524213 526073 526502 527452 529257 529286 530019 530022 530054 530110 530385 530627 530766 530779 530911 531126 531175 531189 531206 532241 532783 532804 532847 532952 532988 532989 533051 533376 533870 534041 534150 534161 534590 534650 534993 535005 536287 536344 536872 537590 537675 537685 537899 537928 539420 540980 573094 580449 583960 586587 601599 604444 617410 624190 633749 639757 644940 644971 666875 674975 676022 677307 677781 678127 678153 693987 710805 722541 730105 734073 734795 741935 769978 789831 800287 805498 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hardcore with bbc"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор bbc"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор bbc"
]
|
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.