Query Metrics
7
Database Queries
7
Different statements
150.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.12 ms (83.32%) |
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 6696 281574 391565 392079 395741 400465 407759 410311 411944 413295 415556 416407 417425 425619 426126 428784 434671 436115 443793 445404 448902 451883 453214 454239 454989 455289 455940 456625 456721 457289 458766 459704 459847 459894 463737 463964 464381 464952 464955 465290 465685 466671 469548 473259 475079 475354 478293 487543 492120 492136 497652 500804 506350 511327 514704 520923 525480 530130 532986 533306 547565 560180 561070 565205 565627 566623 567835 577353 580916 583176 583341 590538 596251 598133 599117 601080 601088 602402 603555 607335 607666 610603 611268 615935 618493 624178 625709 626280 631710 647950 660843 663485 663984 664542 667649 685579 687144 712177 712570 722718 724466 732367 738202 745473 759960 774287 774672 780577 792265 796521 799233 801065 801112 801475 802818 805365 807991 810839 810996 826499 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (9.49%) |
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 712570 732367 647950 601088 618493 436115 410311 607666 611268 599117 443793 416407 457289 426126 801112 466671 392079 774672 826499 805365 780577 561070 428784 434671 566623 601080 774287 417425 525480 281574 400465 603555 413295 454239 407759 685579 660843 395741 459704 738202 565205 810996 454989 590538 759960 583176 547565 567835 596251 615935 807991 497652 456721 514704 456625 511327 475079 577353 583341 722718 464381 464952 465290 792265 663485 602402 810839 473259 411944 459894 533306 475354 565627 667649 687144 802818 745473 626280 796521 391565 448902 455940 458766 463964 453214 445404 801475 506350 799233 6696 415556 607335 425619 624178 465685 580916 801065 625709 492136 598133 459847 532986 500804 664542 478293 492120 663984 455289 560180 724466 487543 520923 530130 712177 610603 631710 469548 451883 463737 464955 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.35%) |
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 6696 281574 391565 392079 395741 400465 407759 410311 411944 413295 415556 416407 417425 425619 426126 428784 434671 436115 443793 445404 448902 451883 453214 454239 454989 455289 455940 456625 456721 457289 458766 459704 459847 459894 463737 463964 464381 464952 464955 465290 465685 466671 469548 473259 475079 475354 478293 487543 492120 492136 497652 500804 506350 511327 514704 520923 525480 530130 532986 533306 547565 560180 561070 565205 565627 566623 567835 577353 580916 583176 583341 590538 596251 598133 599117 601080 601088 602402 603555 607335 607666 610603 611268 615935 618493 624178 625709 626280 631710 647950 660843 663485 663984 664542 667649 685579 687144 712177 712570 722718 724466 732367 738202 745473 759960 774287 774672 780577 792265 796521 799233 801065 801112 801475 802818 805365 807991 810839 810996 826499 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс большие boobs"
]
|
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.