Query Metrics
7
Database Queries
7
Different statements
398.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
373.12 ms (93.53%) |
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 88220 117854 118165 120264 147128 155232 256431 365945 368196 381933 382066 386605 391582 391597 391940 415319 416142 416738 418225 421169 422662 423396 426798 431515 442260 442623 444460 447159 449940 453194 456904 458865 459710 462300 475118 475226 480133 481352 482207 487893 488240 489775 493296 496284 496827 497497 502784 503701 503851 506839 508004 509130 510797 510905 513639 514695 514750 520389 523348 523592 524112 526077 526192 528890 530160 534480 536134 538779 539463 541162 542655 545651 546568 549858 551523 552046 552577 552770 553989 554560 554657 555670 556110 561489 562103 562521 566091 567108 576438 578505 584985 586157 587370 588666 589730 593249 593763 594030 595401 599797 604887 605734 605798 608320 615515 616493 618590 619811 626824 627001 628256 629268 630472 639241 651824 655275 666475 682912 686862 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (3.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 456904 449940 556110 593763 605734 588666 619811 88220 426798 118165 117854 503851 365945 475118 120264 416142 444460 497497 566091 542655 545651 552046 655275 666475 604887 586157 594030 627001 639241 587370 524112 487893 496284 539463 503701 509130 541162 576438 552577 651824 686862 553989 561489 593249 155232 421169 391582 480133 391940 422662 508004 381933 475226 488240 630472 382066 482207 555670 605798 368196 510797 386605 147128 442623 418225 458865 534480 538779 562521 562103 599797 391597 520389 628256 423396 514695 447159 481352 523348 526077 523592 526192 546568 549858 682912 554657 629268 615515 618590 608320 513639 493296 497689 584985 453194 496827 502784 578505 616493 589730 514750 506839 552770 626824 595401 459710 256431 415319 416738 431515 442260 462300 489775 528890 510905 536134 530160 551523 554560 567108 ] |
||||||||||||||||||||||||||||||
|
4.00 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 88220 117854 118165 120264 147128 155232 256431 365945 368196 381933 382066 386605 391582 391597 391940 415319 416142 416738 418225 421169 422662 423396 426798 431515 442260 442623 444460 447159 449940 453194 456904 458865 459710 462300 475118 475226 480133 481352 482207 487893 488240 489775 493296 496284 496827 497497 502784 503701 503851 506839 508004 509130 510797 510905 513639 514695 514750 520389 523348 523592 524112 526077 526192 528890 530160 534480 536134 538779 539463 541162 542655 545651 546568 549858 551523 552046 552577 552770 553989 554560 554657 555670 556110 561489 562103 562521 566091 567108 576438 578505 584985 586157 587370 588666 589730 593249 593763 594030 595401 599797 604887 605734 605798 608320 615515 616493 618590 619811 626824 627001 628256 629268 630472 639241 651824 655275 666475 682912 686862 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в руке"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в рук"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.37%) |
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.