Query Metrics
7
Database Queries
7
Different statements
196.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.79 ms (84.30%) |
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 334472 421537 423654 427983 428125 429775 429799 429804 443480 443991 444820 447152 453473 455088 457077 463311 464650 465025 472550 475703 480420 481602 481625 491263 492576 493810 495269 496074 497776 500913 510270 512508 517725 519108 522598 522903 524193 525348 527414 529420 530381 530489 530491 530624 530650 531157 531225 531230 531257 532737 532741 532779 532790 532960 533364 533949 534627 534987 535027 535358 536285 536290 536562 536618 536651 537763 537771 537885 537908 539239 555953 573920 589563 591668 596643 597791 599143 599950 600008 600012 600251 600346 600429 601620 601623 604456 617414 617429 622682 623204 625444 627805 628085 628089 628116 631947 632687 632699 633773 633787 634163 634202 634793 636286 636296 637113 637125 639753 640728 641702 641708 643122 644066 644256 644962 731683 757355 761004 795514 804491 ] |
||||||||||||||||||||||||||||||
|
19.98 ms (10.16%) |
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 601620 625444 631947 634163 640728 641702 641708 600008 600012 617429 632699 633787 634202 637113 637125 644066 591668 596643 600346 628116 636286 643122 644256 589563 599143 599950 600251 600429 601623 623204 627805 628089 634793 639753 731683 795514 757355 761004 617414 622682 628085 632687 633773 636296 804491 428125 457077 481602 429775 463311 480420 481625 423654 444820 455088 453473 475703 517725 493810 496074 522903 492576 495269 522598 524193 525348 497776 510270 464650 573920 555953 597791 604456 527414 512508 334472 421537 427983 429799 443480 429804 443991 644962 447152 465025 472550 491263 519108 530381 530491 530624 531157 531225 531230 531257 532779 532790 534627 535027 536285 536290 536562 536618 536651 537763 537771 537885 537908 539239 500913 529420 530489 530650 532737 532741 532960 533364 533949 534987 535358 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.57%) |
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 334472 421537 423654 427983 428125 429775 429799 429804 443480 443991 444820 447152 453473 455088 457077 463311 464650 465025 472550 475703 480420 481602 481625 491263 492576 493810 495269 496074 497776 500913 510270 512508 517725 519108 522598 522903 524193 525348 527414 529420 530381 530489 530491 530624 530650 531157 531225 531230 531257 532737 532741 532779 532790 532960 533364 533949 534627 534987 535027 535358 536285 536290 536562 536618 536651 537763 537771 537885 537908 539239 555953 573920 589563 591668 596643 597791 599143 599950 600008 600012 600251 600346 600429 601620 601623 604456 617414 617429 622682 623204 625444 627805 628085 628089 628116 631947 632687 632699 633773 633787 634163 634202 634793 636286 636296 637113 637125 639753 640728 641702 641708 643122 644066 644256 644962 731683 757355 761004 795514 804491 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting bbc"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг bbc"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг bbc"
]
|
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.