Query Metrics
7
Database Queries
7
Different statements
277.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
251.45 ms (90.64%) |
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 257963 382275 392986 398527 421578 424739 428264 429030 442988 449644 452860 453564 454459 455641 455834 456288 457672 460896 462273 466676 469839 472972 479470 479846 480705 482475 483690 483848 485753 488716 488920 489389 491238 496284 496294 496882 499184 500083 503036 503907 504259 505171 506519 509022 511065 511984 512826 512881 513087 516538 518500 519366 522266 522545 523020 527522 527533 527896 528947 528948 528950 529058 535330 539137 540233 541624 541802 542535 544306 544453 548614 549623 550125 550589 551040 552022 552368 553289 555643 558723 559744 565119 565370 566794 567102 567965 568483 569783 571864 572808 572824 573950 576311 576462 577031 577540 580269 580735 581619 581946 582722 584646 586365 592617 597877 601640 601679 602037 606518 607238 614890 617030 626911 628321 646669 651678 659276 664562 671296 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (5.60%) |
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 586365 597877 442988 483690 511065 540233 646669 626911 572808 529058 462273 582722 542535 581619 607238 479846 528948 528947 528950 664562 550125 424739 577031 485753 505171 576462 541802 550589 568483 552022 569783 580735 617030 491238 552368 602037 454459 483848 513087 527533 488920 548614 577540 555643 565119 601679 466676 456288 496882 504259 506519 523020 499184 512826 455834 503036 535330 539137 544453 551040 571864 549623 553289 559744 576311 566794 558723 601640 472972 257963 398527 482475 457672 496284 522545 567965 581946 382275 421578 592617 460896 480705 455641 527896 509022 516538 453564 496294 511984 512881 527522 567102 573950 544306 659276 671296 565370 614890 628321 469839 428264 429030 392986 449644 479470 526806 488716 518500 584646 522266 572824 606518 452860 500083 503907 519366 489389 541624 580269 651678 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.00%) |
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 257963 382275 392986 398527 421578 424739 428264 429030 442988 449644 452860 453564 454459 455641 455834 456288 457672 460896 462273 466676 469839 472972 479470 479846 480705 482475 483690 483848 485753 488716 488920 489389 491238 496284 496294 496882 499184 500083 503036 503907 504259 505171 506519 509022 511065 511984 512826 512881 513087 516538 518500 519366 522266 522545 523020 527522 527533 527896 528947 528948 528950 529058 535330 539137 540233 541624 541802 542535 544306 544453 548614 549623 550125 550589 551040 552022 552368 553289 555643 558723 559744 565119 565370 566794 567102 567965 568483 569783 571864 572808 572824 573950 576311 576462 577031 577540 580269 580735 581619 581946 582722 584646 586365 592617 597877 601640 601679 602037 606518 607238 614890 617030 626911 628321 646669 651678 659276 664562 671296 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"юбк на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skirt public"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.58%) |
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.