Query Metrics
7
Database Queries
7
Different statements
184.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.18 ms (83.97%) |
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 38953 53510 123955 143085 213057 281927 282481 282494 286475 365938 383495 385304 385505 386514 386846 387186 387922 390601 390701 392609 398458 400056 401522 401588 403028 403216 407058 410753 410855 415109 422000 423329 428353 430661 433339 448811 462535 463777 466787 466989 473102 474663 477744 484542 486540 489443 489646 489831 495198 495741 502326 503194 504161 510360 511925 514841 515257 522381 523538 527653 534219 541751 541919 548519 552008 556852 563014 565571 568997 576678 585961 590894 591437 592391 593992 596550 598111 623912 632314 640688 640695 640700 647933 650421 651870 663502 672099 672184 686021 696598 708919 716298 729223 731777 733347 742906 748741 749873 760834 767957 770902 775028 775995 775998 783790 786039 787912 790802 791571 792486 793406 797445 800260 807192 807715 812510 816773 820152 823282 827419 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (9.80%) |
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 489831 522381 504161 385505 576678 800260 716298 400056 282481 650421 590894 503194 812510 563014 387922 511925 568997 632314 53510 552008 749873 462535 495741 647933 733347 477744 466989 640700 797445 428353 591437 281927 143085 640688 433339 729223 123955 401588 823282 696598 541751 791571 484542 775995 422000 463777 390601 430661 38953 593992 514841 565571 748741 663502 392609 386514 585961 770902 775028 596550 790802 489443 556852 807715 523538 510360 448811 474663 708919 403028 515257 548519 398458 816773 651870 592391 401522 489646 473102 423329 495198 534219 466787 640695 415109 541919 386846 282494 410855 213057 390701 672184 686021 807192 731777 387186 672099 598111 792486 793406 365938 286475 385304 783790 786039 787912 742906 760834 767957 820152 775998 403216 502326 410753 827419 486540 527653 407058 623912 383495 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.00%) |
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 38953 53510 123955 143085 213057 281927 282481 282494 286475 365938 383495 385304 385505 386514 386846 387186 387922 390601 390701 392609 398458 400056 401522 401588 403028 403216 407058 410753 410855 415109 422000 423329 428353 430661 433339 448811 462535 463777 466787 466989 473102 474663 477744 484542 486540 489443 489646 489831 495198 495741 502326 503194 504161 510360 511925 514841 515257 522381 523538 527653 534219 541751 541919 548519 552008 556852 563014 565571 568997 576678 585961 590894 591437 592391 593992 596550 598111 623912 632314 640688 640695 640700 647933 650421 651870 663502 672099 672184 686021 696598 708919 716298 729223 731777 733347 742906 748741 749873 760834 767957 770902 775028 775995 775998 783790 786039 787912 790802 791571 792486 793406 797445 800260 807192 807715 812510 816773 820152 823282 827419 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сборник куни жмж"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк куннилингус оральн секс жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
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.