Query Metrics
7
Database Queries
7
Different statements
219.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.12 ms (89.45%) |
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 31708 383744 389525 395999 396910 401816 404278 408047 410724 415847 418646 419764 420218 421198 422779 423242 428960 429569 429936 430468 435596 435603 445971 446855 448547 452054 452442 454857 456400 460022 461487 463752 466395 468553 476149 484374 492815 500271 503797 505369 507290 510577 512200 512205 512210 512215 513193 516816 520151 525193 532084 537552 542944 545532 550748 550752 550763 551953 552001 552919 554307 556406 557199 559162 559864 559877 562849 564210 565213 565981 574959 578420 580197 584794 586643 588228 588233 590924 591720 591730 591836 591955 600516 603481 609992 619411 619412 622217 622622 623619 624831 627547 637421 638357 641482 650810 653247 658208 658222 658224 661020 665909 674547 688034 688579 688606 692389 702075 713526 738748 748685 760946 761537 768123 771807 784161 785024 816132 818148 818936 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (5.93%) |
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 658208 658222 658224 661020 713526 650810 688034 688579 688606 692389 590924 624831 591720 591730 638357 641482 586643 609992 619412 622622 738748 748685 771807 760946 761537 768123 784161 785024 418646 476149 404278 429936 396910 401816 408047 429569 456400 460022 512210 503797 484374 818148 532084 818936 448547 554307 559162 420218 537552 564210 588233 389525 435603 435596 816132 516816 512200 551953 665909 562849 591836 591955 600516 622217 603481 428960 395999 410724 452054 512205 520151 512215 542944 552919 559877 550752 556406 580197 550748 550763 584794 588228 623619 619411 419764 468553 466395 513193 445971 637421 565981 674547 627547 383744 31708 421198 422779 423242 430468 415847 463752 446855 452442 454857 492815 525193 500271 505369 510577 507290 461487 559864 565213 552001 557199 578420 545532 574959 702075 653247 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.19%) |
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 31708 383744 389525 395999 396910 401816 404278 408047 410724 415847 418646 419764 420218 421198 422779 423242 428960 429569 429936 430468 435596 435603 445971 446855 448547 452054 452442 454857 456400 460022 461487 463752 466395 468553 476149 484374 492815 500271 503797 505369 507290 510577 512200 512205 512210 512215 513193 516816 520151 525193 532084 537552 542944 545532 550748 550752 550763 551953 552001 552919 554307 556406 557199 559162 559864 559877 562849 564210 565213 565981 574959 578420 580197 584794 586643 588228 588233 590924 591720 591730 591836 591955 600516 603481 609992 619411 619412 622217 622622 623619 624831 627547 637421 638357 641482 650810 653247 658208 658222 658224 661020 665909 674547 688034 688579 688606 692389 702075 713526 738748 748685 760946 761537 768123 771807 784161 785024 816132 818148 818936 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy asian"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy азиатк"
]
|
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.