Query Metrics
7
Database Queries
7
Different statements
192.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.97 ms (85.67%) |
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 28396 61369 83131 210349 218742 359723 360242 395472 396762 417196 422071 426441 445009 446963 455234 455835 459278 459580 460477 460891 461949 473977 483430 483880 485556 487680 488896 488911 490574 490579 496646 500095 500130 503062 506868 510015 514711 523297 525422 527328 527343 527516 527541 527896 528598 529827 530199 531602 533564 534913 537066 540922 542243 543685 544622 545071 545878 546282 548610 551565 552337 556087 558744 560546 568783 569419 571063 571598 573007 575002 588819 599195 601640 604641 605225 606022 607873 614205 615997 627881 628497 629696 644871 646104 650020 651725 659050 660583 680688 680800 704582 704958 705753 705772 705793 708513 709552 717056 719910 729357 729676 731598 732166 740768 760281 764864 765942 766814 769146 778747 779620 785543 789071 789078 789911 790252 791118 804428 805240 808299 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (8.18%) |
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 525422 527328 487680 510015 523297 417196 218742 61369 490574 527516 527541 568783 571598 575002 614205 599195 460891 500095 490579 496646 503062 650020 460477 483880 528598 601640 628497 360242 506868 488896 485556 533564 573007 551565 569419 615997 445009 459278 459580 426441 422071 455835 527896 500130 537066 542243 548610 651725 660583 680688 717056 659050 606022 604641 808299 729357 764864 789078 605225 396762 359723 534913 83131 644871 530199 529827 488911 544622 560546 556087 540922 543685 545878 571063 646104 705793 708513 705753 709552 719910 704582 545071 629696 588819 627881 607873 778747 785543 791118 769146 789071 789911 805240 765942 766814 729676 731598 760281 732166 740768 704958 705772 779620 790252 804428 473977 210349 455234 531602 552337 558744 680800 546282 461949 483430 446963 514711 395472 28396 527343 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.67%) |
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 28396 61369 83131 210349 218742 359723 360242 395472 396762 417196 422071 426441 445009 446963 455234 455835 459278 459580 460477 460891 461949 473977 483430 483880 485556 487680 488896 488911 490574 490579 496646 500095 500130 503062 506868 510015 514711 523297 525422 527328 527343 527516 527541 527896 528598 529827 530199 531602 533564 534913 537066 540922 542243 543685 544622 545071 545878 546282 548610 551565 552337 556087 558744 560546 568783 569419 571063 571598 573007 575002 588819 599195 601640 604641 605225 606022 607873 614205 615997 627881 628497 629696 644871 646104 650020 651725 659050 660583 680688 680800 704582 704958 705753 705772 705793 708513 709552 717056 719910 729357 729676 731598 732166 740768 760281 764864 765942 766814 769146 778747 779620 785543 789071 789078 789911 790252 791118 804428 805240 808299 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раком в улице"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак в улиц"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.87%) |
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.