Query Metrics
7
Database Queries
7
Different statements
153.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.06 ms (81.46%) |
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 388756 389760 402530 419176 428475 437582 439476 443627 445199 451105 457003 458018 459434 459569 460101 462210 463636 474053 475196 475826 476883 477891 482161 485848 486066 487198 490273 492432 495281 496252 505076 509884 519459 520227 523421 523776 532514 539816 545816 554373 554739 555599 557000 557008 557397 560099 565032 565624 568139 570126 578704 578764 578780 579661 583328 588787 598907 599579 600875 606366 606995 607002 607037 610121 612263 619891 628714 630150 641778 650883 653830 687362 687960 691414 693576 697196 700833 701253 707545 717278 718309 721249 721867 723629 723660 730947 732868 733220 734322 737274 737465 738576 739778 739782 740871 742757 746093 746489 748783 751847 756861 761022 765322 773981 776307 782384 785517 788377 790302 790679 794672 797080 799042 799978 801063 807504 817361 817482 819353 824749 ] |
||||||||||||||||||||||||||||||
|
17.44 ms (11.36%) |
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 485848 583328 653830 697196 554739 557000 565032 610121 588787 607002 788377 707545 475196 523776 389760 443627 723629 723660 817361 824749 475826 451105 463636 477891 505076 520227 495281 532514 474053 545816 578704 578764 650883 687362 700833 718309 721249 693576 717278 721867 555599 557397 578780 641778 599579 600875 607037 598907 612263 628714 606366 782384 785517 807504 740871 756861 790302 751847 761022 733220 738576 742757 746489 748783 765322 734322 737274 737465 739778 739782 773981 730947 732868 746093 606995 619891 630150 701253 776307 790679 794672 797080 799042 799978 801063 459434 476883 437582 445199 519459 490273 509884 428475 402530 388756 419176 439476 817482 819353 457003 459569 460101 492432 487198 458018 462210 496252 539816 523421 482161 486066 560099 568139 579661 557008 554373 565624 570126 687960 691414 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.24%) |
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 388756 389760 402530 419176 428475 437582 439476 443627 445199 451105 457003 458018 459434 459569 460101 462210 463636 474053 475196 475826 476883 477891 482161 485848 486066 487198 490273 492432 495281 496252 505076 509884 519459 520227 523421 523776 532514 539816 545816 554373 554739 555599 557000 557008 557397 560099 565032 565624 568139 570126 578704 578764 578780 579661 583328 588787 598907 599579 600875 606366 606995 607002 607037 610121 612263 619891 628714 630150 641778 650883 653830 687362 687960 691414 693576 697196 700833 701253 707545 717278 718309 721249 721867 723629 723660 730947 732868 733220 734322 737274 737465 738576 739778 739782 740871 742757 746093 746489 748783 751847 756861 761022 765322 773981 776307 782384 785517 788377 790302 790679 794672 797080 799042 799978 801063 807504 817361 817482 819353 824749 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur cheating"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск cheating"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск cheating"
]
|
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.