Query Metrics
7
Database Queries
7
Different statements
362.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.58 ms (57.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
126.06 ms (34.81%) |
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 3512 156487 188501 191082 233025 310190 310706 311746 313187 361315 369221 382490 383188 383571 384760 385285 386973 387884 388322 388785 388913 389526 390760 391562 391931 397888 398824 398951 405847 409045 411419 433418 443389 446901 448939 454300 454964 455228 456056 466281 469104 469127 470162 470968 471113 472683 475377 483150 488331 489975 492964 493304 497414 499328 501374 506705 510844 512416 513614 515618 518160 519940 521853 524926 529654 530011 537147 542767 549682 554840 559156 559433 559796 560234 563749 568899 571940 574768 590148 590288 591067 591414 593346 600750 600786 605240 610697 614494 620200 626760 663895 663939 675675 680334 680819 710685 713117 715065 716256 720529 720533 724809 741046 744182 746564 746634 753494 760262 761345 778296 778663 795966 796515 803479 806476 809356 818418 826087 828446 828804 ] |
||||||||||||||||||||||||||||||
|
19.83 ms (5.48%) |
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 614494 591414 488331 513614 311746 382490 499328 716256 680334 600750 605240 796515 803479 746564 760262 753494 715065 806476 826087 563749 663939 713117 720533 620200 778296 809356 746634 795966 744182 761345 720529 778663 233025 397888 600786 310706 675675 710685 472683 455228 549682 680819 559796 470968 521853 571940 383188 188501 388913 387884 454964 510844 518160 554840 663895 591067 388785 386973 446901 411419 456056 493304 506705 501374 530011 626760 590288 369221 560234 489975 470162 391562 519940 483150 454300 469104 398951 828804 469127 497414 559156 156487 443389 512416 574768 559433 390760 405847 361315 388322 471113 3512 818418 524926 537147 492964 590148 828446 610697 385285 383571 191082 310190 398824 433418 448939 529654 515618 542767 568899 593346 724809 741046 313187 389526 409045 475377 466281 384760 391931 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.64%) |
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 3512 156487 188501 191082 233025 310190 310706 311746 313187 361315 369221 382490 383188 383571 384760 385285 386973 387884 388322 388785 388913 389526 390760 391562 391931 397888 398824 398951 405847 409045 411419 433418 443389 446901 448939 454300 454964 455228 456056 466281 469104 469127 470162 470968 471113 472683 475377 483150 488331 489975 492964 493304 497414 499328 501374 506705 510844 512416 513614 515618 518160 519940 521853 524926 529654 530011 537147 542767 549682 554840 559156 559433 559796 560234 563749 568899 571940 574768 590148 590288 591067 591414 593346 600750 600786 605240 610697 614494 620200 626760 663895 663939 675675 680334 680819 710685 713117 715065 716256 720529 720533 724809 741046 744182 746564 746634 753494 760262 761345 778296 778663 795966 796515 803479 806476 809356 818418 826087 828446 828804 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно женщин в чулках%…"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.