Query Metrics
7
Database Queries
7
Different statements
186.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.57 ms (83.05%) |
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 386211 387937 414769 419132 419989 420758 422028 426043 430630 430635 434702 439434 440886 442301 442332 442363 442831 445668 446109 447182 451239 451787 452813 452965 452983 453340 457034 460774 461805 465490 465698 465823 476254 479768 483183 486592 491431 492322 492565 493231 493963 495631 497565 498269 498345 502482 505537 507628 508516 508786 510404 510668 512936 512938 512941 513049 513575 514640 514641 514645 514648 514800 515187 515202 516787 518879 521287 521520 522191 522876 523021 524018 524296 526714 526884 529342 529801 532441 533643 535738 539240 541961 549730 551525 556009 556987 558710 565363 565411 567141 567155 567756 568305 574520 577096 581543 586419 589721 593867 593872 594838 597282 598207 598724 603055 604160 606561 611535 619999 624122 624502 625437 627144 630771 636247 659405 663297 666405 690899 750611 ] |
||||||||||||||||||||||||||||||
|
21.97 ms (11.80%) |
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 593867 442831 598207 465490 498269 513575 606561 508516 387937 465698 483183 465823 497565 514641 414769 434702 451787 442332 522876 492565 512936 498345 505537 493231 526714 521287 516787 627144 452813 440886 529801 558710 581543 659405 565411 750611 419989 460774 461805 451239 508786 492322 452965 479768 486592 533643 532441 549730 603055 521520 529342 512938 502482 611535 663297 565363 426043 597282 514645 430635 442301 567155 420758 666405 556009 568305 690899 422028 457034 526884 513049 535738 493963 495631 515202 604160 507628 386211 589721 445668 551525 624502 518879 512941 624122 430630 442363 514648 524018 419132 514640 452983 636247 593872 447182 453340 567756 514800 446109 510668 539240 541961 574520 522191 510404 439434 524296 476254 515187 586419 619999 625437 598724 577096 523021 594838 567141 556987 491431 630771 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.51%) |
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 386211 387937 414769 419132 419989 420758 422028 426043 430630 430635 434702 439434 440886 442301 442332 442363 442831 445668 446109 447182 451239 451787 452813 452965 452983 453340 457034 460774 461805 465490 465698 465823 476254 479768 483183 486592 491431 492322 492565 493231 493963 495631 497565 498269 498345 502482 505537 507628 508516 508786 510404 510668 512936 512938 512941 513049 513575 514640 514641 514645 514648 514800 515187 515202 516787 518879 521287 521520 522191 522876 523021 524018 524296 526714 526884 529342 529801 532441 533643 535738 539240 541961 549730 551525 556009 556987 558710 565363 565411 567141 567155 567756 568305 574520 577096 581543 586419 589721 593867 593872 594838 597282 598207 598724 603055 604160 606561 611535 619999 624122 624502 625437 627144 630771 636247 659405 663297 666405 690899 750611 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video sex vagina"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video секс вагин"
]
|
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.