Query Metrics
7
Database Queries
7
Different statements
176.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.68 ms (83.70%) |
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 384900 395218 402866 402978 417318 420696 420737 420879 421660 424534 424753 438042 438291 443066 444053 445747 445756 446868 455522 455657 456359 460718 463708 465905 472094 474538 476304 479970 481494 483982 484002 487239 487999 488996 490198 490524 491377 491387 495484 498111 498115 502639 502832 504833 510079 510609 510771 511543 513695 518587 518975 520272 523299 523593 525971 527601 532351 533004 534575 535960 537692 539116 540369 542832 543420 546419 550592 551178 553768 554805 555076 561435 563690 565372 565398 573291 575398 577953 579717 579775 580642 580993 581030 584950 587506 593793 598757 599386 606566 611435 620240 620645 625323 635577 638117 640871 641480 643315 647262 648497 654273 660995 662905 682573 705801 712549 720445 724790 734387 744596 756183 761040 775224 780506 783161 783736 796531 803214 805229 810108 ] |
||||||||||||||||||||||||||||||
|
17.93 ms (10.16%) |
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 662905 648497 720445 611435 498111 620240 523299 561435 660995 724790 638117 504833 491377 783736 488996 550592 575398 647262 598757 803214 744596 577953 456359 579717 384900 810108 523593 395218 481494 460718 446868 542832 565398 580993 573291 479970 490524 483982 654273 643315 417318 796531 402866 553768 599386 780506 705801 775224 424534 682573 555076 563690 620645 402978 584950 510079 424753 537692 540369 579775 641480 756183 761040 734387 476304 445747 805229 534575 587506 420696 443066 502832 484002 625323 438042 420737 455522 593793 421660 444053 487999 532351 487239 539116 495484 783161 472094 510771 498115 527601 420879 520272 465905 455657 518587 525971 533004 474538 581030 712549 606566 445756 463708 491387 513695 554805 518975 551178 438291 510609 546419 543420 565372 490198 640871 535960 511543 580642 635577 502639 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.94%) |
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 384900 395218 402866 402978 417318 420696 420737 420879 421660 424534 424753 438042 438291 443066 444053 445747 445756 446868 455522 455657 456359 460718 463708 465905 472094 474538 476304 479970 481494 483982 484002 487239 487999 488996 490198 490524 491377 491387 495484 498111 498115 502639 502832 504833 510079 510609 510771 511543 513695 518587 518975 520272 523299 523593 525971 527601 532351 533004 534575 535960 537692 539116 540369 542832 543420 546419 550592 551178 553768 554805 555076 561435 563690 565372 565398 573291 575398 577953 579717 579775 580642 580993 581030 584950 587506 593793 598757 599386 606566 611435 620240 620645 625323 635577 638117 640871 641480 643315 647262 648497 654273 660995 662905 682573 705801 712549 720445 724790 734387 744596 756183 761040 775224 780506 783161 783736 796531 803214 805229 810108 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucking public"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucking на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucking на улиц"
]
|
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.