Query Metrics
7
Database Queries
7
Different statements
149.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.74 ms (84.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 246488 386206 387436 398444 399413 404083 411116 411675 412238 413117 423462 437218 447356 459258 461106 462253 462268 464546 466288 470636 471498 475020 477926 477975 484467 485457 490125 490632 490637 491858 493096 504894 509414 517446 520011 525749 526267 528551 536637 542320 555200 555413 555436 555442 555751 557412 565742 566833 567627 574416 581291 581408 581482 582714 587502 587587 590877 599827 610166 612796 614805 620438 624816 625776 627052 632450 666131 680536 685220 699828 703909 714125 714927 721775 721932 722043 722053 723966 725397 726596 730793 732181 733223 733337 734565 745707 751799 753212 759731 761525 770290 772355 773754 775028 781238 796307 797049 797070 801027 801029 801343 802290 802572 803714 804177 804398 810861 814029 814376 817909 823754 823974 824125 824364 824892 825251 826695 827099 827577 827789 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (8.71%) |
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 802290 470636 721775 459258 555442 826695 827789 557412 797070 520011 761525 411116 399413 753212 484467 824892 411675 555200 775028 423462 477926 566833 825251 814376 581482 612796 387436 730793 723966 804177 772355 751799 733337 722053 745707 732181 632450 493096 796307 412238 699828 525749 528551 491858 614805 824125 404083 817909 714927 475020 447356 823754 666131 587502 733223 773754 703909 797049 587587 726596 714125 759731 801027 477975 466288 536637 610166 246488 509414 827577 555436 810861 386206 827099 802572 625776 526267 581291 581408 627052 599827 555413 722043 582714 725397 485457 462268 680536 437218 542320 734565 565742 770290 721932 620438 471498 574416 504894 590877 413117 490632 823974 555751 567627 814029 804398 781238 685220 803714 624816 801343 398444 462253 490125 461106 824364 517446 801029 464546 490637 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.98%) |
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 246488 386206 387436 398444 399413 404083 411116 411675 412238 413117 423462 437218 447356 459258 461106 462253 462268 464546 466288 470636 471498 475020 477926 477975 484467 485457 490125 490632 490637 491858 493096 504894 509414 517446 520011 525749 526267 528551 536637 542320 555200 555413 555436 555442 555751 557412 565742 566833 567627 574416 581291 581408 581482 582714 587502 587587 590877 599827 610166 612796 614805 620438 624816 625776 627052 632450 666131 680536 685220 699828 703909 714125 714927 721775 721932 722043 722053 723966 725397 726596 730793 732181 733223 733337 734565 745707 751799 753212 759731 761525 770290 772355 773754 775028 781238 796307 797049 797070 801027 801029 801343 802290 802572 803714 804177 804398 810861 814029 814376 817909 823754 823974 824125 824364 824892 825251 826695 827099 827577 827789 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cunnilingus amateur hairy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс любительск волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.