Query Metrics
7
Database Queries
7
Different statements
194.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.23 ms (87.34%) |
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 3381 6666 188093 282494 366478 384570 391644 392517 392632 392909 396064 396066 396074 396384 397536 398425 400026 400463 400932 400946 401979 402230 402242 408489 409316 410636 410783 412333 414082 414783 421414 422568 425679 425916 426001 427308 428188 428259 428470 439868 442631 442632 443164 443211 445279 445426 445545 445730 447311 447569 447628 447912 448359 449456 463922 463943 466688 470181 471372 475413 476090 476725 477146 491946 492286 493616 497731 498619 505144 513716 514799 519772 523645 529025 540422 541713 541734 542624 545188 545717 549048 551461 555804 556316 556906 558916 559021 559625 564423 565327 565954 565955 568353 570408 573083 573651 579045 592335 593780 594467 596619 597269 598674 598700 598712 605831 610555 636956 648648 652923 663174 693953 708208 729816 743029 744723 766844 770264 785580 810706 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (8.01%) |
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 400026 556906 810706 476725 558916 693953 743029 729816 396074 410636 414082 541734 188093 425916 766844 408489 529025 400932 514799 392632 493616 447912 549048 568353 598700 596619 785580 402242 409316 426001 428188 541713 443211 428470 397536 505144 573083 648648 593780 475413 422568 447311 439868 597269 400463 540422 770264 402230 559625 598712 396064 400946 545717 542624 663174 396066 428259 448359 6666 401979 425679 447628 466688 447569 498619 497731 492286 565954 559021 570408 573651 652923 708208 598674 636956 744723 398425 410783 445545 384570 471372 282494 463922 477146 491946 519772 523645 391644 442631 445279 414783 565327 565955 545188 551461 564423 555804 592335 605831 594467 427308 470181 392909 412333 476090 421414 513716 610555 396384 442632 443164 445730 556316 3381 449456 366478 392517 579045 463943 445426 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал тощей"
]
|
||||||||||||||||||||||||||||||
|
2.47 ms (1.27%) |
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 3381 6666 188093 282494 366478 384570 391644 392517 392632 392909 396064 396066 396074 396384 397536 398425 400026 400463 400932 400946 401979 402230 402242 408489 409316 410636 410783 412333 414082 414783 421414 422568 425679 425916 426001 427308 428188 428259 428470 439868 442631 442632 443164 443211 445279 445426 445545 445730 447311 447569 447628 447912 448359 449456 463922 463943 466688 470181 471372 475413 476090 476725 477146 491946 492286 493616 497731 498619 505144 513716 514799 519772 523645 529025 540422 541713 541734 542624 545188 545717 549048 551461 555804 556316 556906 558916 559021 559625 564423 565327 565954 565955 568353 570408 573083 573651 579045 592335 593780 594467 596619 597269 598674 598700 598712 605831 610555 636956 648648 652923 663174 693953 708208 729816 743029 744723 766844 770264 785580 810706 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал худая"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал худая"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.61%) |
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.