Query Metrics
7
Database Queries
7
Different statements
154.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.47 ms (83.88%) |
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 382419 384015 385086 390492 400128 402896 405505 414946 415594 430846 436250 437676 438009 462649 462708 478768 492079 492096 493121 533601 535835 542979 543807 556777 557812 559602 568313 571494 573227 575533 581119 581332 590190 595735 596477 596692 606417 607079 610717 619645 623296 635138 636053 650457 668401 673138 674650 676372 677133 684232 686035 688668 693256 694484 708460 727653 728218 730244 733029 734728 741613 742241 742709 743115 747919 750461 755466 756223 759580 775853 786510 787387 788157 792608 793662 795035 797667 797764 797781 797801 799463 802450 803548 804583 805015 807930 808191 810663 811062 811072 814596 814778 814926 815397 815406 815462 815484 815708 815718 815768 815928 816083 816087 816207 816918 817298 817718 817768 817924 817928 818053 818206 818343 818402 818802 818822 820780 820875 824247 824936 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (8.87%) |
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 811062 542979 493121 492096 430846 815718 820780 815406 817768 694484 596477 623296 811072 390492 405505 462708 438009 462649 415594 437676 816087 817924 595735 414946 385086 708460 727653 787387 818206 568313 673138 684232 824247 818343 581119 816918 814596 816207 818053 581332 543807 573227 674650 788157 743115 795035 808191 747919 797781 803548 817928 650457 797667 818822 596692 402896 557812 436250 817298 814926 815708 575533 619645 636053 793662 810663 741613 750461 607079 815768 817718 533601 556777 686035 668401 606417 590190 786510 805015 775853 799463 802450 742709 759580 792608 797764 733029 756223 728218 734728 755466 635138 804583 807930 478768 384015 814778 815928 492079 535835 676372 610717 797801 730244 742241 571494 400128 382419 815462 824936 816083 815397 815484 818802 818402 820875 559602 677133 688668 693256 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.13%) |
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 382419 384015 385086 390492 400128 402896 405505 414946 415594 430846 436250 437676 438009 462649 462708 478768 492079 492096 493121 533601 535835 542979 543807 556777 557812 559602 568313 571494 573227 575533 581119 581332 590190 595735 596477 596692 606417 607079 610717 619645 623296 635138 636053 650457 668401 673138 674650 676372 677133 684232 686035 688668 693256 694484 708460 727653 728218 730244 733029 734728 741613 742241 742709 743115 747919 750461 755466 756223 759580 775853 786510 787387 788157 792608 793662 795035 797667 797764 797781 797801 799463 802450 803548 804583 805015 807930 808191 810663 811062 811072 814596 814778 814926 815397 815406 815462 815484 815708 815718 815768 815928 816083 816087 816207 816918 817298 817718 817768 817924 817928 818053 818206 818343 818402 818802 818822 820780 820875 824247 824936 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cunnilingus lick mom"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс лиза mom"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс лиза mom"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.15%) |
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.