Query Metrics
7
Database Queries
7
Different statements
140.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.21 ms (82.86%) |
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 130054 404724 416255 422055 423709 428166 429713 443862 448689 451509 452676 453006 453732 456208 459177 459353 460437 463948 465256 466034 472449 474743 475471 480567 482305 484755 487131 491654 491659 497058 497184 497408 497729 505917 505961 508558 508848 509085 513278 514384 517599 518504 520490 521320 523679 524962 526649 534217 542648 546140 548652 554366 560479 566220 568422 571066 571149 576028 576372 576840 577641 579825 579828 579867 582615 583446 585910 587679 588023 590461 593620 593622 593750 593775 595772 595967 601369 601401 603464 604679 606599 607780 613017 613238 617161 627307 632734 639247 648219 668451 668529 672342 672367 673415 673797 675296 682226 698082 699577 715520 718438 718894 730350 740392 742046 742839 744863 747654 748979 750668 751704 760955 761320 761580 770929 786153 786462 812782 818630 820881 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (10.99%) |
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 508848 459353 463948 451509 460437 475471 472449 497058 554366 466034 453006 443862 482305 491654 513278 509085 514384 487131 505961 520490 571066 672367 668451 593620 585910 587679 593750 484755 542648 517599 818630 718438 682226 588023 595967 603464 607780 593775 613238 770929 786462 742046 748979 761320 761580 747654 751704 604679 130054 673797 579825 632734 524962 606599 523679 546140 497729 740392 718894 672342 404724 428166 448689 452676 505917 534217 576372 648219 474743 518504 715520 453732 820881 568422 576840 579828 583446 560479 571149 582615 548652 576028 675296 698082 673415 668529 566220 601401 601369 613017 590461 595772 627307 786153 742839 760955 812782 744863 730350 750668 639247 526649 699577 579867 593622 617161 422055 459177 497408 480567 577641 429713 423709 456208 491659 497184 521320 508558 416255 465256 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.67%) |
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 130054 404724 416255 422055 423709 428166 429713 443862 448689 451509 452676 453006 453732 456208 459177 459353 460437 463948 465256 466034 472449 474743 475471 480567 482305 484755 487131 491654 491659 497058 497184 497408 497729 505917 505961 508558 508848 509085 513278 514384 517599 518504 520490 521320 523679 524962 526649 534217 542648 546140 548652 554366 560479 566220 568422 571066 571149 576028 576372 576840 577641 579825 579828 579867 582615 583446 585910 587679 588023 590461 593620 593622 593750 593775 595772 595967 601369 601401 603464 604679 606599 607780 613017 613238 617161 627307 632734 639247 648219 668451 668529 672342 672367 673415 673797 675296 682226 698082 699577 715520 718438 718894 730350 740392 742046 742839 744863 747654 748979 750668 751704 760955 761320 761580 770929 786153 786462 812782 818630 820881 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick surprise"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член surprise"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член surprise"
]
|
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.