Query Metrics
7
Database Queries
7
Different statements
161.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.76 ms (85.98%) |
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 38782 118284 182110 182754 187856 272725 311201 382384 389639 390554 391036 391493 395910 396980 397407 401879 407191 416295 417163 424870 425124 449020 454506 458115 476305 482627 484070 485287 490180 502252 505823 529210 529285 531963 534864 537267 542444 554967 569537 583154 588652 591971 592813 596525 601082 610316 614733 620219 625755 644682 648568 660061 661311 662074 665209 665290 665833 672723 675511 681134 685900 689358 695188 696460 699809 707541 709861 718974 721741 726038 728115 733122 737526 740159 741201 742795 746060 755953 757083 757247 757525 763024 765147 768660 769340 770925 770998 771610 772322 774918 775835 775880 775980 776638 776732 776737 777719 780679 781844 781902 788318 790628 795553 798607 800066 800214 800426 800557 800885 801405 801470 801741 806140 807710 809205 810797 810892 811488 819508 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (8.17%) |
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 709861 610316 592813 596525 620219 644682 776732 795553 809205 800557 742795 755953 770925 800426 800885 733122 746060 770998 737526 769340 771610 780679 801405 807710 397407 395910 390554 601082 490180 614733 187856 382384 695188 775980 449020 529285 583154 806140 776638 389639 537267 396980 458115 485287 505823 689358 425124 482627 38782 401879 819508 554967 665209 662074 696460 781902 811488 773996 424870 454506 484070 660061 591971 800214 798607 740159 757083 810797 757525 391493 311201 391036 407191 417163 718974 681134 721741 775880 775835 776737 741201 765147 801741 416295 272725 182110 118284 182754 531963 534864 529210 502252 476305 542444 569537 648568 661311 665833 672723 675511 665290 685900 699809 707541 588652 625755 774918 777719 781844 788318 790628 800066 810892 757247 763024 768660 801470 726038 728115 772322 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.78%) |
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 38782 118284 182110 182754 187856 272725 311201 382384 389639 390554 391036 391493 395910 396980 397407 401879 407191 416295 417163 424870 425124 449020 454506 458115 476305 482627 484070 485287 490180 502252 505823 529210 529285 531963 534864 537267 542444 554967 569537 583154 588652 591971 592813 596525 601082 610316 614733 620219 625755 644682 648568 660061 661311 662074 665209 665290 665833 672723 675511 681134 685900 689358 695188 696460 699809 707541 709861 718974 721741 726038 728115 733122 737526 740159 741201 742795 746060 755953 757083 757247 757525 763024 765147 768660 769340 770925 770998 771610 772322 774918 775835 775880 775980 776638 776732 776737 777719 780679 781844 781902 788318 790628 795553 798607 800066 800214 800426 800557 800885 801405 801470 801741 806140 807710 809205 810797 810892 811488 819508 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс беловолосая milf"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс беловолосая milf"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck blonde milf"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.82%) |
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.