Query Metrics
7
Database Queries
7
Different statements
142.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.22 ms (83.60%) |
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 382654 433531 477472 504268 512398 533167 536113 545513 545561 546547 554257 555177 559933 561798 579057 588715 600515 607005 610260 610308 613373 624974 625473 626524 630504 633706 635099 635142 639153 640997 643146 647797 654137 656868 658901 661099 661789 663690 665077 666347 668893 669558 684880 689493 692904 693395 696328 699122 704804 705806 706146 710802 710945 716456 718333 718654 720149 722031 723766 724693 724821 726097 726412 726438 726750 727428 728105 728122 728978 729880 729932 730119 730805 733422 733648 734110 734267 734537 737067 737351 738179 738221 738941 739700 739859 740548 742918 745923 746600 747416 751496 753218 759814 760496 765689 772525 772773 773061 780094 784861 787015 794662 800351 800765 800775 810266 815537 816578 816724 816967 818304 821005 821025 821994 822631 822714 826110 827930 828589 ] |
||||||||||||||||||||||||||||||
|
13.50 ms (9.47%) |
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 555177 624974 739700 727428 822714 826110 825178 815537 818304 821005 827930 545513 647797 656868 666347 699122 704804 720149 663690 696328 705806 710945 718654 654137 661099 661789 684880 692904 693395 722031 545561 546547 610260 625473 635099 588715 600515 610308 800775 723766 729880 729932 737351 742918 747416 753218 772773 773061 787015 738179 738941 730805 739859 751496 760496 726412 730119 765689 639153 706146 800351 800765 669558 772525 810266 734537 726438 734110 816578 821994 816967 821025 822631 828589 533167 536113 512398 689493 579057 626524 630504 784861 734267 794662 728105 728122 746600 504268 665077 716456 724693 724821 816724 477472 561798 668893 554257 635142 780094 737067 733648 738221 607005 559933 433531 382654 633706 643146 728978 718333 745923 658901 710802 613373 640997 733422 726097 740548 759814 726750 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (2.03%) |
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 382654 433531 477472 504268 512398 533167 536113 545513 545561 546547 554257 555177 559933 561798 579057 588715 600515 607005 610260 610308 613373 624974 625473 626524 630504 633706 635099 635142 639153 640997 643146 647797 654137 656868 658901 661099 661789 663690 665077 666347 668893 669558 684880 689493 692904 693395 696328 699122 704804 705806 706146 710802 710945 716456 718333 718654 720149 722031 723766 724693 724821 726097 726412 726438 726750 727428 728105 728122 728978 729880 729932 730119 730805 733422 733648 734110 734267 734537 737067 737351 738179 738221 738941 739700 739859 740548 742918 745923 746600 747416 751496 753218 759814 760496 765689 772525 772773 773061 780094 784861 787015 794662 800351 800765 800775 810266 815537 816578 816724 816967 818304 821005 821025 821994 822631 822714 826110 827930 828589 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation dick"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац член"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.00%) |
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.