Query Metrics
7
Database Queries
7
Different statements
224.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.76 ms (88.27%) |
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 391264 400484 407801 410182 411925 412537 429936 446634 458163 461422 462235 474078 474408 488982 496148 500699 502810 505970 512892 516436 517439 538079 552019 555751 557581 557838 563751 570134 577666 578174 587986 590496 591730 605751 607526 607626 610115 610958 612263 614810 615110 617682 617880 617892 622076 628298 628510 629124 661901 665294 666715 666951 670914 677371 680536 685527 689399 697272 703758 707079 711586 714372 714531 714707 715935 716986 722140 725243 725251 725742 726725 728983 729056 730272 737842 739060 740806 742777 742851 744416 746185 750072 753429 759153 761525 767516 771437 773390 775464 776468 779882 781971 787646 788560 789269 792775 793068 794935 795059 799103 800976 801398 802046 802285 802311 802382 804027 804233 807705 808316 809996 810369 817262 818695 819334 819387 823835 824128 825152 825873 ] |
||||||||||||||||||||||||||||||
|
14.60 ms (6.52%) |
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 666715 666951 689399 670914 615110 617880 628510 775464 801398 802285 802311 802046 728983 730272 773390 725742 779882 804027 411925 488982 516436 461422 677371 685527 665294 578174 591730 612263 776468 802382 789269 739060 742777 750072 462235 474078 429936 800976 729056 714372 725251 500699 496148 577666 587986 614810 412537 825152 825873 818695 824128 823835 538079 697272 716986 617892 628298 622076 629124 746185 787646 742851 737842 761525 740806 703758 722140 781971 517439 474408 410182 407801 817262 819334 819387 400484 446634 505970 512892 557581 715935 714707 590496 617682 605751 799103 725243 607526 714531 391264 707079 458163 804233 726725 767516 607626 610958 792775 502810 563751 570134 552019 555751 557838 711586 661901 680536 610115 795059 788560 759153 793068 794935 807705 808316 809996 810369 744416 753429 771437 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (1.60%) |
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 391264 400484 407801 410182 411925 412537 429936 446634 458163 461422 462235 474078 474408 488982 496148 500699 502810 505970 512892 516436 517439 538079 552019 555751 557581 557838 563751 570134 577666 578174 587986 590496 591730 605751 607526 607626 610115 610958 612263 614810 615110 617682 617880 617892 622076 628298 628510 629124 661901 665294 666715 666951 670914 677371 680536 685527 689399 697272 703758 707079 711586 714372 714531 714707 715935 716986 722140 725243 725251 725742 726725 728983 729056 730272 737842 739060 740806 742777 742851 744416 746185 750072 753429 759153 761525 767516 771437 773390 775464 776468 779882 781971 787646 788560 789269 792775 793068 794935 795059 799103 800976 801398 802046 802285 802311 802382 804027 804233 807705 808316 809996 810369 817262 818695 819334 819387 823835 824128 825152 825873 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy pussy sperm"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая pussy сперм"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая pussy сперм"
]
|
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.