Query Metrics
7
Database Queries
7
Different statements
220.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.40 ms (88.48%) |
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 73425 79355 154410 191323 382188 388411 391113 395669 396538 396704 401316 404459 405056 405535 406390 413788 414361 415155 416063 421200 422063 422666 424927 428116 429950 429999 430762 433835 437511 438235 443090 445726 448869 449933 452311 454785 464651 467592 467615 472393 472488 475479 477072 477470 481144 488904 494359 503838 509805 510161 513850 518438 521469 522147 528580 530384 530503 532241 537686 538815 540504 560941 574908 583701 585377 585952 591347 591513 595722 595728 600061 600401 600495 601600 601707 602008 603180 604457 604527 606366 606496 606780 606873 612073 612182 613825 614022 614305 616071 617421 620857 624871 632618 638997 642835 644679 675012 678128 680206 715533 725633 732799 742579 744602 744632 772681 772815 773998 774227 775787 775974 790390 792636 795485 805438 807641 807692 807789 809525 813014 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (7.09%) |
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 595728 604457 616071 624871 644679 591513 595722 606496 612073 614022 614305 620857 638997 585952 591347 603180 604527 606366 606780 606873 612182 642835 775787 809525 805438 725633 732799 772681 772815 773998 790390 807641 807692 807789 744632 774227 742579 744602 613825 715533 775974 792636 795485 813014 79355 382188 191323 388411 395669 430762 396704 413788 415155 454785 472393 414361 494359 73425 401316 406390 416063 429950 445726 391113 422666 396538 448869 510161 405056 600495 422063 438235 154410 433835 449933 477072 503838 509805 467592 477470 680206 560941 602008 600061 600401 585377 601707 481144 472488 475479 521469 528580 429999 583701 518438 675012 530384 678128 601600 632618 404459 421200 464651 574908 467615 405535 424927 617421 522147 537686 538815 488904 428116 443090 437511 452311 530503 513850 532241 540504 ] |
||||||||||||||||||||||||||||||
|
3.07 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 73425 79355 154410 191323 382188 388411 391113 395669 396538 396704 401316 404459 405056 405535 406390 413788 414361 415155 416063 421200 422063 422666 424927 428116 429950 429999 430762 433835 437511 438235 443090 445726 448869 449933 452311 454785 464651 467592 467615 472393 472488 475479 477072 477470 481144 488904 494359 503838 509805 510161 513850 518438 521469 522147 528580 530384 530503 532241 537686 538815 540504 560941 574908 583701 585377 585952 591347 591513 595722 595728 600061 600401 600495 601600 601707 602008 603180 604457 604527 606366 606496 606780 606873 612073 612182 613825 614022 614305 616071 617421 620857 624871 632618 638997 642835 644679 675012 678128 680206 715533 725633 732799 742579 744602 744632 772681 772815 773998 774227 775787 775974 790390 792636 795485 805438 807641 807692 807789 809525 813014 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings interracial"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.