Query Metrics
7
Database Queries
7
Different statements
179.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.42 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.96 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"Ðüð┐ð¥ÐÇÐéð©ð▓ð¢ÐïðÁ ð┤ðÁð▓ÐâÐêð║ð© ðÂð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.76 ms |
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 536823 537728 539052 543295 548003 701350 713049 643434 611211 779674 790881 763395 402134 505339 557931 669337 548745 470311 586932 737628 730802 820650 576090 549557 702162 548723 593113 730867 737114 702165 536659 261061 120415 540492 568124 541707 714455 676982 545475 571219 586832 598923 590762 604068 728230 603910 633518 388696 505326 525278 404360 823173 821184 464522 520164 528034 538255 515547 552337 564024 564771 567741 548628 549551 564440 564799 571997 573651 551270 552181 572197 714491 684995 576319 586138 594305 619130 591319 595398 602568 604063 620285 587247 810572 761980 604043 604114 715077 397128 408824 400986 404696 516737 490987 507669 585129 820346 822502 823309 827957 463706 515070 527250 515543 541735 557629 560476 560574 564619 564769 569859 570188 570576 558450 559032 577359 551248 555791 561721 564000 ] |
||||||||||||||||||||||||||||||
| 4 | 2.83 ms |
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 120415 261061 388696 397128 400986 402134 404360 404696 408824 463706 464522 470311 490987 505326 505339 507669 515070 515543 515547 516737 520164 525278 527250 528034 536659 536823 537728 538255 539052 540492 541707 541735 543295 545475 548003 548628 548723 548745 549551 549557 551248 551270 552181 552337 555791 557629 557931 558450 559032 560476 560574 561721 564000 564024 564440 564619 564769 564771 564799 567741 568124 569859 570188 570576 571219 571997 572197 573651 576090 576319 577359 585129 586138 586832 586932 587247 590762 591319 593113 594305 595398 598923 602568 603910 604043 604063 604068 604114 611211 619130 620285 633518 643434 669337 676982 684995 701350 702162 702165 713049 714455 714491 715077 728230 730802 730867 737114 737628 761980 763395 779674 790881 810572 820346 820650 821184 823173 823309 827957 ] |
||||||||||||||||||||||||||||||
| 5 | 158.28 ms |
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 120415 261061 388696 397128 400986 402134 404360 404696 408824 463706 464522 470311 490987 505326 505339 507669 515070 515543 515547 516737 520164 525278 527250 528034 536659 536823 537728 538255 539052 540492 541707 541735 543295 545475 548003 548628 548723 548745 549551 549557 551248 551270 552181 552337 555791 557629 557931 558450 559032 560476 560574 561721 564000 564024 564440 564619 564769 564771 564799 567741 568124 569859 570188 570576 571219 571997 572197 573651 576090 576319 577359 585129 586138 586832 586932 587247 590762 591319 593113 594305 595398 598923 602568 603910 604043 604063 604068 604114 611211 619130 620285 633518 643434 669337 676982 684995 701350 702162 702165 713049 714455 714491 715077 728230 730802 730867 737114 737628 761980 763395 779674 790881 810572 820346 820650 821184 823173 823309 827957 ] |
||||||||||||||||||||||||||||||
| 6 | 1.68 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 ms |
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.