Query Metrics
7
Database Queries
7
Different statements
391.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.48 ms (53.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
155.00 ms (39.62%) |
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 389453 389499 405527 405535 406946 408609 417390 421556 431762 431765 441004 442363 443741 450998 452331 454492 456786 459907 462717 463773 468035 468630 470529 470675 475945 476901 477080 483777 484161 484542 486456 490595 496314 503659 504417 505625 509910 510426 513155 514580 515494 517567 517654 517849 518948 520747 522314 525691 526426 527231 527232 533703 533846 534003 535013 541196 541832 542502 542790 543363 543521 543845 544671 550229 550415 551225 551939 552268 552312 554535 555968 558802 559577 560210 561103 561416 563134 564366 567909 577374 577435 578793 579317 581281 582373 589349 590230 590886 591607 593678 601660 604844 605655 610083 617422 624999 629963 633022 641377 649196 653766 653941 660375 665314 682531 703472 721047 726543 726553 735471 736627 741116 742926 785333 789724 799653 812790 814255 815313 818471 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (4.29%) |
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 389499 496314 591607 509910 510426 522314 483777 431762 815313 456786 476901 563134 660375 665314 550229 641377 452331 405535 550415 534003 503659 514580 551225 559577 590230 517567 408609 463773 477080 513155 518948 505625 726543 726553 405527 527232 525691 389453 406946 421556 814255 818471 490595 475945 520747 527231 533703 470675 543363 558802 542502 564366 581281 543521 551939 552312 560210 561416 653766 721047 649196 653941 544671 593678 589349 604844 601660 624999 785333 799653 741116 736627 735471 633022 703472 454492 462717 470529 517654 533846 682531 742926 468035 535013 468630 484542 552268 486456 541832 577435 629963 617422 450998 504417 555968 610083 443741 484161 459907 526426 541196 542790 579317 578793 543845 554535 561103 577374 582373 590886 605655 789724 812790 431765 417390 515494 517849 442363 567909 441004 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (0.96%) |
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 389453 389499 405527 405535 406946 408609 417390 421556 431762 431765 441004 442363 443741 450998 452331 454492 456786 459907 462717 463773 468035 468630 470529 470675 475945 476901 477080 483777 484161 484542 486456 490595 496314 503659 504417 505625 509910 510426 513155 514580 515494 517567 517654 517849 518948 520747 522314 525691 526426 527231 527232 533703 533846 534003 535013 541196 541832 542502 542790 543363 543521 543845 544671 550229 550415 551225 551939 552268 552312 554535 555968 558802 559577 560210 561103 561416 563134 564366 567909 577374 577435 578793 579317 581281 582373 589349 590230 590886 591607 593678 601660 604844 605655 610083 617422 624999 629963 633022 641377 649196 653766 653941 660375 665314 682531 703472 721047 726543 726553 735471 736627 741116 742926 785333 789724 799653 812790 814255 815313 818471 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"two mother"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"two мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"two мам женщин"
]
|
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.