Query Metrics
7
Database Queries
7
Different statements
159.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.07 ms (84.47%) |
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 73947 172541 295874 382018 382443 384241 391092 397366 398655 401226 404342 407146 417292 422203 426515 432834 439720 440713 442814 446173 448195 453155 453453 457562 459744 460750 464459 472063 474401 477625 479916 480639 483022 485180 490804 497957 498984 499010 499339 501030 503976 506273 509351 509353 510705 511132 511799 513832 517077 518976 519659 521412 527131 529378 533887 533910 533919 539786 543762 545895 546390 547964 548024 551110 553214 557129 559067 561512 566128 566887 567502 571057 572736 577364 585395 589634 590946 591016 591022 591023 591035 591057 591543 592092 601102 609604 609753 610544 613815 615979 620430 621034 621782 625000 642405 644338 653252 680904 682234 701208 704345 705223 705425 705491 718854 720630 721604 731048 743247 771365 778175 780083 780839 788399 794286 798269 801432 802058 810296 810393 ] |
||||||||||||||||||||||||||||||
|
14.78 ms (9.24%) |
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 426515 566128 401226 439720 498984 457562 485180 529378 539786 513832 497957 503976 561512 585395 442814 510705 609753 547964 621034 391092 509353 577364 615979 591016 499339 557129 591057 780839 432834 479916 464459 613815 601102 609604 295874 477625 453453 506273 653252 398655 407146 417292 453155 472063 397366 404342 483022 501030 517077 519659 551110 625000 546390 720630 591023 621782 778175 705425 382443 521412 480639 545895 743247 705491 384241 682234 591022 591035 448195 567502 518976 559067 460750 382018 527131 533910 509351 680904 701208 794286 731048 610544 474401 511132 499010 788399 572736 533887 548024 566887 704345 642405 644338 591543 592092 620430 780083 810296 798269 810393 771365 802058 172541 801432 571057 422203 589634 440713 446173 590946 73947 459744 490804 511799 533919 543762 553214 705223 718854 721604 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.87%) |
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 73947 172541 295874 382018 382443 384241 391092 397366 398655 401226 404342 407146 417292 422203 426515 432834 439720 440713 442814 446173 448195 453155 453453 457562 459744 460750 464459 472063 474401 477625 479916 480639 483022 485180 490804 497957 498984 499010 499339 501030 503976 506273 509351 509353 510705 511132 511799 513832 517077 518976 519659 521412 527131 529378 533887 533910 533919 539786 543762 545895 546390 547964 548024 551110 553214 557129 559067 561512 566128 566887 567502 571057 572736 577364 585395 589634 590946 591016 591022 591023 591035 591057 591543 592092 601102 609604 609753 610544 613815 615979 620430 621034 621782 625000 642405 644338 653252 680904 682234 701208 704345 705223 705425 705491 718854 720630 721604 731048 743247 771365 778175 780083 780839 788399 794286 798269 801432 802058 810296 810393 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на кухня"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на кухн"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на кухн"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.