Query Metrics
7
Database Queries
7
Different statements
174.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.67 ms (85.97%) |
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 310672 383700 384581 385818 393081 394258 395142 395560 395891 397999 398236 398243 400125 400511 400664 400888 401956 402599 407187 407682 407684 411165 413112 413128 417162 417662 421814 422484 425499 428804 428844 428858 429528 429584 429824 437322 437670 440292 443183 446276 446284 446299 446625 448358 448727 450995 454048 458009 458731 459254 462110 482554 486251 489960 492304 507088 511790 520892 522602 523184 523905 524286 526181 526323 526449 532065 545644 549837 550622 550644 552299 554400 555889 563123 568367 579227 582197 593598 602707 623714 626771 633212 665259 680702 695087 701247 702312 706560 708161 709503 710568 716324 717689 721700 724706 725363 725407 725513 726612 728291 731070 731129 736393 740117 741893 742751 743479 746165 749773 755746 758564 760425 786542 787636 795234 800743 801098 810472 813918 813920 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (8.21%) |
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 626771 787636 810472 724706 741893 742751 758564 710568 428844 385818 526181 417662 437670 407684 429824 422484 446276 448358 454048 492304 520892 523905 568367 563123 665259 695087 701247 717689 554400 602707 786542 731070 725363 755746 743479 746165 736393 749773 709503 428858 446284 448727 395560 428804 459254 437322 526323 400125 401956 402599 417162 407187 440292 458009 482554 486251 545644 702312 593598 623714 801098 740117 760425 633212 458731 507088 511790 407682 522602 552299 721700 411165 393081 394258 398236 310672 395891 398243 397999 680702 446625 450995 523184 462110 555889 725407 726612 400664 421814 384581 383700 429584 813920 813918 489960 532065 524286 526449 550622 550644 582197 708161 549837 579227 795234 800743 725513 728291 731129 706560 716324 400511 413128 395142 400888 429528 425499 413112 443183 446299 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.56%) |
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 310672 383700 384581 385818 393081 394258 395142 395560 395891 397999 398236 398243 400125 400511 400664 400888 401956 402599 407187 407682 407684 411165 413112 413128 417162 417662 421814 422484 425499 428804 428844 428858 429528 429584 429824 437322 437670 440292 443183 446276 446284 446299 446625 448358 448727 450995 454048 458009 458731 459254 462110 482554 486251 489960 492304 507088 511790 520892 522602 523184 523905 524286 526181 526323 526449 532065 545644 549837 550622 550644 552299 554400 555889 563123 568367 579227 582197 593598 602707 623714 626771 633212 665259 680702 695087 701247 702312 706560 708161 709503 710568 716324 717689 721700 724706 725363 725407 725513 726612 728291 731070 731129 736393 740117 741893 742751 743479 746165 749773 755746 758564 760425 786542 787636 795234 800743 801098 810472 813918 813920 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck son"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс son"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс son"
]
|
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.