Query Metrics
7
Database Queries
7
Different statements
189.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.47 ms (85.33%) |
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 255858 387858 400396 408961 414104 414277 414421 420061 423311 426939 428759 435523 444819 445930 447334 451638 454095 457593 465311 466642 468257 468658 468818 472279 479722 479784 480620 481327 493427 494409 494886 502368 509837 511229 513862 525911 529254 531053 538034 539219 543218 543454 544126 544570 545821 550451 553774 560457 563265 564999 570889 589229 590402 595015 595425 596349 601349 609551 617953 635891 638864 647823 664237 665763 670338 677054 687376 692538 697589 698994 703947 703960 705741 712987 714395 717921 718089 720955 721118 722216 724536 725704 725824 730637 733856 737552 742033 742727 755427 758498 763516 764396 772032 772609 775282 775365 776416 776491 777075 777581 783448 791394 791688 792174 794560 795251 795498 795529 797505 797738 798433 798584 800875 800891 801416 802671 811215 812907 813054 814041 ] |
||||||||||||||||||||||||||||||
|
12.53 ms (6.62%) |
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 479722 513862 539219 529254 509837 531053 472279 543218 543454 544126 544570 563265 665763 687376 692538 703960 712987 647823 664237 677054 705741 714395 697589 717921 718089 722216 601349 617953 590402 595015 595425 596349 635891 589229 609551 638864 775365 777581 791688 792174 795498 795529 798433 800875 813054 783448 794560 795251 811215 725704 772609 797505 801416 724536 725824 755427 742033 772032 763516 764396 775282 776416 776491 777075 791394 797738 800891 802671 812907 400396 426939 444819 457593 465311 447334 408961 420061 494886 525911 423311 428759 814041 466642 493427 445930 451638 479784 481327 511229 538034 553774 570889 545821 560457 564999 721118 670338 698994 720955 798584 730637 733856 737552 742727 758498 414277 414421 480620 468818 468257 502368 494409 255858 387858 414104 435523 468658 454095 550451 703947 ] |
||||||||||||||||||||||||||||||
|
5.73 ms (3.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп babe"
]
|
||||||||||||||||||||||||||||||
|
3.87 ms (2.04%) |
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 255858 387858 400396 408961 414104 414277 414421 420061 423311 426939 428759 435523 444819 445930 447334 451638 454095 457593 465311 466642 468257 468658 468818 472279 479722 479784 480620 481327 493427 494409 494886 502368 509837 511229 513862 525911 529254 531053 538034 539219 543218 543454 544126 544570 545821 550451 553774 560457 563265 564999 570889 589229 590402 595015 595425 596349 601349 609551 617953 635891 638864 647823 664237 665763 670338 677054 687376 692538 697589 698994 703947 703960 705741 712987 714395 717921 718089 720955 721118 722216 724536 725704 725824 730637 733856 737552 742033 742727 755427 758498 763516 764396 772032 772609 775282 775365 776416 776491 777075 777581 783448 791394 791688 792174 794560 795251 795498 795529 797505 797738 798433 798584 800875 800891 801416 802671 811215 812907 813054 814041 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass babe"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп babe"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
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.