Query Metrics
7
Database Queries
7
Different statements
639.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
269.86 ms (42.18%) |
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 398229 413335 414108 468360 465082 461318 477135 695799 619070 795702 796141 796149 796941 794777 795356 783302 794781 795788 800569 732296 760998 759759 757650 784170 792541 442057 432704 478611 466164 471407 560968 788565 393856 543532 681755 627358 778424 444060 470147 486212 592955 761029 788860 401621 400487 448795 486610 536444 124144 564549 791800 810318 799910 802025 712296 825242 388740 828555 529337 540565 545175 736237 748068 729291 742637 765723 766985 756677 731349 827870 660061 682811 709528 591971 604302 772740 704264 429567 496893 576744 724755 769132 713652 563090 391668 464835 151179 151062 401768 411436 451643 493757 478413 602293 777750 444208 446522 504665 391594 3444 397085 398106 443896 411382 428611 443159 414763 486046 452982 469261 448374 534633 577949 564551 714453 636242 780745 795313 742861 794766 ] |
||||||||||||||||||||||||||||||
|
216.10 ms (33.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск мам женщин"
]
|
||||||||||||||||||||||||||||||
|
146.31 ms (22.87%) |
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 3444 124144 151062 151179 388740 391594 391668 393856 397085 398106 398229 400487 401621 401768 411382 411436 413335 414108 414763 428611 429567 432704 442057 443159 443896 444060 444208 446522 448374 448795 451643 452982 461318 464835 465082 466164 468360 469261 470147 471407 477135 478413 478611 486046 486212 486610 493757 496893 504665 529337 534633 536444 540565 543532 545175 560968 563090 564549 564551 576744 577949 591971 592955 602293 604302 619070 627358 636242 660061 681755 682811 695799 704264 709528 712296 713652 714453 724755 729291 731349 732296 736237 742637 742861 748068 756677 757650 759759 760998 761029 765723 766985 769132 772740 777750 778424 780745 783302 784170 788565 788860 791800 792541 794766 794777 794781 795313 795356 795702 795788 796141 796149 796941 799910 800569 802025 810318 825242 828555 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (0.40%) |
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 3444 124144 151062 151179 388740 391594 391668 393856 397085 398106 398229 400487 401621 401768 411382 411436 413335 414108 414763 428611 429567 432704 442057 443159 443896 444060 444208 446522 448374 448795 451643 452982 461318 464835 465082 466164 468360 469261 470147 471407 477135 478413 478611 486046 486212 486610 493757 496893 504665 529337 534633 536444 540565 543532 545175 560968 563090 564549 564551 576744 577949 591971 592955 602293 604302 619070 627358 636242 660061 681755 682811 695799 704264 709528 712296 713652 714453 724755 729291 731349 732296 736237 742637 742861 748068 756677 757650 759759 760998 761029 765723 766985 769132 772740 777750 778424 780745 783302 784170 788565 788860 791800 792541 794766 794777 794781 795313 795356 795702 795788 796141 796149 796941 799910 800569 802025 810318 825242 828555 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любительское мамаши с…"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.