Query Metrics
7
Database Queries
7
Different statements
219.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.90 ms (89.28%) |
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 8956 70191 381917 384138 384769 392270 401084 405221 405848 407515 409105 409404 411916 422043 424261 426316 433434 435001 435350 439668 444095 445360 455297 456453 459022 460307 464708 465897 465906 466904 468105 468180 469565 472069 478121 480212 482763 482907 488137 488603 491830 491926 491975 491982 492003 498598 500059 502506 503682 504638 505702 509234 512500 513204 514092 514129 515694 515707 520490 520640 520819 522849 525883 528733 530011 531278 531524 533346 541398 544484 544600 546767 554906 556659 565837 566464 585442 591126 593236 595456 598617 602996 606580 608227 610532 619858 621687 623488 624756 665187 665875 666495 671222 673430 679369 703085 717735 723083 729886 736623 739904 744339 745342 747972 752461 758026 758553 761809 761823 762568 772412 784857 785932 802467 802950 811489 813767 815683 817247 828387 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (6.70%) |
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 513204 482763 482907 435001 478121 514129 619858 624756 444095 8956 480212 460307 515694 522849 621687 409105 409404 492003 813767 817247 802467 745342 546767 758553 739904 723083 744339 772412 747972 752461 673430 384138 514092 544600 593236 445360 544484 554906 565837 679369 671222 556659 595456 610532 598617 585442 785932 729886 762568 761823 761809 70191 665187 608227 384769 405848 405221 488137 502506 815683 703085 717735 802950 811489 736623 591126 828387 784857 381917 455297 665875 623488 515707 533346 407515 606580 541398 435350 401084 531278 531524 498598 512500 520819 424261 439668 525883 433434 602996 500059 528733 491830 459022 530011 392270 464708 411916 566464 666495 758026 422043 426316 469565 465897 488603 509234 505702 466904 472069 465906 468180 456453 468105 491982 503682 491926 491975 520490 520640 504638 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.06%) |
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 8956 70191 381917 384138 384769 392270 401084 405221 405848 407515 409105 409404 411916 422043 424261 426316 433434 435001 435350 439668 444095 445360 455297 456453 459022 460307 464708 465897 465906 466904 468105 468180 469565 472069 478121 480212 482763 482907 488137 488603 491830 491926 491975 491982 492003 498598 500059 502506 503682 504638 505702 509234 512500 513204 514092 514129 515694 515707 520490 520640 520819 522849 525883 528733 530011 531278 531524 533346 541398 544484 544600 546767 554906 556659 565837 566464 585442 591126 593236 595456 598617 602996 606580 608227 610532 619858 621687 623488 624756 665187 665875 666495 671222 673430 679369 703085 717735 723083 729886 736623 739904 744339 745342 747972 752461 758026 758553 761809 761823 762568 772412 784857 785932 802467 802950 811489 813767 815683 817247 828387 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings big cock"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.