Query Metrics
7
Database Queries
7
Different statements
367.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
339.74 ms (92.43%) |
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 150261 181122 291356 391908 395644 395898 415588 417223 417726 424882 443840 444383 445291 457504 461809 462538 466055 469887 474056 474711 480955 482154 485795 490806 495715 507871 510168 515776 518274 523263 523484 526037 527148 546638 547989 551005 558822 562286 570746 573247 575100 576026 580752 586305 589457 592813 596415 599131 606639 609536 614067 621220 625065 630803 632922 641345 641369 645925 663408 663486 664605 664801 666421 669457 670010 671305 672800 677920 687119 716343 717036 718200 719062 725048 726372 726786 732592 749989 755460 758213 758557 759482 760653 760821 760823 764593 767279 767820 770113 770543 773805 785767 790954 795547 796468 801056 801508 801518 801522 802284 805206 805978 806840 810258 811151 812965 814240 817688 817849 817963 818391 818833 821838 823176 823466 824177 824273 824405 826198 827103 ] |
||||||||||||||||||||||||||||||
|
17.55 ms (4.77%) |
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 806840 725048 466055 462538 181122 424882 417726 824177 824405 507871 551005 687119 716343 558822 614067 641345 755460 795547 758213 758557 760653 785767 469887 474056 417223 495715 666421 663408 672800 669457 570746 606639 609536 641369 801518 805206 811151 801508 805978 812965 801056 726372 760821 767820 749989 770113 773805 732592 764593 767279 770543 625065 719062 801522 802284 291356 443840 490806 596415 630803 395898 575100 391908 523484 444383 821838 485795 515776 474711 576026 580752 645925 664801 562286 599131 632922 621220 810258 457504 461809 480955 523263 526037 415588 445291 547989 527148 717036 589457 796468 790954 759482 726786 760823 150261 395644 817963 818833 826198 814240 817849 818391 827103 817688 823176 823466 824273 510168 518274 482154 573247 671305 663486 664605 670010 677920 718200 546638 586305 592813 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (0.78%) |
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 150261 181122 291356 391908 395644 395898 415588 417223 417726 424882 443840 444383 445291 457504 461809 462538 466055 469887 474056 474711 480955 482154 485795 490806 495715 507871 510168 515776 518274 523263 523484 526037 527148 546638 547989 551005 558822 562286 570746 573247 575100 576026 580752 586305 589457 592813 596415 599131 606639 609536 614067 621220 625065 630803 632922 641345 641369 645925 663408 663486 664605 664801 666421 669457 670010 671305 672800 677920 687119 716343 717036 718200 719062 725048 726372 726786 732592 749989 755460 758213 758557 759482 760653 760821 760823 764593 767279 767820 770113 770543 773805 785767 790954 795547 796468 801056 801508 801518 801522 802284 805206 805978 806840 810258 811151 812965 814240 817688 817849 817963 818391 818833 821838 823176 823466 824177 824273 824405 826198 827103 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob condom"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс condom"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс condom"
]
|
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.