Query Metrics
7
Database Queries
7
Different statements
175.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.06 ms (83.34%) |
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 95742 118098 184359 388755 398567 398634 400943 400962 401764 405421 406304 413505 413826 416772 417250 421580 422166 425910 428334 428397 429342 430561 431448 432674 432823 433137 433166 433212 433227 433297 441994 443249 443323 445869 445941 445974 446991 447022 447471 448816 448820 452329 461848 463798 463840 467958 469852 470385 475698 482291 486515 486868 487750 489489 493334 495218 511357 516383 516842 517374 518290 523544 526300 527091 534567 534682 537198 541650 543872 549027 555023 555133 556535 557072 558875 560902 562964 564337 565504 568287 569179 571216 575890 580340 586623 593487 596991 597501 597876 598675 598723 600016 603436 609097 617421 627803 630245 630678 636998 639722 640772 643109 645004 647349 668377 688617 699624 699697 702866 741539 746995 748349 775801 788570 788780 788794 815002 818235 819506 820775 ] |
||||||||||||||||||||||||||||||
|
18.55 ms (10.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 447471 422166 405421 430561 448816 495218 586623 443249 417250 428334 815002 818235 645004 820775 819506 526300 568287 647349 668377 598675 630678 596991 600016 775801 788780 788794 748349 741539 746995 603436 627803 702866 788570 400943 445941 475698 517374 433166 433297 487750 448820 482291 534567 516383 558875 549027 543872 555023 569179 598723 609097 630245 643109 636998 425910 433137 421580 617421 541650 537198 95742 431448 428397 398567 441994 467958 493334 184359 597876 593487 688617 597501 406304 432674 445869 463798 463840 486515 527091 518290 564337 560902 557072 571216 699697 555133 562964 413505 461848 432823 446991 452329 534682 400962 429342 443323 433227 486868 413826 388755 447022 699624 469852 523544 639722 489489 401764 511357 556535 565504 118098 516842 470385 445974 580340 433212 575890 640772 398634 416772 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.51%) |
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 95742 118098 184359 388755 398567 398634 400943 400962 401764 405421 406304 413505 413826 416772 417250 421580 422166 425910 428334 428397 429342 430561 431448 432674 432823 433137 433166 433212 433227 433297 441994 443249 443323 445869 445941 445974 446991 447022 447471 448816 448820 452329 461848 463798 463840 467958 469852 470385 475698 482291 486515 486868 487750 489489 493334 495218 511357 516383 516842 517374 518290 523544 526300 527091 534567 534682 537198 541650 543872 549027 555023 555133 556535 557072 558875 560902 562964 564337 565504 568287 569179 571216 575890 580340 586623 593487 596991 597501 597876 598675 598723 600016 603436 609097 617421 627803 630245 630678 636998 639722 640772 643109 645004 647349 668377 688617 699624 699697 702866 741539 746995 748349 775801 788570 788780 788794 815002 818235 819506 820775 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин анал дырк"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин анал дырк"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мужчины анальная дыра…"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.