Query Metrics
7
Database Queries
7
Different statements
160.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.97 ms (82.36%) |
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 396777 401470 404120 419319 421152 423368 426390 429553 430256 432843 437504 437726 439662 441500 445289 445340 447511 447521 451327 451788 452625 452909 453332 454979 455374 455918 456813 457887 461686 464794 465854 468684 469513 469745 470403 473417 474579 474778 477535 480135 481047 481807 482338 485135 485811 496729 496733 496756 500207 505140 508224 510247 511895 515339 515747 522300 524876 527882 528123 528519 532876 538703 549079 552628 552998 555360 558720 560867 560958 563548 570906 573405 575710 578501 578527 583079 586644 588146 593609 601968 604109 604344 606633 608472 614696 620163 630806 639301 656126 663265 666723 669302 673173 676473 696426 700470 700631 710080 720878 723287 729344 735197 747740 752632 766694 771918 776988 793900 795554 796143 797339 800533 801953 806078 806797 806883 809782 814835 815853 817142 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (10.64%) |
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 461686 673173 608472 496733 496756 510247 452625 814835 455374 666723 401470 451327 447521 524876 528519 451788 570906 614696 470403 453332 573405 583079 663265 485135 429553 445340 474579 455918 700470 752632 766694 465854 496729 515747 747740 404120 604344 815853 527882 676473 776988 793900 806883 795554 797339 419319 735197 601968 604109 796143 800533 700631 396777 505140 549079 606633 593609 528123 560867 457887 578527 522300 474778 560958 555360 723287 578501 588146 421152 473417 454979 558720 481047 508224 423368 482338 469513 586644 437726 552998 806797 480135 575710 563548 511895 464794 439662 452909 469745 477535 485811 447511 500207 515339 532876 456813 468684 538703 432843 430256 806078 771918 441500 481807 552628 437504 445289 669302 630806 426390 817142 696426 656126 710080 720878 620163 639301 809782 801953 729344 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.04%) |
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 396777 401470 404120 419319 421152 423368 426390 429553 430256 432843 437504 437726 439662 441500 445289 445340 447511 447521 451327 451788 452625 452909 453332 454979 455374 455918 456813 457887 461686 464794 465854 468684 469513 469745 470403 473417 474579 474778 477535 480135 481047 481807 482338 485135 485811 496729 496733 496756 500207 505140 508224 510247 511895 515339 515747 522300 524876 527882 528123 528519 532876 538703 549079 552628 552998 555360 558720 560867 560958 563548 570906 573405 575710 578501 578527 583079 586644 588146 593609 601968 604109 604344 606633 608472 614696 620163 630806 639301 656126 663265 666723 669302 673173 676473 696426 700470 700631 710080 720878 723287 729344 735197 747740 752632 766694 771918 776988 793900 795554 796143 797339 800533 801953 806078 806797 806883 809782 814835 815853 817142 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal best ass"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал best жоп"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал best жоп"
]
|
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.