Query Metrics
7
Database Queries
7
Different statements
175.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.33 ms (86.04%) |
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 365903 365965 384976 391554 391662 411257 414760 424493 425889 426886 441744 443997 451317 451699 454891 456495 458755 460365 461443 461524 462108 462559 462728 463331 465098 469975 476992 477132 480831 481001 481061 484056 485088 486833 491414 494366 502201 502710 504214 508075 508865 510677 517054 519778 522822 536173 543839 545699 545977 546355 547823 552233 552401 552622 553586 554983 561880 561929 562242 562290 562494 562996 563411 565324 569070 569917 571987 573078 573102 573125 573420 573578 573675 573875 576109 587100 588899 590325 595418 595870 596577 597060 597533 597593 598032 598481 598782 618232 624849 625620 652960 655664 657009 660923 663785 670270 714497 718734 722825 722848 724707 742181 742192 743253 751282 753364 761900 766506 767448 769318 777197 778630 779894 792800 804872 811439 819100 820140 825920 826527 ] |
||||||||||||||||||||||||||||||
|
14.78 ms (8.40%) |
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 624849 625620 811439 724707 743253 742181 742192 753364 792800 663785 767448 722848 414760 517054 536173 718734 777197 778630 384976 825920 652960 655664 576109 569070 547823 552401 565324 598481 569917 597593 553586 573578 545699 562290 587100 597533 561929 804872 573875 562996 573102 543839 573078 761900 391554 571987 561880 563411 552622 596577 597060 598032 588899 595870 595418 598782 590325 722825 469975 443997 485088 494366 391662 484056 562242 454891 522822 819100 365965 365903 441744 573420 779894 766506 751282 451699 460365 714497 562494 670270 820140 826527 660923 657009 769318 618232 481061 546355 554983 573675 545977 552233 426886 462559 462728 463331 481001 456495 465098 477132 425889 424493 451317 461443 462108 476992 480831 411257 458755 461524 510677 491414 508075 508865 502201 502710 486833 504214 519778 573125 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.51%) |
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 365903 365965 384976 391554 391662 411257 414760 424493 425889 426886 441744 443997 451317 451699 454891 456495 458755 460365 461443 461524 462108 462559 462728 463331 465098 469975 476992 477132 480831 481001 481061 484056 485088 486833 491414 494366 502201 502710 504214 508075 508865 510677 517054 519778 522822 536173 543839 545699 545977 546355 547823 552233 552401 552622 553586 554983 561880 561929 562242 562290 562494 562996 563411 565324 569070 569917 571987 573078 573102 573125 573420 573578 573675 573875 576109 587100 588899 590325 595418 595870 596577 597060 597533 597593 598032 598481 598782 618232 624849 625620 652960 655664 657009 660923 663785 670270 714497 718734 722825 722848 724707 742181 742192 743253 751282 753364 761900 766506 767448 769318 777197 778630 779894 792800 804872 811439 819100 820140 825920 826527 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits russian"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ русск"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
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.