Query Metrics
7
Database Queries
7
Different statements
150.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.38 ms (84.10%) |
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 151179 381810 383606 391954 392427 395252 395479 398122 401810 410682 439993 441250 442064 446446 446796 457216 468661 471130 471455 475497 477507 479738 494532 504155 505143 511866 524675 530428 531358 531822 531850 531856 535363 536465 537269 547458 547485 547925 561346 563310 567122 577717 580139 584301 588346 590255 599477 600508 600922 609887 619710 621496 624942 629379 634109 637364 642076 642085 642134 644386 648649 648696 652788 659234 662049 670210 680484 696595 697236 697876 703561 705119 705571 707571 712097 716086 720024 722381 722387 723877 738476 744383 745083 745114 746191 748287 751294 752675 752713 752755 759335 759418 761276 762007 769148 777767 778120 781297 781298 782108 783057 784236 788529 789459 792710 792723 793017 796988 797002 800530 800543 801495 803582 806139 806828 811700 812031 813205 814229 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (9.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 746191 759335 800530 806139 806828 392427 151179 537269 494532 642076 619710 784236 782108 705571 590255 561346 584301 531358 703561 637364 588346 707571 401810 439993 547485 441250 398122 446446 659234 712097 648696 600508 629379 471130 504155 531822 530428 547458 662049 705119 670210 567122 600922 752675 752713 738476 752755 769148 745083 748287 680484 535363 536465 563310 547925 716086 720024 722387 642085 783057 789459 792723 723877 781297 788529 792710 745114 759418 762007 744383 751294 778120 621496 599477 410682 468661 580139 471455 442064 383606 457216 477507 505143 381810 648649 395479 446796 624942 630427 634109 475497 511866 531856 524675 531850 722381 644386 609887 811700 813205 803582 800543 395252 652788 479738 391954 814229 577717 697876 696595 642134 781298 797002 801495 793017 796988 761276 697236 777767 812031 ] |
||||||||||||||||||||||||||||||
|
3.26 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 151179 381810 383606 391954 392427 395252 395479 398122 401810 410682 439993 441250 442064 446446 446796 457216 468661 471130 471455 475497 477507 479738 494532 504155 505143 511866 524675 530428 531358 531822 531850 531856 535363 536465 537269 547458 547485 547925 561346 563310 567122 577717 580139 584301 588346 590255 599477 600508 600922 609887 619710 621496 624942 629379 634109 637364 642076 642085 642134 644386 648649 648696 652788 659234 662049 670210 680484 696595 697236 697876 703561 705119 705571 707571 712097 716086 720024 722381 722387 723877 738476 744383 745083 745114 746191 748287 751294 752675 752713 752755 759335 759418 761276 762007 769148 777767 778120 781297 781298 782108 783057 784236 788529 789459 792710 792723 793017 796988 797002 800530 800543 801495 803582 806139 806828 811700 812031 813205 814229 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo homemade"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные дилд домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.02%) |
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.