Query Metrics
7
Database Queries
7
Different statements
228.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.02 ms (90.32%) |
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 34830 58516 226195 382594 391294 392037 396400 400363 413503 419150 432086 444980 452109 452687 456331 459612 460065 460507 461055 471188 472069 475267 476481 476598 477213 480620 480707 480902 482778 484246 486606 497816 502214 503867 504895 506533 518787 520062 521914 523088 523092 523512 525954 526958 535918 544636 550366 550702 551175 551640 554563 558795 559882 566171 566222 568663 574995 578161 587209 588652 593403 598896 599631 599779 599811 601132 606262 607206 612028 612029 620656 626759 632074 632337 640827 655600 658767 663341 667417 672349 672403 672855 689302 691244 691600 693125 694362 718604 719052 727803 734394 737972 740301 748182 750336 756901 761792 766193 775299 777066 778909 785961 789325 794007 797854 798840 798882 798944 799012 799018 802239 811350 814713 817394 817454 817597 817680 818770 818786 818795 ] |
||||||||||||||||||||||||||||||
|
12.47 ms (5.47%) |
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 785961 789325 691600 693125 817394 486606 551640 452687 554563 814713 794007 718604 392037 599631 472069 756901 727803 504895 535918 525954 799018 391294 475267 667417 766193 476598 778909 550702 691244 523092 777066 482778 607206 601132 620656 459612 818786 566171 655600 719052 818795 521914 640827 689302 761792 797854 226195 523088 484246 526958 400363 460507 612028 737972 748182 461055 460065 663341 480620 550366 578161 444980 672855 34830 626759 477213 476481 382594 471188 452109 811350 456331 559882 775299 798840 798882 523512 497816 566222 672403 599811 798944 750336 734394 799012 818770 598896 551175 480707 606262 817597 413503 802239 817454 612029 520062 502214 587209 58516 817680 672349 588652 632074 632337 740301 480902 432086 503867 419150 518787 506533 599779 593403 396400 568663 544636 658767 574995 694362 558795 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.34%) |
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 34830 58516 226195 382594 391294 392037 396400 400363 413503 419150 432086 444980 452109 452687 456331 459612 460065 460507 461055 471188 472069 475267 476481 476598 477213 480620 480707 480902 482778 484246 486606 497816 502214 503867 504895 506533 518787 520062 521914 523088 523092 523512 525954 526958 535918 544636 550366 550702 551175 551640 554563 558795 559882 566171 566222 568663 574995 578161 587209 588652 593403 598896 599631 599779 599811 601132 606262 607206 612028 612029 620656 626759 632074 632337 640827 655600 658767 663341 667417 672349 672403 672855 689302 691244 691600 693125 694362 718604 719052 727803 734394 737972 740301 748182 750336 756901 761792 766193 775299 777066 778909 785961 789325 794007 797854 798840 798882 798944 799012 799018 802239 811350 814713 817394 817454 817597 817680 818770 818786 818795 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car blowjob bra"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин минет оральн секс бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.61%) |
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.