Query Metrics
7
Database Queries
7
Different statements
145.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.09 ms (85.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 390575 398300 408885 412725 417478 428174 430347 445775 508353 513472 515267 529583 529709 529753 531794 532732 535185 536035 542142 547479 548947 548957 550904 564518 565575 568770 573734 574109 576590 576979 577313 580989 584021 584257 584298 584961 585898 588929 590806 592633 602293 604105 604767 605155 611437 612997 623207 634067 639363 640375 642165 648671 652954 656851 657467 657537 657562 658774 658785 658850 660043 660415 664094 664717 664733 671032 672315 672926 687325 696108 697994 700924 705452 706520 711628 717543 722284 736971 740909 742304 742316 742321 742351 743208 745462 747310 749129 749202 749215 749391 751013 752587 752620 752625 756830 761164 765248 770413 771178 776524 777001 778731 783948 785544 785582 791328 792064 792065 793281 793297 796930 799938 800537 800551 800807 805647 808328 813195 823317 ] |
||||||||||||||||||||||||||||||
|
12.50 ms (8.60%) |
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 776524 565575 584298 652954 696108 700924 584961 585898 592633 611437 792065 805647 751013 765248 785544 743208 749391 761164 604105 799938 697994 529583 736971 584257 398300 412725 547479 664094 664733 687325 576590 749129 749215 752587 745462 778731 742321 771178 574109 752620 823317 536035 531794 515267 529753 535185 656851 657537 705452 722284 548947 623207 793297 791328 752625 740909 756830 706520 783948 792064 813195 445775 604767 408885 573734 513472 508353 584021 595376 428174 529709 430347 417478 532732 564518 576979 542142 568770 577313 657467 672315 660415 602293 796930 742351 742316 747310 742304 770413 777001 390575 580989 550904 658850 671032 672926 658774 658785 648671 657562 660043 664717 711628 717543 548957 612997 640375 634067 639363 588929 590806 605155 642165 793281 808328 785582 800537 800551 800807 749202 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.71%) |
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 390575 398300 408885 412725 417478 428174 430347 445775 508353 513472 515267 529583 529709 529753 531794 532732 535185 536035 542142 547479 548947 548957 550904 564518 565575 568770 573734 574109 576590 576979 577313 580989 584021 584257 584298 584961 585898 588929 590806 592633 602293 604105 604767 605155 611437 612997 623207 634067 639363 640375 642165 648671 652954 656851 657467 657537 657562 658774 658785 658850 660043 660415 664094 664717 664733 671032 672315 672926 687325 696108 697994 700924 705452 706520 711628 717543 722284 736971 740909 742304 742316 742321 742351 743208 745462 747310 749129 749202 749215 749391 751013 752587 752620 752625 756830 761164 765248 770413 771178 776524 777001 778731 783948 785544 785582 791328 792064 792065 793281 793297 796930 799938 800537 800551 800807 805647 808328 813195 823317 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo ass anal"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло жоп анал"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.02%) |
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.