Query Metrics
7
Database Queries
7
Different statements
191.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.62 ms (85.90%) |
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 382475 383049 399393 404261 437244 438459 461116 463224 478541 480472 481262 488332 492287 499577 501061 501677 502011 503774 505389 505946 509232 510008 511435 516553 517170 526038 526848 527437 529491 541203 541545 543827 544527 545511 545957 546241 546546 548180 550622 550929 552117 553896 555028 555454 555482 555768 556110 556144 556561 557402 557841 560522 560745 560897 563178 563273 563376 564650 565877 566184 568799 568932 571096 572093 573485 573841 575583 576771 576935 577419 578159 578745 579465 579885 581954 582894 583741 584250 584842 585217 585574 586203 586707 586954 587332 588835 589392 589583 589622 590180 591732 597670 598525 602043 603419 604501 606691 607996 614777 617512 617961 618599 619906 622827 626217 633657 633983 635009 644517 651963 652159 662826 669281 675389 677237 684511 730224 737840 744197 746040 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (8.58%) |
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 503774 505946 510008 511435 529491 499577 502011 516553 505389 509232 517170 526038 526848 501061 501677 527437 461116 463224 478541 480472 481262 488332 492287 544527 550622 550929 555768 556144 556561 563178 563376 565877 573485 573841 581954 584842 541545 545511 555454 556110 557402 560522 563273 566184 568799 568932 572093 577419 582894 541203 543827 545957 555028 560745 560897 564650 571096 575583 576771 576935 578159 578745 579465 584250 652159 669281 651963 662826 675389 677237 684511 546241 546546 548180 552117 553896 555482 557841 579885 583741 586203 586954 590180 598525 602043 618599 597670 604501 606691 617961 635009 644517 585217 585574 589392 589622 591732 603419 626217 586707 587332 588835 589583 607996 614777 617512 619906 633983 746040 737840 744197 730224 622827 633657 382475 383049 399393 404261 437244 438459 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.62%) |
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 382475 383049 399393 404261 437244 438459 461116 463224 478541 480472 481262 488332 492287 499577 501061 501677 502011 503774 505389 505946 509232 510008 511435 516553 517170 526038 526848 527437 529491 541203 541545 543827 544527 545511 545957 546241 546546 548180 550622 550929 552117 553896 555028 555454 555482 555768 556110 556144 556561 557402 557841 560522 560745 560897 563178 563273 563376 564650 565877 566184 568799 568932 571096 572093 573485 573841 575583 576771 576935 577419 578159 578745 579465 579885 581954 582894 583741 584250 584842 585217 585574 586203 586707 586954 587332 588835 589392 589583 589622 590180 591732 597670 598525 602043 603419 604501 606691 607996 614777 617512 617961 618599 619906 622827 626217 633657 633983 635009 644517 651963 652159 662826 669281 675389 677237 684511 730224 737840 744197 746040 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"постел pussy"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"постел pussy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bed in pussy"
]
|
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.