Query Metrics
7
Database Queries
7
Different statements
141.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.98 ms (84.01%) |
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 434314 434358 434369 435594 442584 445107 452174 454541 458845 461312 469158 469463 475416 476382 478772 481830 484972 499914 503506 505637 514880 515667 518622 520270 525970 560094 568742 569252 575973 577105 577584 583469 585977 585981 586745 587235 591217 595258 595530 608955 613530 617032 619310 622476 628459 635802 636666 651335 664441 668310 672825 674467 683083 689490 689565 693225 696499 700685 704334 707466 720132 722300 733594 734253 739993 746135 750429 753614 754289 754903 755492 761221 767057 767849 772061 772250 773926 776041 776441 776548 776586 777005 777284 777762 779119 784633 787516 787850 789613 789800 790483 790810 791916 794224 794440 794798 796168 798647 802182 803035 803504 804081 804700 805332 806413 806812 806861 807145 808547 809016 809548 809839 813020 814386 817271 818686 823607 823929 824347 ] |
||||||||||||||||||||||||||||||
|
13.82 ms (9.76%) |
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 587235 445107 818686 672825 668310 608955 619310 595530 622476 807145 776041 794224 809016 809548 746135 772061 772250 790483 790810 794440 754903 767057 754289 787850 803504 806861 458845 442584 469158 481830 478772 734253 789800 484972 503506 577584 568742 628459 613530 585977 469463 435594 824347 814386 575973 583469 693225 689490 704334 689565 707466 635802 636666 595258 803035 784633 806812 739993 761221 787516 804081 806413 753614 755492 777005 779119 789613 518622 560094 674467 813020 651335 434369 794798 817271 823607 454541 476382 525970 514880 577105 700685 558081 585981 776548 777762 796168 776441 776586 804700 805332 773926 767849 733594 750429 720132 791916 808547 434358 475416 591217 617032 586745 520270 696499 722300 461312 499914 683083 569252 515667 452174 434314 823929 505637 664441 777284 802182 798647 809839 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.88%) |
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 434314 434358 434369 435594 442584 445107 452174 454541 458845 461312 469158 469463 475416 476382 478772 481830 484972 499914 503506 505637 514880 515667 518622 520270 525970 560094 568742 569252 575973 577105 577584 583469 585977 585981 586745 587235 591217 595258 595530 608955 613530 617032 619310 622476 628459 635802 636666 651335 664441 668310 672825 674467 683083 689490 689565 693225 696499 700685 704334 707466 720132 722300 733594 734253 739993 746135 750429 753614 754289 754903 755492 761221 767057 767849 772061 772250 773926 776041 776441 776548 776586 777005 777284 777762 779119 784633 787516 787850 789613 789800 790483 790810 791916 794224 794440 794798 796168 798647 802182 803035 803504 804081 804700 805332 806413 806812 806861 807145 808547 809016 809548 809839 813020 814386 817271 818686 823607 823929 824347 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife i dildo"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен i дилд"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен i дилд"
]
|
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.