Query Metrics
7
Database Queries
7
Different statements
215.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.93 ms (86.38%) |
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 405543 413126 415294 415745 418213 421630 423937 425903 429600 434951 436684 438956 441623 441853 443138 444823 446629 449289 452756 455729 456079 456661 457554 460540 464703 464725 464960 467684 467897 469690 471124 473728 474976 477797 481777 488807 489971 494017 496259 501374 506142 507884 514233 514309 515175 518179 519208 520099 521244 523068 523381 523798 524303 524534 524913 525827 531519 533018 548319 553127 555996 556835 559216 559521 567006 568404 570062 572954 574376 575601 578680 579149 581320 582336 584336 584351 585373 586027 588876 590501 593061 595418 601927 602578 607154 610660 618399 619221 619747 621351 639897 642504 643728 659412 666095 666523 679121 710566 714508 720271 721780 726543 726553 740920 751577 757436 784488 790930 797170 802817 804168 805413 806733 807219 807485 810068 812336 814175 814857 815869 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (8.55%) |
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 501374 423937 477797 531519 666095 619747 523068 436684 444823 425903 533018 574376 567006 548319 559521 570062 595418 619221 643728 642504 806733 740920 601927 405543 415294 460540 467684 494017 523798 525827 815869 452756 457554 488807 523381 559216 555996 553127 582336 586027 585373 639897 790930 810068 784488 804168 807219 812336 805413 757436 710566 721780 802817 807485 421630 520099 524303 524913 556835 610660 618399 519208 572954 666523 464703 456661 415745 496259 797170 441853 814175 446629 473728 455729 456079 524534 726543 726553 441623 443138 449289 471124 518179 568404 659412 720271 679121 578680 581320 607154 467897 434951 481777 514309 413126 429600 814857 464725 514233 575601 584351 714508 588876 590501 602578 621351 751577 438956 521244 489971 469690 464960 507884 474976 418213 506142 515175 593061 584336 579149 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.45%) |
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 405543 413126 415294 415745 418213 421630 423937 425903 429600 434951 436684 438956 441623 441853 443138 444823 446629 449289 452756 455729 456079 456661 457554 460540 464703 464725 464960 467684 467897 469690 471124 473728 474976 477797 481777 488807 489971 494017 496259 501374 506142 507884 514233 514309 515175 518179 519208 520099 521244 523068 523381 523798 524303 524534 524913 525827 531519 533018 548319 553127 555996 556835 559216 559521 567006 568404 570062 572954 574376 575601 578680 579149 581320 582336 584336 584351 585373 586027 588876 590501 593061 595418 601927 602578 607154 610660 618399 619221 619747 621351 639897 642504 643728 659412 666095 666523 679121 710566 714508 720271 721780 726543 726553 740920 751577 757436 784488 790930 797170 802817 804168 805413 806733 807219 807485 810068 812336 814175 814857 815869 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ play"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits play"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ play"
]
|
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.