Query Metrics
7
Database Queries
7
Different statements
369.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
342.17 ms (92.71%) |
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 61243 386204 386936 395491 398097 398200 399837 401727 402060 402351 403293 404060 407732 408701 412180 413048 413584 415618 415966 416170 419273 420118 420348 421021 424303 427970 428082 428241 428955 429009 430103 430293 431385 433048 445006 450671 454957 456655 458917 461008 462922 464563 464604 464610 465808 465918 468680 471148 471455 473722 475451 483951 487012 487649 492287 497439 499252 504003 504005 512514 523147 529001 529034 530805 535651 536266 536650 536889 543107 552951 559951 577644 580727 594136 594177 594208 594409 595434 597509 598675 605892 612243 624942 630765 632311 633611 646875 676636 678125 692505 698120 708202 720101 724399 725713 738435 740461 745384 759959 761619 766871 770420 774672 776488 778042 779140 784217 784281 791932 793727 794139 803135 806543 807616 807927 810261 813808 814202 816810 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (4.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 807616 415966 473722 536650 580727 543107 630765 512514 612243 465918 577644 398097 816810 794139 803135 779140 766871 740461 724399 784281 427970 464610 399837 407732 810261 725713 450671 61243 761619 594208 416170 431385 462922 646875 624942 630427 807927 421021 386204 402351 529001 698120 791932 759959 504003 487649 594136 814202 552951 720101 774672 784217 806543 395491 504005 492287 464563 536266 678125 412180 430103 428241 475451 497439 598675 429009 465808 529034 419273 605892 793727 770420 404060 454957 398200 458917 632311 415618 530805 464604 745384 430293 456655 594409 433048 403293 420348 483951 778042 738435 424303 559951 536889 413584 471148 471455 468680 445006 428082 813808 487012 708202 523147 692505 594177 401727 676636 420118 595434 776488 428955 386936 408701 413048 461008 499252 535651 633611 597509 402060 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (0.97%) |
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 61243 386204 386936 395491 398097 398200 399837 401727 402060 402351 403293 404060 407732 408701 412180 413048 413584 415618 415966 416170 419273 420118 420348 421021 424303 427970 428082 428241 428955 429009 430103 430293 431385 433048 445006 450671 454957 456655 458917 461008 462922 464563 464604 464610 465808 465918 468680 471148 471455 473722 475451 483951 487012 487649 492287 497439 499252 504003 504005 512514 523147 529001 529034 530805 535651 536266 536650 536889 543107 552951 559951 577644 580727 594136 594177 594208 594409 595434 597509 598675 605892 612243 624942 630765 632311 633611 646875 676636 678125 692505 698120 708202 720101 724399 725713 738435 740461 745384 759959 761619 766871 770420 774672 776488 778042 779140 784217 784281 791932 793727 794139 803135 806543 807616 807927 810261 813808 814202 816810 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen огромные сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen huge tits"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.