Query Metrics
7
Database Queries
7
Different statements
166.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.61 ms (86.66%) |
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 85250 152765 233204 382781 385892 386309 386727 389696 396376 398003 400573 423922 437178 444246 483280 496878 498124 567484 578825 621786 633641 634903 685130 691717 691807 705117 711267 711290 712160 719408 727047 728888 730941 731230 731604 732545 735987 736732 738695 744358 744364 744377 745198 746037 746567 747490 748372 748813 748983 750239 754013 758659 758769 761279 761606 762404 762408 762945 764099 765405 765936 765938 766273 767363 769964 770076 771912 771935 772037 772423 772438 774996 778144 778188 778500 779735 780394 782525 783156 784171 786087 786877 787433 787969 789282 789601 790588 790732 790762 791249 791826 792229 792248 792696 792728 794283 794382 794640 794735 795175 795662 795854 796743 797041 797309 800083 800717 801005 801664 803894 803961 804020 804057 804911 804948 805649 810321 810877 810950 ] |
||||||||||||||||||||||||||||||
|
11.74 ms (7.04%) |
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 790732 791249 792229 792248 794640 795175 797041 801005 801664 804948 810950 727047 730941 731230 747490 748372 750239 754013 758659 758769 762945 772037 772423 783156 784171 786877 787969 790588 791826 792696 792728 795854 800083 800717 803961 804911 810321 810877 728888 732545 736732 738695 744364 748813 765938 766273 772438 744377 745198 764099 769964 744358 746567 748983 762404 762408 768728 770076 771935 731604 735987 746037 761279 761606 765405 765936 767363 771912 633641 634903 705117 711267 711290 712160 719408 774996 778144 778188 778500 779735 780394 782525 786087 787433 789282 789601 790762 794382 794735 795662 796743 797309 803894 804020 804057 382781 386309 400573 85250 396376 685130 385892 794283 152765 691807 233204 483280 496878 567484 423922 437178 389696 444246 398003 691717 578825 621786 805649 386727 498124 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.74%) |
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 85250 152765 233204 382781 385892 386309 386727 389696 396376 398003 400573 423922 437178 444246 483280 496878 498124 567484 578825 621786 633641 634903 685130 691717 691807 705117 711267 711290 712160 719408 727047 728888 730941 731230 731604 732545 735987 736732 738695 744358 744364 744377 745198 746037 746567 747490 748372 748813 748983 750239 754013 758659 758769 761279 761606 762404 762408 762945 764099 765405 765936 765938 766273 767363 769964 770076 771912 771935 772037 772423 772438 774996 778144 778188 778500 779735 780394 782525 783156 784171 786087 786877 787433 787969 789282 789601 790588 790732 790762 791249 791826 792229 792248 792696 792728 794283 794382 794640 794735 795175 795662 795854 796743 797041 797309 800083 800717 801005 801664 803894 803961 804020 804057 804911 804948 805649 810321 810877 810950 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife webcam"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.91%) |
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.