Query Metrics
7
Database Queries
7
Different statements
210.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.78 ms (87.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 4048 21109 53805 118284 160270 185456 332365 339037 382249 382877 382937 384039 384050 384095 384518 384754 385113 385282 385547 385600 386095 386583 387846 390275 391147 392735 393423 395434 395689 398421 398929 398982 399019 400326 402119 402261 404055 408593 411185 413136 413633 418364 419353 421382 422028 424315 424651 434016 434878 438053 443188 444221 446963 449740 451717 453706 455997 456186 457371 457567 458776 458994 460397 460442 461285 462891 463133 468272 468286 470384 471571 475560 475899 476921 479175 482418 482955 492838 496194 506474 508068 509390 513147 515152 519558 521446 523719 524513 525930 526003 528789 529911 529915 536924 538233 541825 543818 544341 549442 550071 552210 552225 552850 556953 567058 568245 568803 592412 601976 604051 614737 619598 621465 622872 634400 650913 655663 665937 751106 789335 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (7.17%) |
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 476921 515152 384518 160270 4048 399019 529911 650913 665937 385600 475560 592412 525930 528789 332365 402119 655663 385282 526003 519558 422028 393423 398929 385547 392735 457567 457371 544341 549442 398421 382937 619598 524513 604051 443188 402261 386583 446963 400326 508068 550071 567058 384095 521446 395434 455997 471571 543818 385113 513147 538233 387846 382877 53805 411185 751106 444221 434016 21109 536924 391147 621465 482418 463133 185456 614737 118284 408593 568245 622872 451717 404055 462891 460397 475899 482955 424315 398982 419353 461285 492838 456186 458776 509390 460442 552850 634400 789335 479175 382249 395689 413633 418364 458994 496194 601976 386095 384039 384754 339037 468286 470384 468272 529915 541825 552225 556953 552210 568803 384050 390275 434878 413136 424651 438053 453706 506474 523719 449740 421382 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (1.79%) |
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 4048 21109 53805 118284 160270 185456 332365 339037 382249 382877 382937 384039 384050 384095 384518 384754 385113 385282 385547 385600 386095 386583 387846 390275 391147 392735 393423 395434 395689 398421 398929 398982 399019 400326 402119 402261 404055 408593 411185 413136 413633 418364 419353 421382 422028 424315 424651 434016 434878 438053 443188 444221 446963 449740 451717 453706 455997 456186 457371 457567 458776 458994 460397 460442 461285 462891 463133 468272 468286 470384 471571 475560 475899 476921 479175 482418 482955 492838 496194 506474 508068 509390 513147 515152 519558 521446 523719 524513 525930 526003 528789 529911 529915 536924 538233 541825 543818 544341 549442 550071 552210 552225 552850 556953 567058 568245 568803 592412 601976 604051 614737 619598 621465 622872 634400 650913 655663 665937 751106 789335 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в футболка"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в футболк"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.69%) |
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.