Query Metrics
7
Database Queries
7
Different statements
191.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.11 ms (86.23%) |
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 389982 416958 456745 456746 459433 460539 460772 460790 461186 462564 470891 473560 473978 477365 484352 493310 496528 497151 500463 500464 500510 500526 506517 511162 513408 513783 514668 516161 517591 518756 522033 530907 533962 540519 540521 542744 542792 545018 547949 547951 552380 566413 566424 569579 576854 577085 579306 584245 585625 587759 588016 590364 593615 593838 602871 603651 617373 618234 618260 632513 635875 643800 648910 650018 654224 661300 662522 664390 673468 681791 682762 694632 702372 710839 715569 716309 725216 726597 727471 729216 729220 729945 730171 730215 730405 731356 732266 732553 732604 732892 733074 733216 733241 733361 734368 735559 735805 735860 745553 747745 748436 757286 759846 761088 761402 761444 773287 792669 793321 793532 795814 797157 803873 807706 808285 808332 818750 819747 824324 824568 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (8.19%) |
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 460790 803873 735805 748436 517591 635875 547951 761088 729216 824568 734368 590364 540519 579306 566424 643800 735860 733216 484352 533962 729220 733074 500464 547949 576854 603651 588016 731356 470891 416958 462564 506517 761444 795814 497151 585625 702372 729945 545018 664390 648910 602871 730215 808332 566413 542744 542792 456745 459433 552380 654224 530907 732892 733241 732604 496528 732553 807706 725216 730405 757286 759846 793321 824324 593838 618234 632513 673468 818750 716309 808285 730171 761402 650018 477365 500510 726597 661300 500526 577085 682762 710839 715569 593615 617373 773287 540521 618260 500463 513408 584245 456746 518756 587759 793532 745553 735559 389982 460539 473560 513783 461186 694632 569579 732266 747745 460772 473978 522033 514668 516161 493310 511162 819747 797157 727471 733361 792669 662522 681791 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (2.10%) |
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 389982 416958 456745 456746 459433 460539 460772 460790 461186 462564 470891 473560 473978 477365 484352 493310 496528 497151 500463 500464 500510 500526 506517 511162 513408 513783 514668 516161 517591 518756 522033 530907 533962 540519 540521 542744 542792 545018 547949 547951 552380 566413 566424 569579 576854 577085 579306 584245 585625 587759 588016 590364 593615 593838 602871 603651 617373 618234 618260 632513 635875 643800 648910 650018 654224 661300 662522 664390 673468 681791 682762 694632 702372 710839 715569 716309 725216 726597 727471 729216 729220 729945 730171 730215 730405 731356 732266 732553 732604 732892 733074 733216 733241 733361 734368 735559 735805 735860 745553 747745 748436 757286 759846 761088 761402 761444 773287 792669 793321 793532 795814 797157 803873 807706 808285 808332 818750 819747 824324 824568 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur milf cuckold"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск milf куколд"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск milf куколд"
]
|
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.