Query Metrics
7
Database Queries
7
Different statements
209.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.43 ms (85.93%) |
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 327170 386854 390057 395666 400254 407124 415749 421756 425140 432337 432831 438377 441022 443453 443559 443670 445220 447178 452097 453560 454456 455147 457781 459298 460296 463162 463772 467704 469763 469823 470012 470482 472124 476995 477686 479788 482388 486304 486938 487733 488073 489444 490308 491503 496437 497757 498237 501981 504201 504780 506358 506906 507846 508725 509135 509290 509736 510032 511744 511991 513425 514125 514456 514897 518558 519842 524524 525325 525332 527382 529104 529216 535019 538226 546058 556762 557985 559132 560835 560925 564120 564647 567141 567354 571691 576051 578500 584754 585123 588068 591177 595217 596424 600599 601491 602003 602306 603224 603503 603786 604387 606822 609933 610197 619850 625215 628045 628277 630592 634268 637017 644023 651938 653233 654374 656462 659060 677007 678569 ] |
||||||||||||||||||||||||||||||
|
19.61 ms (9.34%) |
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 470012 514456 443453 585123 453560 600599 630592 459298 463162 445220 438377 476995 470482 486304 489444 506358 560835 603786 443670 425140 460296 506906 507846 511744 527382 509736 513425 529104 457781 602306 415749 556762 659060 496437 525332 432831 432337 479788 576051 653233 454456 510032 498237 504201 525325 571691 637017 327170 469763 472124 463772 509290 491503 514125 400254 488073 604387 469823 407124 538226 514897 504780 591177 619850 443559 487733 508725 564647 441022 497757 518558 651938 601491 677007 490308 596424 644023 455147 390057 610197 421756 452097 535019 395666 482388 447178 559132 567141 564120 628045 501981 578500 584754 588068 606822 546058 656462 595217 557985 603224 609933 477686 486938 772851 509135 529216 567354 625215 602003 628277 511991 519842 524524 386854 654374 603503 634268 467704 560925 678569 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.48%) |
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 327170 386854 390057 395666 400254 407124 415749 421756 425140 432337 432831 438377 441022 443453 443559 443670 445220 447178 452097 453560 454456 455147 457781 459298 460296 463162 463772 467704 469763 469823 470012 470482 472124 476995 477686 479788 482388 486304 486938 487733 488073 489444 490308 491503 496437 497757 498237 501981 504201 504780 506358 506906 507846 508725 509135 509290 509736 510032 511744 511991 513425 514125 514456 514897 518558 519842 524524 525325 525332 527382 529104 529216 535019 538226 546058 556762 557985 559132 560835 560925 564120 564647 567141 567354 571691 576051 578500 584754 585123 588068 591177 595217 596424 600599 601491 602003 602306 603224 603503 603786 604387 606822 609933 610197 619850 625215 628045 628277 630592 634268 637017 644023 651938 653233 654374 656462 659060 677007 678569 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"прыга на"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"прыгают на"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.73%) |
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.