Query Metrics
7
Database Queries
7
Different statements
417.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.37 ms (50.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в длинные плат"
]
|
||||||||||||||||||||||||||||||
|
176.71 ms (42.29%) |
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 193874 418034 420087 422558 425687 430244 431193 433789 436419 438369 442360 443639 443921 444134 445834 451724 453167 454168 454465 455344 455405 456453 459715 462956 463415 464491 465028 466016 466666 468828 468919 469276 470147 472810 474468 474489 475314 476518 477779 479025 479549 481238 487168 490653 492034 493353 494031 494614 494665 494736 496821 497369 498643 498664 498936 502299 502417 504752 505613 506270 508288 511745 512884 513377 513948 514480 514864 516637 518218 519539 520412 521621 525452 525806 529833 542978 545977 548658 549631 551876 558952 560514 564424 566123 569197 571374 573265 581626 584203 584300 584981 585731 587835 589676 591672 593518 595780 597927 599714 600406 601138 601216 605033 605257 609146 610081 613163 614377 618572 618754 620134 625762 627822 628096 635697 637517 639527 642571 679166 783154 ] |
||||||||||||||||||||||||||||||
|
20.64 ms (4.94%) |
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 548658 571374 584203 584300 587835 600406 642571 591672 609146 618572 637517 599714 593518 597927 625762 605033 613163 627822 783154 433789 442360 445834 466016 468919 193874 459715 477779 481238 418034 425687 462956 465028 479025 502299 490653 506270 512884 513377 493353 498664 505613 494665 502417 520412 585731 472810 468828 516637 529833 679166 601216 589676 620134 479549 508288 513948 518218 498643 430244 453167 464491 474489 454168 463415 470147 454465 475314 525806 504752 514480 469276 564424 573265 542978 566123 551876 558952 581626 610081 605257 618754 635697 614377 639527 420087 474468 476518 431193 455344 456453 438369 444134 422558 466666 521621 494031 492034 494614 494736 498936 496821 519539 497369 569197 595780 628096 443639 487168 511745 525452 560514 545977 601138 514864 549631 443921 436419 584981 451724 455405 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (0.66%) |
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 193874 418034 420087 422558 425687 430244 431193 433789 436419 438369 442360 443639 443921 444134 445834 451724 453167 454168 454465 455344 455405 456453 459715 462956 463415 464491 465028 466016 466666 468828 468919 469276 470147 472810 474468 474489 475314 476518 477779 479025 479549 481238 487168 490653 492034 493353 494031 494614 494665 494736 496821 497369 498643 498664 498936 502299 502417 504752 505613 506270 508288 511745 512884 513377 513948 514480 514864 516637 518218 519539 520412 521621 525452 525806 529833 542978 545977 548658 549631 551876 558952 560514 564424 566123 569197 571374 573265 581626 584203 584300 584981 585731 587835 589676 591672 593518 595780 597927 599714 600406 601138 601216 605033 605257 609146 610081 613163 614377 618572 618754 620134 625762 627822 628096 635697 637517 639527 642571 679166 783154 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в длинных платьях"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.41%) |
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.