Query Metrics
7
Database Queries
7
Different statements
169.63 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.13 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.84 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с троими"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.32 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 762907 716298 385348 446481 504194 484560 96341 405056 476112 540186 562893 551170 661567 664490 673583 707434 645273 676886 676871 706935 643986 589598 605616 612066 727057 727717 742683 755170 760619 771482 734385 743906 749488 742663 749266 727769 394229 418417 436031 188437 512823 70082 390994 667486 679038 645241 677097 614344 588745 801886 804771 804773 806783 727996 717635 405961 420182 505128 525846 418833 452762 558126 582549 590437 728397 527074 506053 509702 515153 424675 500467 661578 610640 616956 485712 676023 571201 579301 619439 446084 434192 520731 518633 ] |
||||||||||||||||||||||||||||||
| 4 | 2.19 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 70082 96341 188437 385348 390994 394229 405056 405961 418417 418833 420182 424675 434192 436031 446084 446481 452762 476112 484560 485712 500467 504194 505128 506053 509702 512823 515153 518633 520731 525846 527074 540186 551170 558126 562893 571201 579301 582549 588745 589598 590437 605616 610640 612066 614344 616956 619439 643986 645241 645273 661567 661578 664490 667486 673583 676023 676871 676886 677097 679038 706935 707434 716298 717635 727057 727717 727769 727996 728397 734385 742663 742683 743906 749266 749488 755170 760619 762907 771482 801886 804771 804773 806783 ] |
||||||||||||||||||||||||||||||
| 5 | 146.07 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 70082 96341 188437 385348 390994 394229 405056 405961 418417 418833 420182 424675 434192 436031 446084 446481 452762 476112 484560 485712 500467 504194 505128 506053 509702 512823 515153 518633 520731 525846 527074 540186 551170 558126 562893 571201 579301 582549 588745 589598 590437 605616 610640 612066 614344 616956 619439 643986 645241 645273 661567 661578 664490 667486 673583 676023 676871 676886 677097 679038 706935 707434 716298 717635 727057 727717 727769 727996 728397 734385 742663 742683 743906 749266 749488 755170 760619 762907 771482 801886 804771 804773 806783 ] |
||||||||||||||||||||||||||||||
| 6 | 1.63 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тро"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.46 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.