Query Metrics
7
Database Queries
7
Different statements
145.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.53 ms (82.93%) |
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 34198 391048 412604 413007 414078 417242 417340 425573 433814 433965 441782 441788 442057 443950 454410 468516 484321 485610 491211 502592 502613 503069 503079 503515 507608 507705 512616 512670 513822 524240 527435 530066 530474 533196 537344 538527 539348 541023 543293 558810 565493 566651 566743 577493 578787 584339 588435 591913 591991 597723 600951 601222 604857 606252 606396 606925 607660 612675 622488 625909 629826 630332 631985 648167 654167 663830 664215 667752 677146 692840 700333 710119 716334 727144 729974 733350 745984 755589 756256 758178 759767 763982 764244 766341 769393 774006 776557 781900 781902 784836 787806 790826 793237 794175 794853 794876 797358 797360 797525 799094 800860 801513 802733 803806 804657 805610 807746 807755 812376 812391 813310 814115 816622 818559 819371 820096 821761 823881 823956 825385 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (10.16%) |
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 391048 417340 503079 733350 34198 417242 441782 441788 414078 425573 413007 433814 816622 818559 819371 823881 825385 814115 821761 820096 823956 491211 454410 485610 502613 503069 503515 507705 513822 524240 537344 512670 530066 538527 539348 577493 565493 541023 543293 584339 667752 692840 700333 648167 654167 663830 664215 710119 716334 677146 578787 607660 597723 600951 601222 606396 606925 625909 588435 591913 606252 622488 776557 781902 787806 794876 797358 799094 800860 802733 805610 807746 812376 812391 793237 794175 801513 803806 804657 813310 727144 755589 766341 794853 797360 807755 745984 758178 756256 763982 759767 764244 769393 774006 629826 630332 631985 781900 784836 790826 443950 433965 442057 468516 412604 484321 502592 512616 530474 507608 533196 527435 558810 566651 566743 604857 591991 612675 797525 729974 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (2.04%) |
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 34198 391048 412604 413007 414078 417242 417340 425573 433814 433965 441782 441788 442057 443950 454410 468516 484321 485610 491211 502592 502613 503069 503079 503515 507608 507705 512616 512670 513822 524240 527435 530066 530474 533196 537344 538527 539348 541023 543293 558810 565493 566651 566743 577493 578787 584339 588435 591913 591991 597723 600951 601222 604857 606252 606396 606925 607660 612675 622488 625909 629826 630332 631985 648167 654167 663830 664215 667752 677146 692840 700333 710119 716334 727144 729974 733350 745984 755589 756256 758178 759767 763982 764244 766341 769393 774006 776557 781900 781902 784836 787806 790826 793237 794175 794853 794876 797358 797360 797525 799094 800860 801513 802733 803806 804657 805610 807746 807755 812376 812391 813310 814115 816622 818559 819371 820096 821761 823881 823956 825385 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby пов"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby пов"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby pov"
]
|
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.