Query Metrics
7
Database Queries
7
Different statements
421.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.59 ms (48.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy skirt"
]
|
||||||||||||||||||||||||||||||
|
189.73 ms (45.00%) |
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 400508 422511 423675 424411 436074 439301 439326 439695 439736 440139 447412 448083 462346 462930 463016 464835 471515 473505 475483 476223 477339 482737 492170 496554 500366 502315 510891 510908 511678 513844 514413 514715 515705 518750 519248 521102 522111 523833 525064 525669 527142 528535 529216 536938 544150 545819 546370 547658 549248 549255 549682 550744 552664 555429 559095 559725 561944 563098 563456 563852 565322 568078 568382 571198 571244 572273 576629 578399 578703 579795 580125 580256 581616 581806 583139 584637 586009 590408 591378 595256 595454 598545 598609 601935 604205 604873 605058 605372 605398 605639 605746 609729 610628 611500 613282 614743 618787 618823 619165 619308 619423 621355 621980 622987 623920 624935 626136 626448 632569 640690 647090 648575 654322 654464 655087 658281 659115 671104 683508 685791 ] |
||||||||||||||||||||||||||||||
|
19.45 ms (4.61%) |
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 515705 523833 547658 578399 583139 584637 591378 613282 622987 605746 626448 436074 529216 422511 463016 471515 475483 513844 528535 502315 522111 518750 521102 462930 549682 544150 552664 559095 545819 561944 563098 580125 647090 598609 605639 619165 623920 640690 621355 586009 618787 619423 439301 439326 462346 400508 440139 424411 439695 448083 464835 447412 510908 525669 500366 477339 492170 496554 514715 519248 555429 579795 655087 685791 572273 576629 595256 605372 605058 439736 536938 511678 514413 527142 571198 590408 473505 423675 568078 578703 550744 580256 654464 683508 659115 563456 581806 626136 604205 605398 618823 632569 619308 601935 476223 482737 581616 546370 648575 654322 671104 658281 568382 571244 614743 595454 610628 624935 598545 611500 604873 609729 621980 525064 510891 549248 563852 565322 549255 559725 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.58%) |
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 400508 422511 423675 424411 436074 439301 439326 439695 439736 440139 447412 448083 462346 462930 463016 464835 471515 473505 475483 476223 477339 482737 492170 496554 500366 502315 510891 510908 511678 513844 514413 514715 515705 518750 519248 521102 522111 523833 525064 525669 527142 528535 529216 536938 544150 545819 546370 547658 549248 549255 549682 550744 552664 555429 559095 559725 561944 563098 563456 563852 565322 568078 568382 571198 571244 572273 576629 578399 578703 579795 580125 580256 581616 581806 583139 584637 586009 590408 591378 595256 595454 598545 598609 601935 604205 604873 605058 605372 605398 605639 605746 609729 610628 611500 613282 614743 618787 618823 619165 619308 619423 621355 621980 622987 623920 624935 626136 626448 632569 640690 647090 648575 654322 654464 655087 658281 659115 671104 683508 685791 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак юбк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак юбк"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.