Query Metrics
7
Database Queries
7
Different statements
163.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.33 ms (80.48%) |
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 147400 382199 382662 383650 389813 392928 399411 406002 406513 432105 433836 434846 450111 453134 456880 458098 464604 465191 479329 483010 488602 494814 506487 507349 525581 527273 529255 530059 543866 551482 552049 552331 559514 567674 573054 573927 575508 580591 586312 590101 590147 590173 590406 595040 599183 601328 604500 616771 629050 638923 649159 651323 652121 661787 662383 663165 665260 669192 670622 675394 679836 686009 688589 694612 694784 698025 706567 707871 715551 717123 717770 719726 719780 720739 723293 726067 727656 731881 732572 732751 733278 733542 734448 738338 748607 755256 755432 760064 762468 763762 764318 764319 768269 769340 769585 772922 773498 774264 779613 784281 785210 785660 786175 791679 792781 794415 794812 796866 797845 798323 800171 800258 800367 801984 802597 805301 809888 810245 810979 811182 ] |
||||||||||||||||||||||||||||||
|
20.81 ms (12.75%) |
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 686009 527273 698025 694784 719780 616771 805301 755432 763762 772922 406513 392928 456880 543866 774264 580591 786175 800258 479329 769340 665260 601328 586312 801984 800171 794812 802597 731881 732572 768269 755256 809888 399411 662383 573054 590406 762468 147400 506487 715551 652121 769585 432105 389813 529255 551482 649159 559514 567674 764318 434846 732751 706567 382199 450111 675394 720739 810245 638923 552331 811182 663165 794415 748607 764319 800367 791679 383650 590173 719726 727656 453134 530059 669192 688589 717770 590147 595040 726067 604500 599183 785210 797845 785660 734448 733278 738338 779613 792781 670622 552049 784281 679836 651323 661787 733542 629050 717123 433836 573927 406002 464604 494814 723293 694612 707871 796866 488602 590101 760064 575508 810979 465191 773498 507349 483010 525581 458098 798323 382662 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (2.24%) |
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 147400 382199 382662 383650 389813 392928 399411 406002 406513 432105 433836 434846 450111 453134 456880 458098 464604 465191 479329 483010 488602 494814 506487 507349 525581 527273 529255 530059 543866 551482 552049 552331 559514 567674 573054 573927 575508 580591 586312 590101 590147 590173 590406 595040 599183 601328 604500 616771 629050 638923 649159 651323 652121 661787 662383 663165 665260 669192 670622 675394 679836 686009 688589 694612 694784 698025 706567 707871 715551 717123 717770 719726 719780 720739 723293 726067 727656 731881 732572 732751 733278 733542 734448 738338 748607 755256 755432 760064 762468 763762 764318 764319 768269 769340 769585 772922 773498 774264 779613 784281 785210 785660 786175 791679 792781 794415 794812 796866 797845 798323 800171 800258 800367 801984 802597 805301 809888 810245 810979 811182 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"огромный хуй отсос"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромный член минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
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.