Query Metrics
7
Database Queries
7
Different statements
163.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.45 ms (84.74%) |
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 328534 384807 389024 395549 395640 397129 399853 401105 401113 401134 401279 404765 404950 410606 412299 412756 416086 417476 417647 418411 419855 422550 422566 422609 422925 423000 423039 431452 432794 433652 440996 445269 445564 447242 463910 465953 472426 472928 473733 490567 491487 508143 511836 512049 518456 518541 522466 526030 537893 538837 541324 554416 559214 560184 560635 564066 565536 577369 588376 599711 600123 603970 610559 610607 614065 617350 618449 619367 622371 624281 628403 630018 636555 644657 649163 651136 660963 663976 666968 684993 685001 696218 703101 707322 708473 710933 719011 719067 724186 727801 731869 732055 732070 736042 737169 741286 746990 747008 747583 747976 752126 766874 771829 788800 800332 804469 805504 807301 808116 809228 809687 809928 810069 811863 811944 814878 815329 817448 819588 ] |
||||||||||||||||||||||||||||||
|
14.49 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 804469 805504 808116 809687 809928 810069 811944 724186 727801 731869 736042 746990 747976 766874 732055 732070 741286 747008 752126 771829 747583 630018 636555 644657 703101 708473 710933 719011 788800 800332 807301 809228 811863 431452 401134 416086 422925 432794 395549 472426 473733 737169 395640 328534 401105 401279 419855 422550 417476 417647 617350 518541 508143 518456 522466 465953 559214 560635 554416 651136 685001 707322 663976 666968 577369 600123 624281 588376 628403 618449 610559 610607 410606 447242 401113 404950 412299 418411 445564 412756 472928 440996 599711 384807 389024 397129 399853 404765 423039 422609 422566 433652 445269 423000 815329 817448 814878 819588 490567 491487 463910 512049 526030 537893 538837 511836 541324 565536 649163 660963 662221 684993 696218 719067 560184 564066 603970 619367 614065 622371 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.82%) |
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 328534 384807 389024 395549 395640 397129 399853 401105 401113 401134 401279 404765 404950 410606 412299 412756 416086 417476 417647 418411 419855 422550 422566 422609 422925 423000 423039 431452 432794 433652 440996 445269 445564 447242 463910 465953 472426 472928 473733 490567 491487 508143 511836 512049 518456 518541 522466 526030 537893 538837 541324 554416 559214 560184 560635 564066 565536 577369 588376 599711 600123 603970 610559 610607 614065 617350 618449 619367 622371 624281 628403 630018 636555 644657 649163 651136 660963 663976 666968 684993 685001 696218 703101 707322 708473 710933 719011 719067 724186 727801 731869 732055 732070 736042 737169 741286 746990 747008 747583 747976 752126 766874 771829 788800 800332 804469 805504 807301 808116 809228 809687 809928 810069 811863 811944 814878 815329 817448 819588 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал old young"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal old young"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал old young"
]
|
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.