Query Metrics
7
Database Queries
7
Different statements
157.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.97 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.95 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ffm latina"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.20 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 494731 424746 425048 534823 553352 477183 489674 515135 517750 699025 586494 726553 507078 609799 572005 811072 458722 437857 472513 520639 520037 384016 389448 392270 815935 484801 521783 567145 425802 520719 590884 530884 462863 458309 607293 490694 804442 414177 494778 560176 430697 486963 544668 815268 534312 472941 606748 414172 467395 557259 611986 472505 532357 407252 386874 418828 473915 449372 487518 431365 478807 520311 578326 437868 448839 510286 507609 531920 561576 433179 464384 461595 479196 430018 543604 424328 424364 536695 590667 699610 586484 565050 452097 464266 610606 438896 428372 ] |
||||||||||||||||||||||||||||||
| 4 | 2.56 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 384016 386874 389448 392270 407252 414172 414177 418828 424328 424364 424746 425048 425802 428372 430018 430697 431365 433179 437857 437868 438896 448839 449372 452097 458309 458722 461595 462863 464266 464384 467395 472505 472513 472941 473915 477183 478807 479196 484801 486963 487518 489674 490694 494731 494778 507078 507609 510286 515135 517750 520037 520311 520639 520719 521783 530884 531920 532357 534312 534823 536695 543604 544668 553352 557259 560176 561576 565050 567145 572005 578326 586484 586494 590667 590884 606748 607293 609799 610606 611986 699025 699610 726553 804442 811072 815268 815935 ] |
||||||||||||||||||||||||||||||
| 5 | 132.25 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 384016 386874 389448 392270 407252 414172 414177 418828 424328 424364 424746 425048 425802 428372 430018 430697 431365 433179 437857 437868 438896 448839 449372 452097 458309 458722 461595 462863 464266 464384 467395 472505 472513 472941 473915 477183 478807 479196 484801 486963 487518 489674 490694 494731 494778 507078 507609 510286 515135 517750 520037 520311 520639 520719 521783 530884 531920 532357 534312 534823 536695 543604 544668 553352 557259 560176 561576 565050 567145 572005 578326 586484 586494 590667 590884 606748 607293 609799 610606 611986 699025 699610 726553 804442 811072 815268 815935 ] |
||||||||||||||||||||||||||||||
| 6 | 1.82 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро латинская"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 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.