Query Metrics
7
Database Queries
7
Different statements
184.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.29 ms (82.94%) |
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 49688 95886 129722 146721 183036 280674 326205 386070 389980 393659 395492 395661 395975 396334 396640 398113 398492 399688 401095 401144 401904 404706 405175 410573 412092 412262 412521 413160 414432 417334 417336 417464 417739 418487 419378 425144 425753 426214 427378 433216 438597 445265 445590 456249 457406 457514 458297 458438 458778 459494 462285 462450 463848 465651 465662 468637 471721 471759 471814 472525 475830 475848 476120 478408 481140 481847 483618 491253 493255 496565 496585 497311 497941 499354 501103 503183 508750 513576 514388 517725 519002 520740 521432 522891 528448 554286 560963 561657 561675 561722 562116 566219 569981 571750 575432 579290 601475 601488 605342 615900 634794 665622 679194 680108 681028 683454 705518 709942 723618 740597 756242 770901 771836 797768 808988 809493 816502 817617 823493 825876 ] |
||||||||||||||||||||||||||||||
|
20.63 ms (11.16%) |
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 456249 475848 601475 465662 405175 517725 499354 465651 280674 398113 816502 823493 825876 615900 709942 395492 554286 497311 426214 412262 562116 410573 476120 445590 481847 425753 520740 491253 386070 129722 395975 412521 433216 478408 471721 472525 501103 503183 561722 575432 560963 561657 566219 680108 561675 571750 770901 771836 425144 401095 463848 481140 389980 396334 417334 457514 414432 519002 634794 462450 797768 146721 395661 514388 475830 528448 513576 665622 49688 183036 326205 404706 817617 508750 679194 681028 683454 705518 605342 809493 808988 756242 740597 401144 458778 427378 95886 459494 445265 601488 458297 398492 417739 723618 458438 471759 496565 497941 569981 579290 393659 413160 399688 457406 396640 401904 417336 418487 462285 412092 438597 471814 493255 483618 496585 521432 468637 419378 417464 522891 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (1.98%) |
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 49688 95886 129722 146721 183036 280674 326205 386070 389980 393659 395492 395661 395975 396334 396640 398113 398492 399688 401095 401144 401904 404706 405175 410573 412092 412262 412521 413160 414432 417334 417336 417464 417739 418487 419378 425144 425753 426214 427378 433216 438597 445265 445590 456249 457406 457514 458297 458438 458778 459494 462285 462450 463848 465651 465662 468637 471721 471759 471814 472525 475830 475848 476120 478408 481140 481847 483618 491253 493255 496565 496585 497311 497941 499354 501103 503183 508750 513576 514388 517725 519002 520740 521432 522891 528448 554286 560963 561657 561675 561722 562116 566219 569981 571750 575432 579290 601475 601488 605342 615900 634794 665622 679194 680108 681028 683454 705518 709942 723618 740597 756242 770901 771836 797768 808988 809493 816502 817617 823493 825876 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful blonde anal"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая беловолосая анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
1 |
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.