Query Metrics
7
Database Queries
7
Different statements
161.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.75 ms (75.80%) |
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 389479 395812 395826 399300 414160 415134 415655 421562 422657 424401 431498 431768 439854 446740 447089 452499 461744 463873 471446 472105 473037 473733 473909 474746 479219 483498 484478 486055 487156 491253 491500 491503 495158 508198 510964 511803 512315 512973 513576 514574 516820 517549 518270 520627 521033 521989 522566 524589 525873 526022 526024 526836 527495 528788 531078 545614 548257 550329 550679 550684 551913 554370 554646 555893 558128 558138 560450 560569 561997 563852 564443 565156 565367 565617 566703 566810 575197 575778 576051 576082 579368 580296 580646 581663 581684 590796 595383 595875 598042 598545 598806 600035 600060 600069 600084 603493 605122 605406 605500 606822 609280 609842 610613 611001 611661 611820 612099 612455 620295 621691 621705 623413 624214 624215 625395 628044 655697 657402 682530 683508 ] |
||||||||||||||||||||||||||||||
|
28.58 ms (17.65%) |
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 495158 514574 527495 531078 395826 431768 414160 422657 484478 452499 473037 510964 576051 576082 550684 564443 579368 554646 566810 611001 395812 463873 473909 474746 389479 472105 439854 471446 508198 521033 512315 522566 525873 491253 491503 511803 526024 483498 520627 524589 526836 431498 446740 558138 565617 575778 565367 598042 421562 424401 415655 517549 487156 512973 513576 491500 415134 566703 558128 683508 611661 621705 399300 473733 461744 516820 550679 606822 598545 620295 600060 600069 526022 548257 555893 563852 580296 580646 560450 565156 581663 560569 581684 655697 657402 682530 561997 625395 624214 600084 605500 612099 628044 595383 600035 611820 621691 610613 447089 479219 518270 521989 486055 528788 545614 550329 551913 554370 575197 603493 609842 623413 624215 595875 612455 598806 605122 590796 605406 609280 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.68%) |
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 389479 395812 395826 399300 414160 415134 415655 421562 422657 424401 431498 431768 439854 446740 447089 452499 461744 463873 471446 472105 473037 473733 473909 474746 479219 483498 484478 486055 487156 491253 491500 491503 495158 508198 510964 511803 512315 512973 513576 514574 516820 517549 518270 520627 521033 521989 522566 524589 525873 526022 526024 526836 527495 528788 531078 545614 548257 550329 550679 550684 551913 554370 554646 555893 558128 558138 560450 560569 561997 563852 564443 565156 565367 565617 566703 566810 575197 575778 576051 576082 579368 580296 580646 581663 581684 590796 595383 595875 598042 598545 598806 600035 600060 600069 600084 603493 605122 605406 605500 606822 609280 609842 610613 611001 611661 611820 612099 612455 620295 621691 621705 623413 624214 624215 625395 628044 655697 657402 682530 683508 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый милашк"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дед с милашкой"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
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.