Query Metrics
7
Database Queries
7
Different statements
198.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.28 ms (88.78%) |
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 41776 87974 383208 384108 391989 392023 392848 400571 411643 414071 414116 415859 415877 415879 415992 416020 416025 416700 416738 416819 420295 422055 428195 429863 432289 433165 437859 443219 445802 456232 456236 464550 466477 468524 469217 471455 471660 471687 476737 477081 493744 496340 500100 500256 505140 505368 506119 508891 511988 522340 534019 534839 536986 541409 544143 545415 545550 547453 547890 548954 549832 554752 555088 556899 556906 557327 573204 575859 586760 587035 613032 619607 621259 623154 628656 650326 656942 663181 668690 669074 669387 670346 672942 674917 699734 699745 703574 707408 707418 709640 710531 722273 724281 725149 725647 731148 739993 745086 752655 752697 762252 766348 770312 786512 786850 788572 790101 790365 795538 800396 805514 805694 806583 806919 807945 810365 812109 814266 815511 817291 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (6.50%) |
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 725149 87974 428195 416819 445802 471455 414116 621259 556906 545550 724281 814266 416700 477081 500100 786512 384108 415992 437859 506119 628656 817291 429863 496340 522340 815511 471687 575859 556899 703574 707418 709640 722273 699734 545415 619607 613032 786850 790365 788572 800396 810365 745086 699745 383208 391989 505368 544143 731148 739993 762252 752655 710531 400571 420295 416025 432289 456232 466477 508891 587035 725647 468524 471660 500256 573204 547890 669074 392023 456236 476737 464550 443219 433165 392848 416738 493744 505140 536986 511988 548954 547453 656942 670346 663181 668690 672942 554752 555088 586760 623154 795538 806919 790101 807945 752697 766348 805514 805694 812109 770312 707408 806583 41776 415859 416020 414071 415879 422055 411643 415877 469217 534019 534839 541409 557327 549832 669387 674917 650326 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.39%) |
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 41776 87974 383208 384108 391989 392023 392848 400571 411643 414071 414116 415859 415877 415879 415992 416020 416025 416700 416738 416819 420295 422055 428195 429863 432289 433165 437859 443219 445802 456232 456236 464550 466477 468524 469217 471455 471660 471687 476737 477081 493744 496340 500100 500256 505140 505368 506119 508891 511988 522340 534019 534839 536986 541409 544143 545415 545550 547453 547890 548954 549832 554752 555088 556899 556906 557327 573204 575859 586760 587035 613032 619607 621259 623154 628656 650326 656942 663181 668690 669074 669387 670346 672942 674917 699734 699745 703574 707408 707418 709640 710531 722273 724281 725149 725647 731148 739993 745086 752655 752697 762252 766348 770312 786512 786850 788572 790101 790365 795538 800396 805514 805694 806583 806919 807945 810365 812109 814266 815511 817291 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal gape toys"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большая большие дырк toys"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал большая большие дырк toys"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.