Query Metrics
7
Database Queries
7
Different statements
339.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.88 ms (60.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп пов рак"
]
|
||||||||||||||||||||||||||||||
|
111.17 ms (32.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 53698 383362 389965 397767 400726 401567 413007 417171 421648 421853 424155 425150 425538 426820 427009 432625 433729 433854 434557 439474 441406 441921 441988 442025 442136 444035 445838 448955 450821 452560 453431 454455 456263 457443 461639 464113 466403 468342 468418 474242 475108 478385 481751 482113 482876 483025 483210 483271 485599 487235 487599 494789 495822 496243 502598 502854 517883 518411 519178 527668 533269 535854 543312 557766 558662 559015 561617 563299 565010 568531 579615 583344 586056 592149 595015 597892 601420 602802 607161 607578 607948 616832 618118 619829 620776 624351 625360 627329 629993 638150 646702 653077 679863 691157 702280 707069 720337 750307 761461 763433 764856 765977 780504 783719 788048 791493 791624 791725 795617 796061 797367 797424 801101 806116 810424 811161 825955 828067 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (4.25%) |
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 620776 627329 780504 797424 557766 796061 383362 53698 595015 400726 464113 568531 602802 441406 444035 417171 468342 445838 461639 466403 452560 624351 750307 618118 397767 519178 720337 607948 791493 797367 763433 764856 806116 810424 825955 828067 482876 822950 434557 441921 432625 450821 453431 454455 468418 563299 579615 616832 425150 413007 442136 475108 487235 565010 766050 801101 761461 441988 474242 502854 533269 389965 496243 543312 561617 586056 607161 788048 426820 527668 425538 487599 583344 597892 427009 457443 421853 485599 483271 518411 483025 791725 811161 629993 783719 791624 433854 517883 502598 691157 795617 607578 638150 481751 433729 456263 559015 619829 401567 442025 439474 478385 494789 482113 679863 448955 421648 424155 483210 707069 535854 601420 765977 495822 558662 646702 653077 702280 592149 625360 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.69%) |
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 53698 383362 389965 397767 400726 401567 413007 417171 421648 421853 424155 425150 425538 426820 427009 432625 433729 433854 434557 439474 441406 441921 441988 442025 442136 444035 445838 448955 450821 452560 453431 454455 456263 457443 461639 464113 466403 468342 468418 474242 475108 478385 481751 482113 482876 483025 483210 483271 485599 487235 487599 494789 495822 496243 502598 502854 517883 518411 519178 527668 533269 535854 543312 557766 558662 559015 561617 563299 565010 568531 579615 583344 586056 592149 595015 597892 601420 602802 607161 607578 607948 616832 618118 619829 620776 624351 625360 627329 629993 638150 646702 653077 679863 691157 702280 707069 720337 750307 761461 763433 764856 765977 780504 783719 788048 791493 791624 791725 795617 796061 797367 797424 801101 806116 810424 811161 825955 828067 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass pov doggy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.