Query Metrics
7
Database Queries
7
Different statements
281.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
250.75 ms (89.21%) |
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 102147 212183 383344 385761 390492 392597 395781 396510 408136 409933 411004 411073 411334 411343 411675 412975 414761 415935 424495 426238 426364 426429 427152 430240 438397 440689 443732 444131 444848 445060 447043 447513 447745 450286 450935 453858 460904 464440 464628 465757 466046 467302 468304 469225 470544 473960 475532 475825 475878 480912 482566 482579 485062 491907 491956 494823 499967 504142 504823 508246 509972 510351 513404 513418 515621 516622 517350 521793 522953 523989 540490 543434 549222 552652 552679 553306 554951 560640 565921 568053 568851 570118 573127 573227 573514 576685 578462 581351 593002 606036 644688 674632 675104 675139 689808 698491 715559 716375 719117 720530 721721 727451 730191 730396 736834 747959 760418 760632 760668 770883 777118 777882 782773 785361 786119 799387 800111 800145 802755 803008 ] |
||||||||||||||||||||||||||||||
|
20.96 ms (7.46%) |
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 482579 464628 516622 392597 485062 453858 447745 468304 411073 509972 720530 411343 450286 802755 212183 552652 475532 414761 517350 782773 800145 390492 573514 411675 482566 499967 444131 411004 427152 560640 460904 396510 573127 576685 522953 513404 424495 411334 508246 736834 470544 469225 383344 510351 606036 491956 689808 409933 777882 426364 466046 786119 430240 543434 800111 568053 573227 716375 674632 747959 513418 568851 412975 443732 465757 415935 553306 540490 554951 385761 438397 504823 785361 727451 565921 473960 447513 444848 730396 721721 426238 467302 475878 570118 581351 593002 803008 445060 675104 675139 450935 521793 494823 395781 464440 715559 426429 730191 644688 440689 475825 102147 552679 770883 523989 504142 480912 578462 447043 491907 408136 515621 698491 719117 777118 760418 760668 799387 549222 760632 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.91%) |
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 102147 212183 383344 385761 390492 392597 395781 396510 408136 409933 411004 411073 411334 411343 411675 412975 414761 415935 424495 426238 426364 426429 427152 430240 438397 440689 443732 444131 444848 445060 447043 447513 447745 450286 450935 453858 460904 464440 464628 465757 466046 467302 468304 469225 470544 473960 475532 475825 475878 480912 482566 482579 485062 491907 491956 494823 499967 504142 504823 508246 509972 510351 513404 513418 515621 516622 517350 521793 522953 523989 540490 543434 549222 552652 552679 553306 554951 560640 565921 568053 568851 570118 573127 573227 573514 576685 578462 581351 593002 606036 644688 674632 675104 675139 689808 698491 715559 716375 719117 720530 721721 727451 730191 730396 736834 747959 760418 760632 760668 770883 777118 777882 782773 785361 786119 799387 800111 800145 802755 803008 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни в трус"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс в трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.47%) |
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.