Query Metrics
7
Database Queries
7
Different statements
162.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.89 ms (83.47%) |
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 415836 419571 420447 421048 422152 424658 428965 429006 429848 431963 436437 439685 439697 439813 440601 440693 440954 445306 446909 447935 449778 454801 454947 458333 459319 461763 464953 473139 473463 476283 479956 480837 486854 487228 488772 491782 492289 496060 496585 496794 497103 497236 498909 502191 502249 503617 506946 507276 508003 511752 512410 516034 516060 519512 519676 519871 521927 522733 523160 523171 523740 524217 524639 525286 525713 525929 527218 527341 527358 533010 533833 533848 534201 535282 535434 537670 537672 537914 540071 540267 542213 550288 551050 551995 557042 557845 561273 561385 564132 564267 571257 576535 577400 578382 583037 584610 586654 593485 599414 600411 600995 601906 605529 606624 609838 623216 623681 628415 631597 631919 633734 637421 639810 645004 647328 655591 672804 679398 761088 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (10.37%) |
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 533833 436437 439697 522733 420447 440601 519676 525929 605529 431963 521927 421048 439813 600411 445306 512410 488772 519512 497103 576535 480837 440693 606624 440954 524639 578382 551050 586654 761088 487228 492289 583037 609838 508003 533010 447935 473463 537914 593485 523740 454801 497236 599106 439685 511752 527358 498909 527218 564267 571257 502249 461763 623216 516034 647328 525286 419571 645004 550288 422152 479956 519871 496585 506946 454947 599414 672804 502191 533848 523160 415836 535434 631597 601906 464953 516060 655591 429848 535282 476283 679398 424658 564132 525713 639810 637421 600995 507276 577400 540071 524217 628415 523171 446909 540267 496794 449778 561273 537672 486854 537670 557042 458333 491782 584610 633734 557845 551995 527341 473139 534201 542213 459319 503617 496060 623681 631919 561385 428965 429006 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.62%) |
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 415836 419571 420447 421048 422152 424658 428965 429006 429848 431963 436437 439685 439697 439813 440601 440693 440954 445306 446909 447935 449778 454801 454947 458333 459319 461763 464953 473139 473463 476283 479956 480837 486854 487228 488772 491782 492289 496060 496585 496794 497103 497236 498909 502191 502249 503617 506946 507276 508003 511752 512410 516034 516060 519512 519676 519871 521927 522733 523160 523171 523740 524217 524639 525286 525713 525929 527218 527341 527358 533010 533833 533848 534201 535282 535434 537670 537672 537914 540071 540267 542213 550288 551050 551995 557042 557845 561273 561385 564132 564267 571257 576535 577400 578382 583037 584610 586654 593485 599414 600411 600995 601906 605529 606624 609838 623216 623681 628415 631597 631919 633734 637421 639810 645004 647328 655591 672804 679398 761088 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real blowjob sperm"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real минет оральн секс сперм"
]
|
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.