Query Metrics
7
Database Queries
7
Different statements
165.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.49 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 269276 393253 395659 396841 400210 420912 425654 432389 433352 435754 437156 437249 447860 448227 449186 452650 452766 454374 455797 456072 457622 459225 460376 461116 463594 463602 468909 470119 473568 477235 480654 487251 495409 499757 501133 504711 515740 517910 519510 524266 528851 528908 551132 553689 554718 556400 559658 566939 574990 576609 577238 577944 585591 589923 591309 591842 597087 599599 599601 599615 599637 599733 605011 605749 614445 617472 618603 618738 622416 645922 650573 661421 674373 689492 691207 693899 694138 709363 710135 710800 718050 725087 735978 738791 738839 743468 745872 746555 748939 750358 756257 757130 757180 762310 767060 769272 772017 779086 780507 787882 791821 792483 793042 796638 797102 797677 798499 804793 805608 805682 808307 810167 810187 813071 813098 813728 819724 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (9.06%) |
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 796638 599599 787882 577238 750358 694138 650573 576609 808307 738791 797677 517910 805682 591842 779086 460376 605749 810167 819724 691207 709363 805608 769272 738839 621128 599601 623802 813098 756257 748939 745872 554718 689492 718050 393253 710800 269276 504711 767060 674373 618738 618603 792483 725087 771975 757180 743468 589923 804793 395659 437249 456072 400210 599615 614445 746555 524266 693899 645922 791821 735978 585591 810187 396841 433352 515740 495409 710135 797102 605011 813728 461116 762310 772017 463602 556400 597087 501133 553689 661421 591309 757130 617472 420912 448227 622416 528851 780507 432389 470119 468909 574990 577944 599733 798499 793042 813071 452766 435754 449186 528908 463594 551132 599637 459225 425654 499757 455797 473568 480654 559658 437156 452650 477235 454374 457622 519510 566939 447860 487251 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.90%) |
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 269276 393253 395659 396841 400210 420912 425654 432389 433352 435754 437156 437249 447860 448227 449186 452650 452766 454374 455797 456072 457622 459225 460376 461116 463594 463602 468909 470119 473568 477235 480654 487251 495409 499757 501133 504711 515740 517910 519510 524266 528851 528908 551132 553689 554718 556400 559658 566939 574990 576609 577238 577944 585591 589923 591309 591842 597087 599599 599601 599615 599637 599733 605011 605749 614445 617472 618603 618738 622416 645922 650573 661421 674373 689492 691207 693899 694138 709363 710135 710800 718050 725087 735978 738791 738839 743468 745872 746555 748939 750358 756257 757130 757180 762310 767060 769272 772017 779086 780507 787882 791821 792483 793042 796638 797102 797677 798499 804793 805608 805682 808307 810167 810187 813071 813098 813728 819724 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot girl sister"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot девушк sister"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot девушк sister"
]
|
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.