Query Metrics
7
Database Queries
7
Different statements
197.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.38 ms (88.81%) |
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 393881 395424 396619 497782 530427 537959 575684 588001 594355 595602 600949 605495 616060 623652 626121 635325 635782 636955 637297 639111 640372 641197 645058 648225 649069 656616 679596 679879 680342 681163 685734 689540 693218 693677 695695 698195 698739 701316 703409 707166 711802 715657 716626 718139 718639 719814 720242 725240 728681 729036 729105 730033 730128 731212 733933 734329 737532 737568 738277 740769 747965 751300 751480 754481 756908 759685 760264 760323 761328 763413 764239 764386 764555 764991 766140 769227 770026 771476 772867 773682 775290 777489 778530 778552 779759 780853 781088 784625 784627 786640 786753 789633 790637 791824 792477 793043 793517 793755 795910 797035 797063 797188 797367 800313 800540 803447 803620 804593 811254 816626 817653 819897 825361 826157 826194 826205 827209 827594 827657 827832 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (6.55%) |
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 800313 784627 792477 804593 747965 761328 771476 760323 764239 740769 764386 779759 784625 797063 827832 537959 497782 575684 645058 679596 679879 693218 695695 715657 649069 656616 685734 689540 698739 701316 720242 648225 681163 693677 626121 640372 616060 637297 595602 605495 635325 635782 588001 600949 803620 729036 729105 730033 763413 641197 703409 718639 718139 797188 393881 396619 825361 826205 816626 827209 827594 826157 826194 530427 698195 636955 623652 778530 775290 786753 728681 733933 751480 756908 760264 764555 764991 772867 811254 725240 737532 737568 759685 770026 730128 738277 751300 734329 754481 769227 731212 766140 773682 777489 778552 789633 793043 793517 795910 395424 680342 707166 594355 711802 639111 793755 817653 819897 827657 719814 716626 780853 781088 797367 803447 786640 790637 791824 797035 800540 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.39%) |
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 393881 395424 396619 497782 530427 537959 575684 588001 594355 595602 600949 605495 616060 623652 626121 635325 635782 636955 637297 639111 640372 641197 645058 648225 649069 656616 679596 679879 680342 681163 685734 689540 693218 693677 695695 698195 698739 701316 703409 707166 711802 715657 716626 718139 718639 719814 720242 725240 728681 729036 729105 730033 730128 731212 733933 734329 737532 737568 738277 740769 747965 751300 751480 754481 756908 759685 760264 760323 761328 763413 764239 764386 764555 764991 766140 769227 770026 771476 772867 773682 775290 777489 778530 778552 779759 780853 781088 784625 784627 786640 786753 789633 790637 791824 792477 793043 793517 793755 795910 797035 797063 797188 797367 800313 800540 803447 803620 804593 811254 816626 817653 819897 825361 826157 826194 826205 827209 827594 827657 827832 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep amateur"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep любительск"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep любительск"
]
|
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.