Query Metrics
7
Database Queries
7
Different statements
191.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.63 ms (82.64%) |
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 391372 393476 399924 400712 407433 410264 410663 410741 417154 417551 420462 421443 421623 421718 422010 424386 428610 429384 436627 437836 443492 443868 444338 445851 448520 451594 453226 453952 454534 455585 455698 455937 456567 456930 458816 465803 467970 472877 473199 473390 473774 474263 474994 476084 477543 478357 478490 479759 487205 491712 492280 493770 493782 495008 496750 496869 498548 502781 510168 513364 514237 514796 516699 517990 518887 519083 521182 523199 523554 523898 524002 527610 528371 529083 529357 529708 529735 529840 531000 533164 534112 534115 534116 534118 534120 534506 535522 537222 537960 537965 538081 538154 538887 539860 540276 540844 540931 542303 542573 542842 544369 553823 556181 600659 651979 661615 671350 725779 756117 762972 766844 791729 800852 810422 815058 819211 820459 823045 825566 826131 ] |
||||||||||||||||||||||||||||||
|
21.55 ms (11.23%) |
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 420462 513364 540844 429384 421718 529840 487205 492280 766844 819211 826131 531000 542303 553823 443868 455585 410264 477543 410741 465803 496869 456930 556181 756117 472877 661615 823045 455937 600659 424386 451594 473774 521182 496750 453226 478490 476084 456567 422010 533164 514237 810422 762972 391372 428610 519083 478357 529083 540276 542842 791729 393476 417154 421623 399924 538081 529708 421443 436627 445851 448520 453952 454534 467970 523898 517990 474994 479759 444338 491712 498548 537960 524002 400712 407433 825566 527610 537222 502781 529357 538154 538887 523199 523554 516699 534506 473390 542573 544369 540931 671350 800852 725779 514796 815058 518887 495008 651979 443492 437836 455698 410663 417551 820459 474263 473199 493782 458816 493770 534112 534115 535522 528371 529735 534116 534118 537965 539860 510168 534120 ] |
||||||||||||||||||||||||||||||
|
4.04 ms (2.11%) |
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 391372 393476 399924 400712 407433 410264 410663 410741 417154 417551 420462 421443 421623 421718 422010 424386 428610 429384 436627 437836 443492 443868 444338 445851 448520 451594 453226 453952 454534 455585 455698 455937 456567 456930 458816 465803 467970 472877 473199 473390 473774 474263 474994 476084 477543 478357 478490 479759 487205 491712 492280 493770 493782 495008 496750 496869 498548 502781 510168 513364 514237 514796 516699 517990 518887 519083 521182 523199 523554 523898 524002 527610 528371 529083 529357 529708 529735 529840 531000 533164 534112 534115 534116 534118 534120 534506 535522 537222 537960 537965 538081 538154 538887 539860 540276 540844 540931 542303 542573 542842 544369 553823 556181 600659 651979 661615 671350 725779 756117 762972 766844 791729 800852 810422 815058 819211 820459 823045 825566 826131 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white teen pov"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white teen пов"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white teen пов"
]
|
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.