Query Metrics
7
Database Queries
7
Different statements
186.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.36 ms (83.82%) |
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 425148 454292 514220 518581 526436 527458 538854 540139 540164 541575 542412 545480 548422 550200 551535 551894 554711 554725 554826 555360 557634 558953 559020 560218 561488 562049 565119 565997 566325 567457 568777 570735 577543 578642 579707 586926 588398 590344 590730 592890 598136 599940 600438 605432 607050 607238 608541 614029 614382 614865 615605 616978 617129 619091 619807 623135 623178 624814 640859 644941 645973 647856 648589 651062 651068 651090 651627 656499 656507 662214 662480 662796 666472 668628 671785 678662 678966 679025 681251 683054 699562 699625 704268 712311 714119 714612 723933 729287 734364 737857 740588 741692 741756 743380 746686 747451 748138 748154 749335 750549 757211 767218 768157 775860 786458 786608 788789 790239 790381 795137 800698 801348 803450 809292 809909 811992 815248 815394 820772 820880 ] |
||||||||||||||||||||||||||||||
|
19.84 ms (10.64%) |
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 803450 748138 748154 729287 741692 768157 614382 640859 800698 599940 554725 662214 662480 795137 775860 786458 767218 757211 704268 565119 678966 714612 615605 619091 723933 588398 820880 540139 678662 790381 811992 558953 623135 614029 644941 566325 551535 555360 651062 656499 647856 648589 651627 666472 651068 668628 681251 562049 592890 614865 624814 786608 801348 741756 750549 747451 607238 526436 815248 454292 542412 559020 577543 662796 699562 619807 743380 734364 749335 820772 568777 699625 617129 623178 590344 514220 540164 565997 570735 548422 550200 645973 656507 679025 578642 590730 600438 809292 746686 788789 425148 518581 545480 567457 541575 651090 714119 608541 616978 683054 815394 557634 560218 551894 671785 712311 554711 586926 607050 598136 605432 740588 809909 737857 790239 579707 538854 527458 554826 561488 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.17%) |
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 425148 454292 514220 518581 526436 527458 538854 540139 540164 541575 542412 545480 548422 550200 551535 551894 554711 554725 554826 555360 557634 558953 559020 560218 561488 562049 565119 565997 566325 567457 568777 570735 577543 578642 579707 586926 588398 590344 590730 592890 598136 599940 600438 605432 607050 607238 608541 614029 614382 614865 615605 616978 617129 619091 619807 623135 623178 624814 640859 644941 645973 647856 648589 651062 651068 651090 651627 656499 656507 662214 662480 662796 666472 668628 671785 678662 678966 679025 681251 683054 699562 699625 704268 712311 714119 714612 723933 729287 734364 737857 740588 741692 741756 743380 746686 747451 748138 748154 749335 750549 757211 767218 768157 775860 786458 786608 788789 790239 790381 795137 800698 801348 803450 809292 809909 811992 815248 815394 820772 820880 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass piss"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.