Query Metrics
7
Database Queries
7
Different statements
180.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.55 ms (85.65%) |
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 423499 427093 427913 428035 434276 435972 439587 439663 443158 443812 450195 450219 453082 453557 453558 453563 453569 459698 461580 465024 470657 471313 475181 481242 488978 489410 489963 492320 493475 494277 499783 501960 503322 506820 509824 509993 510692 511938 512533 513491 513873 516320 518596 518965 520542 520717 520843 520877 520940 521505 522284 522976 523226 523764 524083 526499 527128 528272 535369 538854 543614 546641 549500 552855 558266 559795 561345 561380 562938 569303 569389 574476 575467 579501 581216 581805 582317 582693 582708 582712 585101 586339 586676 586677 587854 589023 589917 591203 595711 599551 600833 601333 604960 605470 605833 606757 611301 613853 616205 617175 620341 620739 622462 623434 623472 623642 626024 627380 628324 632794 638115 639277 640888 648634 691720 693955 723352 726707 780085 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (8.54%) |
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 601333 599551 726707 611301 523226 509993 620341 435972 511938 510692 640888 428035 524083 475181 546641 453563 493475 513873 558266 461580 691720 606757 623642 780085 471313 453569 509824 501960 521505 488978 613853 427093 513476 513491 522284 523764 450219 520940 605833 520843 481242 528272 423499 526499 520877 561345 582317 582708 552855 562938 581805 586676 639277 723352 518965 587854 569303 527128 499783 589917 459698 574476 575467 586677 693955 453557 503322 434276 470657 489963 582712 586339 595711 620739 453558 623434 506820 559795 453082 450195 648634 638115 623472 443812 600833 439663 439587 518596 465024 443158 543614 549500 516320 494277 561380 622462 512533 579501 582693 632794 627380 617175 427913 489410 626024 585101 538854 520542 522976 581216 604960 628324 492320 520717 591203 616205 569389 605470 535369 589023 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.77%) |
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 423499 427093 427913 428035 434276 435972 439587 439663 443158 443812 450195 450219 453082 453557 453558 453563 453569 459698 461580 465024 470657 471313 475181 481242 488978 489410 489963 492320 493475 494277 499783 501960 503322 506820 509824 509993 510692 511938 512533 513491 513873 516320 518596 518965 520542 520717 520843 520877 520940 521505 522284 522976 523226 523764 524083 526499 527128 528272 535369 538854 543614 546641 549500 552855 558266 559795 561345 561380 562938 569303 569389 574476 575467 579501 581216 581805 582317 582693 582708 582712 585101 586339 586676 586677 587854 589023 589917 591203 595711 599551 600833 601333 604960 605470 605833 606757 611301 613853 616205 617175 620341 620739 622462 623434 623472 623642 626024 627380 628324 632794 638115 639277 640888 648634 691720 693955 723352 726707 780085 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife new dick"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен new член"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен new член"
]
|
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.