Query Metrics
7
Database Queries
7
Different statements
418.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.39 ms (50.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"юбк teen"
]
|
||||||||||||||||||||||||||||||
|
180.80 ms (43.18%) |
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 390929 403797 406308 409024 415134 422511 423675 426009 428970 433185 433531 435433 439301 439326 442367 444781 445781 445961 447412 447844 453409 454583 456240 460296 462527 467558 468108 469751 470130 470175 472712 484078 484298 485232 491664 491924 491952 492170 495109 497413 497613 497885 500299 503144 503381 504906 506093 509454 510505 511920 512073 513492 513560 515690 515709 515833 518490 519248 519559 519577 519671 520459 521102 521823 525669 529033 529177 536693 537307 537888 544150 551226 554272 556500 558820 559095 560669 561944 564705 566810 567142 571847 574184 574696 578408 579328 580125 580253 584709 584886 585431 591345 592408 595448 597550 598437 598609 602829 605372 606165 608347 613488 619165 619451 622381 622987 623920 625450 625870 629036 635487 653252 653455 653463 654109 661510 667985 684566 685791 689634 ] |
||||||||||||||||||||||||||||||
|
18.70 ms (4.47%) |
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 447844 433531 444781 467558 468108 470130 470175 390929 445961 456240 460296 469751 521823 484078 495109 504906 506093 484298 491924 491952 513492 515709 519577 497413 500299 503381 515833 518490 537888 564705 622987 629036 595448 598437 597550 625870 403797 409024 422511 442367 445781 462527 485232 520459 515690 521102 509454 519559 551226 556500 574696 579328 584886 544150 559095 574184 558820 561944 580125 580253 661510 689634 653252 566810 567142 578408 598609 619165 623920 625450 591345 592408 585431 602829 622381 439301 439326 428970 435433 472712 426009 447412 513560 529033 512073 519671 529177 497613 497885 525669 491664 654109 554272 613488 511920 406308 492170 536693 537307 503144 519248 571847 653455 684566 653463 685791 667985 560669 584709 635487 606165 605372 619451 608347 453409 454583 510505 433185 415134 423675 ] |
||||||||||||||||||||||||||||||
|
4.61 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skirt teen"
]
|
||||||||||||||||||||||||||||||
|
2.50 ms (0.60%) |
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 390929 403797 406308 409024 415134 422511 423675 426009 428970 433185 433531 435433 439301 439326 442367 444781 445781 445961 447412 447844 453409 454583 456240 460296 462527 467558 468108 469751 470130 470175 472712 484078 484298 485232 491664 491924 491952 492170 495109 497413 497613 497885 500299 503144 503381 504906 506093 509454 510505 511920 512073 513492 513560 515690 515709 515833 518490 519248 519559 519577 519671 520459 521102 521823 525669 529033 529177 536693 537307 537888 544150 551226 554272 556500 558820 559095 560669 561944 564705 566810 567142 571847 574184 574696 578408 579328 580125 580253 584709 584886 585431 591345 592408 595448 597550 598437 598609 602829 605372 606165 608347 613488 619165 619451 622381 622987 623920 625450 625870 629036 635487 653252 653455 653463 654109 661510 667985 684566 685791 689634 ] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"юбк teen"
]
|
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.