Query Metrics
7
Database Queries
7
Different statements
185.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.57 ms (85.97%) |
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 88182 154157 398116 410694 414662 416522 416536 416597 416616 416631 416639 417396 420864 423508 423936 429366 429410 435689 439052 441021 446251 447151 448795 453223 455133 455794 462845 465691 466476 468678 470471 471122 473038 475336 482190 486773 487281 502641 511869 514155 514257 519722 530110 531360 531586 534764 535438 536378 545392 546972 549496 554980 559783 560269 561346 562577 566822 568814 573188 573293 585854 588514 591395 595339 595847 598284 598616 602024 602241 604781 608869 614078 616117 635722 637347 637364 638693 638885 654257 656812 656905 663811 666011 666856 669386 670956 686139 691286 703277 703339 707710 709150 710068 713940 717660 739798 742715 745113 748499 748653 749958 752614 752650 752677 753198 755704 761191 779280 780306 780329 781298 782791 787815 789181 796946 800289 804939 810622 811690 827290 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (8.25%) |
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 703277 410694 416631 417396 429410 782791 462845 416522 416536 416639 439052 429366 486773 482190 536378 514155 573188 602024 811690 416616 446251 471122 441021 781298 796946 595847 656905 663811 470471 531360 531586 414662 423508 827290 455794 455133 473038 535438 560269 546972 568814 573293 554980 559783 666856 670956 602241 585854 608869 588514 598616 752614 752650 466476 638885 616117 787815 761191 154157 398116 780306 800289 779280 780329 88182 448795 654257 713940 638693 416597 514257 591395 423936 549496 656812 709150 686139 703339 666011 710068 614078 637364 598284 635722 637347 707710 435689 691286 748653 804939 810622 566822 562577 748499 755704 742715 745113 739798 749958 753198 717660 789181 420864 453223 487281 465691 511869 519722 475336 752677 502641 561346 447151 530110 534764 545392 669386 595339 604781 468678 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (2.17%) |
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 88182 154157 398116 410694 414662 416522 416536 416597 416616 416631 416639 417396 420864 423508 423936 429366 429410 435689 439052 441021 446251 447151 448795 453223 455133 455794 462845 465691 466476 468678 470471 471122 473038 475336 482190 486773 487281 502641 511869 514155 514257 519722 530110 531360 531586 534764 535438 536378 545392 546972 549496 554980 559783 560269 561346 562577 566822 568814 573188 573293 585854 588514 591395 595339 595847 598284 598616 602024 602241 604781 608869 614078 616117 635722 637347 637364 638693 638885 654257 656812 656905 663811 666011 666856 669386 670956 686139 691286 703277 703339 707710 709150 710068 713940 717660 739798 742715 745113 748499 748653 749958 752614 752650 752677 753198 755704 761191 779280 780306 780329 781298 782791 787815 789181 796946 800289 804939 810622 811690 827290 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur dildo sex"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск дилд секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.78%) |
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.