Query Metrics
7
Database Queries
7
Different statements
356.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.28 ms (57.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina double"
]
|
||||||||||||||||||||||||||||||
|
124.26 ms (34.90%) |
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 10665 95943 130468 315072 346150 395674 398041 411681 414313 420190 426197 445416 446771 454984 460398 461723 465299 468340 469764 474289 487282 495516 496270 496465 497713 502810 505625 506321 509879 515934 516320 522592 522899 525089 528098 530703 531117 531236 531286 531849 536339 536538 537863 545393 548455 555257 557838 563407 566079 566423 566698 581302 583460 583496 583507 583729 591695 593848 599888 600415 600508 609906 620471 629333 630814 632601 632641 632671 634198 636308 643103 645236 646849 647906 648539 648560 650325 653034 653095 653366 655586 664517 665450 683494 687381 702164 704205 710360 710794 713143 715743 720158 720319 720576 729288 734591 735654 737997 738556 740578 745384 745924 752611 756830 759156 761530 767036 773183 776538 781264 784414 788659 792677 796285 801536 808298 817113 824554 827878 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (4.99%) |
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 710794 645236 646849 704205 647906 545393 591695 600415 632671 599888 745384 632641 414313 461723 398041 509879 496270 474289 10665 817113 531286 502810 548455 557838 653095 665450 683494 653366 720319 566423 788659 776538 796285 729288 752611 756830 720158 593848 315072 420190 426197 465299 522899 536339 505625 531236 581302 650325 702164 648539 566698 583496 629333 395674 95943 469764 411681 525089 515934 528098 445416 566079 583729 634198 664517 715743 710360 720576 735654 759156 745924 792677 460398 346150 495516 555257 630814 781264 487282 496465 446771 516320 522592 530703 531117 537863 536538 583507 648560 632601 643103 609906 636308 454984 130468 824554 827878 468340 531294 531849 563407 583460 687381 653034 655586 600508 620471 784414 808298 801536 761530 737997 767036 738556 740578 773183 734591 713143 506321 497713 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.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 10665 95943 130468 315072 346150 395674 398041 411681 414313 420190 426197 445416 446771 454984 460398 461723 465299 468340 469764 474289 487282 495516 496270 496465 497713 502810 505625 506321 509879 515934 516320 522592 522899 525089 528098 530703 531117 531236 531286 531849 536339 536538 537863 545393 548455 555257 557838 563407 566079 566423 566698 581302 583460 583496 583507 583729 591695 593848 599888 600415 600508 609906 620471 629333 630814 632601 632641 632671 634198 636308 643103 645236 646849 647906 648539 648560 650325 653034 653095 653366 655586 664517 665450 683494 687381 702164 704205 710360 710794 713143 715743 720158 720319 720576 729288 734591 735654 737997 738556 740578 745384 745924 752611 756830 759156 761530 767036 773183 776538 781264 784414 788659 792677 796285 801536 808298 817113 824554 827878 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин double"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин double"
]
|
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.