Query Metrics
7
Database Queries
7
Different statements
170.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.88 ms (84.75%) |
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 382815 383359 391725 398528 428354 431161 462043 462230 472797 472874 488223 507804 527800 543826 547869 552646 554264 557376 559961 560584 561013 562201 563488 564223 564424 566831 569875 570202 570290 571301 571625 571661 572151 572757 573606 573839 574606 575760 580664 582910 587930 599614 600619 605523 607082 615713 620626 629029 632330 635912 649166 651544 652978 654178 654432 655096 655356 655401 655421 656029 656084 656381 656423 656469 656684 656965 657293 657376 657925 658315 658344 658607 658715 658719 658753 659087 659274 659549 659755 659836 660311 660562 660897 661262 661270 661897 662040 662711 670462 670816 670817 671115 671138 673131 673961 674778 680338 693885 699602 701309 706969 712731 715652 716504 720033 721264 721541 723487 724727 724782 726458 727594 729141 730649 732010 733861 738243 810280 810841 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (8.78%) |
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 563488 566831 570202 571625 571661 573606 580664 582910 655401 657293 657925 658315 658344 658607 658719 659549 659755 659836 662711 670462 670817 671138 673131 674778 706969 721264 723487 649166 654432 655421 656029 656469 658715 658753 659087 660897 662040 670816 671115 673961 680338 654178 655096 655356 656084 656381 656423 656684 656965 660562 661270 661897 712731 716504 572757 573839 605523 632330 635912 599614 600619 629029 810280 810841 724727 730649 732010 724782 726458 738243 715652 693885 543826 552646 575760 561013 570290 651544 659274 660311 661262 701309 557376 587930 729141 733861 428354 559961 564424 574606 560584 652978 720033 564223 607082 727594 721541 507804 391725 488223 527800 620626 383359 462230 657376 547869 615713 462043 382815 472797 431161 699602 398528 472874 554264 562201 569875 569904 571301 572151 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.99%) |
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 382815 383359 391725 398528 428354 431161 462043 462230 472797 472874 488223 507804 527800 543826 547869 552646 554264 557376 559961 560584 561013 562201 563488 564223 564424 566831 569875 570202 570290 571301 571625 571661 572151 572757 573606 573839 574606 575760 580664 582910 587930 599614 600619 605523 607082 615713 620626 629029 632330 635912 649166 651544 652978 654178 654432 655096 655356 655401 655421 656029 656084 656381 656423 656469 656684 656965 657293 657376 657925 658315 658344 658607 658715 658719 658753 659087 659274 659549 659755 659836 660311 660562 660897 661262 661270 661897 662040 662711 670462 670816 670817 671115 671138 673131 673961 674778 680338 693885 699602 701309 706969 712731 715652 716504 720033 721264 721541 723487 724727 724782 726458 727594 729141 730649 732010 733861 738243 810280 810841 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big small cock"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие маленькая cock"
]
|
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.