Query Metrics
7
Database Queries
7
Different statements
286.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
260.94 ms (91.17%) |
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 418353 418690 419197 420028 420814 421027 422149 424830 424991 425570 426153 427591 432394 432438 432440 432466 432776 433140 433572 436135 437266 437416 443069 446356 451878 452456 454039 455687 456936 458220 459865 468990 475195 475208 480331 482687 484228 486637 505077 513371 514357 516850 517393 519455 519577 519740 521021 522653 522678 522992 523793 529105 530484 531115 531145 533466 534386 536394 541201 542155 542583 542595 543627 545117 545489 545838 560783 561937 561944 562869 568731 571433 571656 595381 605748 607626 610346 617533 624320 628037 629330 632594 632611 633493 633766 633806 634158 634787 637438 640779 642038 645003 646935 647914 649110 649384 651168 664468 666899 666903 684845 685818 696229 696451 702680 716203 717318 720484 720938 729223 740527 770330 773856 798666 799743 800556 813249 814556 817268 ] |
||||||||||||||||||||||||||||||
|
16.36 ms (5.72%) |
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 424830 427591 817268 814556 451878 545489 684845 685818 649384 664468 628037 773856 813249 729223 770330 633493 425570 454039 523793 519740 720484 568731 437266 421027 482687 459865 484228 522653 475208 456936 455687 522678 443069 536394 561937 617533 418353 420028 513371 516850 505077 571433 422149 505794 437416 645003 542155 696229 545117 624320 432466 432438 605748 799743 800556 629330 433572 486637 610346 424991 560783 595381 517393 519577 740527 571656 798666 426153 436135 432440 522992 531145 529105 534386 468990 475195 514357 419197 530484 696451 452456 562869 649110 632611 432394 651168 637438 607626 633766 720938 433140 716203 420814 545838 521021 519455 531115 541201 542595 543627 633806 458220 533466 542583 666899 646935 666903 632594 634158 642038 717318 418690 432776 480331 446356 561944 702680 647914 634787 640779 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.85%) |
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 418353 418690 419197 420028 420814 421027 422149 424830 424991 425570 426153 427591 432394 432438 432440 432466 432776 433140 433572 436135 437266 437416 443069 446356 451878 452456 454039 455687 456936 458220 459865 468990 475195 475208 480331 482687 484228 486637 505077 513371 514357 516850 517393 519455 519577 519740 521021 522653 522678 522992 523793 529105 530484 531115 531145 533466 534386 536394 541201 542155 542583 542595 543627 545117 545489 545838 560783 561937 561944 562869 568731 571433 571656 595381 605748 607626 610346 617533 624320 628037 629330 632594 632611 633493 633766 633806 634158 634787 637438 640779 642038 645003 646935 647914 649110 649384 651168 664468 666899 666903 684845 685818 696229 696451 702680 716203 717318 720484 720938 729223 740527 770330 773856 798666 799743 800556 813249 814556 817268 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen handjob cum"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen дрочк член cum"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen дрочк член cum"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.45%) |
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.