Query Metrics
7
Database Queries
7
Different statements
192.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.44 ms (82.30%) |
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 390573 407903 411975 414893 417095 418047 418956 420757 422170 423571 426658 427770 427971 428090 430644 437679 440744 442775 452633 455373 458985 460864 467663 467960 477597 477888 484296 490797 490825 491461 495143 496973 498811 501676 507909 511061 511287 511315 511319 511328 512875 513964 514488 515056 515575 517469 520437 520680 525307 527962 528562 528570 529331 531417 533278 534642 538624 540073 545139 546107 549686 549708 552994 560435 562975 569632 578762 580930 584111 584365 587821 589070 591315 591877 599010 603420 604677 612232 615919 618272 618735 620208 622366 630092 630664 635973 636579 637247 656495 666188 691201 702881 714779 716972 719851 720965 727032 728229 733236 735910 748218 756321 758210 761047 761293 764909 765463 768758 771442 783992 784754 785386 794247 795807 797012 797133 803208 805772 813029 814995 ] |
||||||||||||||||||||||||||||||
|
23.23 ms (12.07%) |
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 490797 490825 498811 511315 520680 515575 520437 531417 534642 538624 540073 511061 529331 533278 467663 546107 549686 549708 560435 545139 569632 580930 552994 656495 720965 666188 691201 702881 714779 719851 562975 578762 584111 604677 637247 599010 620208 591315 612232 615919 589070 591877 630092 794247 795807 803208 805772 813029 733236 761293 765463 784754 785386 748218 728229 756321 764909 735910 727032 758210 761047 618735 622366 630664 635973 783992 797133 428090 420757 442775 455373 390573 407903 426658 427770 460864 507909 514488 528570 477597 512875 618272 603420 491461 584365 716972 797012 771442 768758 527962 418956 477888 587821 636579 430644 440744 501676 418047 422170 423571 437679 411975 414893 417095 427971 814995 458985 467960 484296 452633 515056 496973 511319 511328 513964 525307 511287 517469 528562 495143 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.47%) |
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 390573 407903 411975 414893 417095 418047 418956 420757 422170 423571 426658 427770 427971 428090 430644 437679 440744 442775 452633 455373 458985 460864 467663 467960 477597 477888 484296 490797 490825 491461 495143 496973 498811 501676 507909 511061 511287 511315 511319 511328 512875 513964 514488 515056 515575 517469 520437 520680 525307 527962 528562 528570 529331 531417 533278 534642 538624 540073 545139 546107 549686 549708 552994 560435 562975 569632 578762 580930 584111 584365 587821 589070 591315 591877 599010 603420 604677 612232 615919 618272 618735 620208 622366 630092 630664 635973 636579 637247 656495 666188 691201 702881 714779 716972 719851 720965 727032 728229 733236 735910 748218 756321 758210 761047 761293 764909 765463 768758 771442 783992 784754 785386 794247 795807 797012 797133 803208 805772 813029 814995 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural milf creampie"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные milf creampie"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные milf creampie"
]
|
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.