Query Metrics
7
Database Queries
7
Different statements
267.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.80 ms (86.06%) |
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 7011 388772 391545 393868 398874 418808 420277 421520 421563 426200 439027 439218 442632 444244 446160 446874 447528 447809 447893 449456 451616 473087 473931 476054 490794 495824 497467 508204 518472 529025 535006 536256 544858 545809 552395 554764 557415 558846 561657 561668 561702 561722 561903 562626 563647 565255 565951 570469 573041 573676 574540 574585 575096 575212 575492 575495 575771 575798 576407 584287 586473 592381 594301 595375 595458 595477 597469 597536 597951 597987 598010 598547 598599 598612 598722 598734 598788 603464 603922 608472 609388 610657 612441 617179 619171 623201 626316 639555 649166 652616 659106 675797 678783 683584 696114 714432 722585 722625 725640 730728 730764 735112 738640 745496 747389 753155 753971 766845 767315 770427 779010 781366 782087 786274 786522 788553 794922 801565 801763 825933 ] |
||||||||||||||||||||||||||||||
|
24.75 ms (9.27%) |
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 779010 730764 735112 753155 786522 391545 529025 562626 565255 446160 446874 518472 508204 675797 597469 421520 825933 573041 659106 617179 738640 626316 623201 801763 398874 557415 554764 608472 598547 603922 788553 725640 609388 714432 722625 447809 426200 678783 696114 545809 444244 473087 439027 447893 451616 561722 575096 575492 552395 565951 575798 576407 558846 561657 574540 561668 561702 563647 574585 595477 597951 612441 597536 619171 594301 592381 730728 476054 473931 418808 439218 447528 490794 535006 575771 575212 442632 497467 536256 570469 575495 573676 584287 722585 652616 683584 586473 597987 598788 603464 598010 598734 598599 610657 767315 7011 388772 421563 449456 393868 649166 639555 786274 781366 782087 747389 794922 753971 745496 766845 770427 420277 544858 801565 495824 561903 595458 598612 598722 595375 ] |
||||||||||||||||||||||||||||||
|
5.35 ms (2.00%) |
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 7011 388772 391545 393868 398874 418808 420277 421520 421563 426200 439027 439218 442632 444244 446160 446874 447528 447809 447893 449456 451616 473087 473931 476054 490794 495824 497467 508204 518472 529025 535006 536256 544858 545809 552395 554764 557415 558846 561657 561668 561702 561722 561903 562626 563647 565255 565951 570469 573041 573676 574540 574585 575096 575212 575492 575495 575771 575798 576407 584287 586473 592381 594301 595375 595458 595477 597469 597536 597951 597987 598010 598547 598599 598612 598722 598734 598788 603464 603922 608472 609388 610657 612441 617179 619171 623201 626316 639555 649166 652616 659106 675797 678783 683584 696114 714432 722585 722625 725640 730728 730764 735112 738640 745496 747389 753155 753971 766845 767315 770427 779010 781366 782087 786274 786522 788553 794922 801565 801763 825933 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teen жоп"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teen ass"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teen жоп"
]
|
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.