Query Metrics
7
Database Queries
7
Different statements
202.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.05 ms (88.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 113322 182689 188335 223010 336058 381757 381941 382130 382402 382906 383237 385933 391696 391989 392489 394120 396353 398229 398615 398932 400855 401003 403426 405146 405446 405847 413335 421883 422193 428580 433353 440781 441063 441774 441782 441785 442057 447022 448670 453091 459638 460672 466312 468357 471179 474498 478611 488947 490707 508807 517696 547032 557612 558288 561992 562599 584056 585434 597099 609083 643689 650969 660061 664318 665100 665289 666094 666121 666778 667597 680297 706232 712622 713422 713426 713429 713448 724489 724592 725620 726650 730109 733169 735944 736472 739935 740238 755601 759759 761072 765476 769491 770125 771477 782001 794853 794855 794867 794872 794873 795921 795927 795947 795951 795974 796679 797521 798773 807033 808045 817961 819411 824747 824961 826287 827329 828036 828200 828201 828334 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (6.66%) |
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 736472 733169 726650 807033 468357 396353 398615 401003 448670 490707 561992 665100 666778 794867 770125 453091 474498 517696 405446 712622 713429 713426 713422 724592 730109 725620 740238 713448 385933 223010 405146 667597 664318 557612 794872 724489 782001 381941 828201 383237 398229 413335 441782 488947 794853 759759 442057 478611 558288 466312 405847 428580 460672 447022 188335 609083 113322 403426 471179 808045 382906 182689 441774 459638 660061 597099 508807 562599 394120 391696 382402 400855 827329 819411 824961 826287 650969 706232 680297 585434 643689 794873 795947 797521 735944 755601 765476 771477 794855 795927 796679 739935 761072 795921 795951 795974 798773 828036 828200 828334 422193 391989 769491 440781 441063 421883 398932 381757 441785 392489 433353 336058 382130 824747 817961 584056 547032 665289 666121 666094 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.37%) |
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 113322 182689 188335 223010 336058 381757 381941 382130 382402 382906 383237 385933 391696 391989 392489 394120 396353 398229 398615 398932 400855 401003 403426 405146 405446 405847 413335 421883 422193 428580 433353 440781 441063 441774 441782 441785 442057 447022 448670 453091 459638 460672 466312 468357 471179 474498 478611 488947 490707 508807 517696 547032 557612 558288 561992 562599 584056 585434 597099 609083 643689 650969 660061 664318 665100 665289 666094 666121 666778 667597 680297 706232 712622 713422 713426 713429 713448 724489 724592 725620 726650 730109 733169 735944 736472 739935 740238 755601 759759 761072 765476 769491 770125 771477 782001 794853 794855 794867 794872 794873 795921 795927 795947 795951 795974 796679 797521 798773 807033 808045 817961 819411 824747 824961 826287 827329 828036 828200 828201 828334 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother chubby"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин chubby"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин chubby"
]
|
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.