Query Metrics
7
Database Queries
7
Different statements
334.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 212.16 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 3.17 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife bbc sperm"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.22 ms |
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 419862 606993 632614 604473 528682 634856 574224 601101 426405 563858 619577 466552 478608 326134 445741 463894 523418 676176 683529 645196 653972 756468 443945 451560 425125 471814 584749 573403 517049 496794 606482 629967 479709 535013 507663 554445 809272 651276 693955 423329 467583 490831 445728 640723 804491 419509 445751 604960 573212 440632 417829 635783 570168 577641 429088 573477 445740 411681 523198 621612 605521 592728 554409 478527 586534 482527 544686 545828 604478 554392 391386 451983 541081 649525 582035 513736 530026 569421 582821 527447 516684 544472 577108 529450 ] |
||||||||||||||||||||||||||||||
| 4 | 2.84 ms |
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 326134 391386 411681 417829 419509 419862 423329 425125 426405 429088 440632 443945 445728 445740 445741 445751 451560 451983 463894 466552 467583 471814 478527 478608 479709 482527 490831 496794 507663 513736 516684 517049 523198 523418 527447 528682 529450 530026 535013 541081 544472 544686 545828 554392 554409 554445 563858 569421 570168 573212 573403 573477 574224 577108 577641 582035 582821 584749 586534 592728 601101 604473 604478 604960 605521 606482 606993 619577 621612 629967 632614 634856 635783 640723 645196 649525 651276 653972 676176 683529 693955 756468 804491 809272 ] |
||||||||||||||||||||||||||||||
| 5 | 95.59 ms |
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 326134 391386 411681 417829 419509 419862 423329 425125 426405 429088 440632 443945 445728 445740 445741 445751 451560 451983 463894 466552 467583 471814 478527 478608 479709 482527 490831 496794 507663 513736 516684 517049 523198 523418 527447 528682 529450 530026 535013 541081 544472 544686 545828 554392 554409 554445 563858 569421 570168 573212 573403 573477 574224 577108 577641 582035 582821 584749 586534 592728 601101 604473 604478 604960 605521 606482 606993 619577 621612 629967 632614 634856 635783 640723 645196 649525 651276 653972 676176 683529 693955 756468 804491 809272 ] |
||||||||||||||||||||||||||||||
| 6 | 2.01 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен bbc сперм"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.62 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен bbc сперм"
]
|
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.