Query Metrics
7
Database Queries
7
Different statements
196.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.34 ms (87.72%) |
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 20190 79082 91379 95557 96297 96461 117221 130468 184359 320078 341622 381883 388091 389315 397192 397232 398666 400944 401325 403966 404192 408711 414058 467606 470273 476111 488721 495218 500363 517840 532662 532667 541853 544848 564392 571136 597018 601544 604566 605332 613179 615900 617421 622656 623508 629409 630536 630764 632628 632632 632650 632674 632706 633447 641628 642016 645891 648819 662020 666579 673363 673366 673369 674492 675296 680493 690809 692796 695188 695620 695930 699691 705514 709261 714613 717066 719335 721982 723468 724179 731844 738821 742015 742250 742430 756104 759326 759485 762268 766603 772667 772730 775766 775798 775810 775852 775857 775869 775878 788930 792059 802062 803347 803906 803910 805598 806268 815125 816938 817080 817348 817898 818468 818516 818517 818541 819272 823721 823944 824052 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (6.85%) |
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 675296 79082 775878 717066 775852 775857 756104 742250 532662 662020 495218 532667 500363 630764 632628 617421 184359 823721 815125 803347 805598 731844 742430 721982 680493 605332 802062 772730 408711 130468 96297 630536 632632 541853 632706 642016 96461 823944 824052 816938 817348 818516 818468 695188 695620 709261 604566 762268 803906 803910 341622 95557 397232 467606 641628 775869 775766 738821 20190 403966 564392 648819 719335 632674 601544 775810 792059 806268 724179 759326 613179 389315 388091 817080 517840 673369 674492 571136 629409 597018 775798 742015 759485 772667 632650 401325 117221 400944 414058 819272 544848 645891 633447 766603 404192 470273 476111 488721 320078 381883 91379 397192 398666 817898 818517 818541 690809 695930 699691 705514 714613 666579 673363 723468 673366 692796 615900 622656 623508 788930 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.44%) |
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 20190 79082 91379 95557 96297 96461 117221 130468 184359 320078 341622 381883 388091 389315 397192 397232 398666 400944 401325 403966 404192 408711 414058 467606 470273 476111 488721 495218 500363 517840 532662 532667 541853 544848 564392 571136 597018 601544 604566 605332 613179 615900 617421 622656 623508 629409 630536 630764 632628 632632 632650 632674 632706 633447 641628 642016 645891 648819 662020 666579 673363 673366 673369 674492 675296 680493 690809 692796 695188 695620 695930 699691 705514 709261 714613 717066 719335 721982 723468 724179 731844 738821 742015 742250 742430 756104 759326 759485 762268 766603 772667 772730 775766 775798 775810 775852 775857 775869 775878 788930 792059 802062 803347 803906 803910 805598 806268 815125 816938 817080 817348 817898 818468 818516 818517 818541 819272 823721 823944 824052 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang анал"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang анал"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.