Query Metrics
7
Database Queries
7
Different statements
156.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.61 ms (82.64%) |
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 3607 11254 323352 388950 397513 397586 398125 399545 401564 401875 405701 408894 411072 417600 417788 418621 420359 420829 421390 421553 421617 426103 426728 426730 426731 428885 431718 441301 441347 441424 443176 443652 446994 448786 448911 449572 450364 451717 452407 454586 454766 454789 457017 464369 467059 469194 473095 478916 479839 482573 486106 486461 486741 487556 488693 489765 496893 498156 500625 502999 506306 507835 509517 512751 512814 515548 515670 516159 518508 518561 521760 522455 533803 535990 539367 548185 550041 550045 560337 564652 579234 581774 585067 591582 595684 597498 597507 598549 598867 600190 600213 601820 602113 603015 618424 620267 621183 629407 646656 666934 671848 671881 683251 690891 692014 698338 730838 735307 736587 739408 748448 760656 764201 781319 787069 789209 806849 819932 826333 828182 ] |
||||||||||||||||||||||||||||||
|
16.72 ms (10.66%) |
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 500625 521760 522455 533803 3607 11254 401875 426728 448786 479839 666934 579234 601820 401564 441347 451717 431718 478916 618424 591582 443176 449572 426730 748448 452407 548185 446994 518561 443652 690891 730838 418621 441301 585067 482573 488693 489765 506306 502999 535990 560337 646656 550041 550045 564652 581774 595684 603015 620267 597507 598549 598867 600190 602113 621183 600213 629407 421390 516159 509517 498156 507835 512751 512814 515670 826333 828182 515548 428885 323352 397513 398125 411072 426103 441424 421617 417600 417788 420829 464369 486106 486461 454789 496893 518508 467059 486741 683251 760656 781319 787069 736587 764201 739408 735307 789209 806849 399545 408894 405701 457017 469194 397586 450364 454766 426731 473095 420359 487556 597498 539367 671881 692014 671848 698338 388950 421553 819932 454586 448911 ] |
||||||||||||||||||||||||||||||
|
3.26 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 3607 11254 323352 388950 397513 397586 398125 399545 401564 401875 405701 408894 411072 417600 417788 418621 420359 420829 421390 421553 421617 426103 426728 426730 426731 428885 431718 441301 441347 441424 443176 443652 446994 448786 448911 449572 450364 451717 452407 454586 454766 454789 457017 464369 467059 469194 473095 478916 479839 482573 486106 486461 486741 487556 488693 489765 496893 498156 500625 502999 506306 507835 509517 512751 512814 515548 515670 516159 518508 518561 521760 522455 533803 535990 539367 548185 550041 550045 560337 564652 579234 581774 585067 591582 595684 597498 597507 598549 598867 600190 600213 601820 602113 603015 618424 620267 621183 629407 646656 666934 671848 671881 683251 690891 692014 698338 730838 735307 736587 739408 748448 760656 764201 781319 787069 789209 806849 819932 826333 828182 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade webcam"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
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.