Query Metrics
7
Database Queries
7
Different statements
255.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.87 ms (87.19%) |
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 95855 154240 187954 188066 315244 362588 381946 390568 391588 394366 395842 396592 396707 398041 400474 400498 400506 400818 404644 408214 409682 410677 411704 414666 417174 421826 421834 421836 421847 421851 421855 421859 421873 421875 421899 421936 423934 426139 428143 429602 434201 439704 439770 439776 439802 441149 445707 451246 451316 451488 452234 453387 457432 461469 464326 464550 466603 468113 468362 469587 470726 472149 472159 473148 477589 478525 483637 483643 483732 484638 484763 493170 499025 502763 515499 516483 518137 526073 527914 530790 532913 532916 532926 532943 532950 532963 532965 532994 533003 533007 533013 534772 544490 548158 549844 555912 564064 574664 579704 581174 583701 587210 598141 605399 610350 616013 647982 655838 670951 675866 692444 703080 721381 724233 735103 738435 759733 788776 789747 815999 ] |
||||||||||||||||||||||||||||||
|
20.56 ms (8.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 421873 421851 461469 484638 154240 647982 789747 735103 738435 721381 394366 464326 583701 315244 396707 400506 414666 421899 439802 439704 468362 469587 473148 493170 516483 408214 398041 188066 815999 692444 587210 610350 759733 396592 410677 484763 574664 404644 421836 421855 527914 532913 605399 421859 395842 434201 452234 518137 530790 472159 655838 555912 400498 421875 428143 400474 421847 421936 426139 453387 464550 421826 451246 483637 533013 532943 544490 616013 457432 478525 466603 439770 445707 472149 502763 533007 532963 670951 95855 362588 429602 441149 532926 532994 533003 532916 534772 675866 703080 548158 598141 788776 724233 470726 468113 409682 187954 400818 451316 477589 515499 532950 532965 549844 564064 581174 579704 391588 423934 381946 390568 417174 451488 421834 411704 439776 526073 483643 483732 499025 ] |
||||||||||||||||||||||||||||||
|
4.55 ms (1.78%) |
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 95855 154240 187954 188066 315244 362588 381946 390568 391588 394366 395842 396592 396707 398041 400474 400498 400506 400818 404644 408214 409682 410677 411704 414666 417174 421826 421834 421836 421847 421851 421855 421859 421873 421875 421899 421936 423934 426139 428143 429602 434201 439704 439770 439776 439802 441149 445707 451246 451316 451488 452234 453387 457432 461469 464326 464550 466603 468113 468362 469587 470726 472149 472159 473148 477589 478525 483637 483643 483732 484638 484763 493170 499025 502763 515499 516483 518137 526073 527914 530790 532913 532916 532926 532943 532950 532963 532965 532994 533003 533007 533013 534772 544490 548158 549844 555912 564064 574664 579704 581174 583701 587210 598141 605399 610350 616013 647982 655838 670951 675866 692444 703080 721381 724233 735103 738435 759733 788776 789747 815999 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal рыжих"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.64%) |
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.