Query Metrics
7
Database Queries
7
Different statements
181.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.01 ms (84.80%) |
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 398678 400029 410754 412333 415836 420060 425340 425345 425682 429360 431953 437416 439358 443027 444779 445383 447183 447392 450573 450653 451014 454032 459080 459873 460991 463496 465757 470844 476974 477053 479217 480933 483807 486278 486957 487334 488614 488616 489160 490763 491424 491704 493199 493408 495433 496146 496599 498671 499530 499736 500112 502217 504454 505659 507312 511505 511710 511924 513430 529438 536056 536214 540915 541861 545848 549582 552533 552632 555089 555671 556391 557447 558615 558828 559293 560320 560833 562198 563398 564056 564309 565718 565769 567040 567708 568580 568825 568977 573330 575503 575755 576370 579174 581497 581949 582493 583302 584987 594522 595275 596411 596739 600982 602506 605296 609244 616294 626437 627699 661462 688199 693073 701495 721393 766274 771789 789046 799714 810710 818072 ] |
||||||||||||||||||||||||||||||
|
17.58 ms (9.68%) |
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 415836 582493 583302 465757 490763 529438 410754 818072 584987 459080 463496 489160 447183 493199 495433 502217 505659 496146 504454 536056 483807 486278 488616 545848 549582 552533 555671 568825 575503 575755 581497 540915 541861 555089 557447 563398 567708 568977 576370 579174 581949 552632 556391 559293 560320 560833 562198 564056 661462 688199 693073 701495 558615 558828 564309 565769 567040 573330 626437 594522 600982 609244 616294 627699 595275 596411 605296 789046 799714 771789 766274 721393 810710 400029 477053 425682 447392 470844 425345 443027 445383 450653 460991 480933 398678 412333 429360 476974 439358 486957 487334 491704 488614 499530 500112 511710 511924 493408 496599 498671 499736 511505 513430 596739 565718 507312 536214 568580 602506 431953 420060 444779 425340 437416 451014 491424 450573 459873 479217 454032 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.36%) |
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 398678 400029 410754 412333 415836 420060 425340 425345 425682 429360 431953 437416 439358 443027 444779 445383 447183 447392 450573 450653 451014 454032 459080 459873 460991 463496 465757 470844 476974 477053 479217 480933 483807 486278 486957 487334 488614 488616 489160 490763 491424 491704 493199 493408 495433 496146 496599 498671 499530 499736 500112 502217 504454 505659 507312 511505 511710 511924 513430 529438 536056 536214 540915 541861 545848 549582 552533 552632 555089 555671 556391 557447 558615 558828 559293 560320 560833 562198 563398 564056 564309 565718 565769 567040 567708 568580 568825 568977 573330 575503 575755 576370 579174 581497 581949 582493 583302 584987 594522 595275 596411 596739 600982 602506 605296 609244 616294 626437 627699 661462 688199 693073 701495 721393 766274 771789 789046 799714 810710 818072 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые cum 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.