Query Metrics
7
Database Queries
7
Different statements
140.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.81 ms (82.60%) |
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 540099 541787 541788 541793 541795 541798 542447 542717 542718 542720 542724 544244 547411 547441 547515 548301 549037 550201 550864 554682 554683 554686 554707 555226 555967 559295 559423 561046 564281 565260 572262 574001 574342 576484 576559 577028 578718 585802 597227 597841 598193 598267 601513 605067 607906 617570 618144 620911 626402 627835 628368 628381 629646 630963 632565 632697 633768 633773 637122 637438 640037 641667 643737 644663 647726 651147 651784 659472 661654 664492 670404 670465 671977 672685 675010 676066 676111 677671 677784 678003 679280 679317 679630 679810 679863 680116 680126 680127 680149 680185 683262 689547 696098 702164 709874 716161 716600 719435 724731 725392 733381 733840 733842 734038 734827 736558 740835 744010 749924 786525 787858 787916 795990 796338 804304 804403 804408 812312 814157 814172 ] |
||||||||||||||||||||||||||||||
|
14.93 ms (10.65%) |
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 744010 643737 559295 672685 676111 680149 677671 679317 597841 675010 677784 540099 541795 577028 664492 647726 659472 671977 678003 679280 689547 572262 574001 644663 618144 734827 787858 578718 709874 679863 786525 702164 565260 597227 542724 550864 680127 676066 683262 628381 637122 637438 598193 725392 733842 734038 633773 651147 680126 628368 814172 542717 574342 541798 542720 549037 554707 564281 541788 544244 554683 559423 719435 651784 661654 630963 796338 804403 804408 812312 626402 804304 814157 670404 679630 598267 736558 632565 541793 547515 555226 547411 541787 548301 716600 547441 554686 585802 629646 620911 795990 733381 724731 740835 680116 576484 542718 561046 576559 670465 696098 554682 607906 627835 640037 787916 617570 716161 632697 641667 749924 633768 542447 601513 679810 605067 680185 733840 555967 550201 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.83%) |
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 540099 541787 541788 541793 541795 541798 542447 542717 542718 542720 542724 544244 547411 547441 547515 548301 549037 550201 550864 554682 554683 554686 554707 555226 555967 559295 559423 561046 564281 565260 572262 574001 574342 576484 576559 577028 578718 585802 597227 597841 598193 598267 601513 605067 607906 617570 618144 620911 626402 627835 628368 628381 629646 630963 632565 632697 633768 633773 637122 637438 640037 641667 643737 644663 647726 651147 651784 659472 661654 664492 670404 670465 671977 672685 675010 676066 676111 677671 677784 678003 679280 679317 679630 679810 679863 680116 680126 680127 680149 680185 683262 689547 696098 702164 709874 716161 716600 719435 724731 725392 733381 733840 733842 734038 734827 736558 740835 744010 749924 786525 787858 787916 795990 796338 804304 804403 804408 812312 814157 814172 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl piss"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.99%) |
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.