Query Metrics
7
Database Queries
7
Different statements
185.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.68 ms (84.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 385092 420601 421043 422166 423969 424369 425555 428443 429782 430144 434590 434717 435745 436577 440741 442402 442508 443853 444705 445905 446311 448985 449722 450896 451141 453436 453437 453802 453900 453908 454051 454873 454876 459775 465404 465738 465801 467027 467732 469559 472739 473320 474129 475091 477053 477065 477639 477788 478333 479552 479842 481043 484249 486027 486558 487654 489737 490758 491160 491607 493071 495574 495808 499096 499604 500223 503089 503383 506023 506527 506853 508078 509032 509391 509392 509570 509583 510174 510217 511358 512451 513552 514773 515006 515010 516444 517147 518207 519062 519825 520093 521316 521476 524044 524274 525586 525694 530870 545520 551479 552936 559791 563735 563890 567311 567689 568323 569559 578610 581714 601953 617203 618722 675342 698282 764029 770663 787944 787966 801234 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (9.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 617203 787966 801234 770663 601953 618722 787944 477053 479552 481043 440741 442508 453436 453802 453908 454873 465801 443853 454876 467732 473320 477639 420601 434590 444705 459775 465404 465738 467027 442402 448985 450896 472739 478333 503089 506853 509392 513552 520093 495574 495808 503383 508078 519062 486027 487654 491160 499604 506527 515010 518207 524044 490758 493071 500223 506023 510174 525586 484249 551479 675342 764029 698282 385092 422166 421043 515006 512451 425555 423969 430144 434717 435745 429782 424369 428443 436577 581714 453437 469559 475091 486558 449722 451141 453900 491607 445905 446311 454051 479842 509391 516444 525694 499096 510217 511358 517147 521316 509032 514773 519825 521476 509570 509583 524274 530870 474129 477065 477788 489737 563735 563890 567311 568323 578610 559791 545520 552936 567689 569559 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.39%) |
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 385092 420601 421043 422166 423969 424369 425555 428443 429782 430144 434590 434717 435745 436577 440741 442402 442508 443853 444705 445905 446311 448985 449722 450896 451141 453436 453437 453802 453900 453908 454051 454873 454876 459775 465404 465738 465801 467027 467732 469559 472739 473320 474129 475091 477053 477065 477639 477788 478333 479552 479842 481043 484249 486027 486558 487654 489737 490758 491160 491607 493071 495574 495808 499096 499604 500223 503089 503383 506023 506527 506853 508078 509032 509391 509392 509570 509583 510174 510217 511358 512451 513552 514773 515006 515010 516444 517147 518207 519062 519825 520093 521316 521476 524044 524274 525586 525694 530870 545520 551479 552936 559791 563735 563890 567311 567689 568323 569559 578610 581714 601953 617203 618722 675342 698282 764029 770663 787944 787966 801234 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping pov"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ пов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.86%) |
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.