Query Metrics
7
Database Queries
7
Different statements
193.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.76 ms (89.15%) |
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 223663 401537 402551 405951 407782 409331 411572 428111 429788 446537 447411 453699 453724 458602 458610 462058 462061 464690 465252 465499 466499 467323 468044 473823 480072 482420 485854 486005 486562 492432 494215 494591 495021 495950 496709 503235 503989 503991 505298 506428 508775 509936 511018 511319 511328 511443 514057 519979 523156 524889 525806 526589 528340 528603 528760 528761 528762 539342 541339 543594 546574 547575 551114 551562 556868 557735 559290 560526 563953 564757 573362 573367 580302 580347 583288 585317 587619 588715 589595 590977 600879 603513 605653 611894 612846 619024 621152 624421 624429 626328 627126 628192 630411 635719 640469 671462 675607 678793 690050 691046 700013 702017 705024 705031 705352 705870 710928 716726 725533 743426 743548 752891 788437 788755 789190 790960 792728 808304 808309 809562 ] |
||||||||||||||||||||||||||||||
|
12.41 ms (6.41%) |
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 458610 605653 458602 560526 468044 557735 809562 624421 702017 411572 223663 511443 624429 603513 503235 409331 467323 563953 453699 447411 503991 528762 626328 495021 752891 539342 509936 551114 528340 621152 541339 589595 429788 524889 611894 405951 523156 466499 543594 600879 407782 640469 453724 495950 551562 710928 462058 465499 464690 546574 564757 587619 494591 705870 691046 480072 808304 585317 492432 690050 573362 619024 511018 505298 519979 678793 514057 525806 528603 580347 547575 725533 473823 494215 402551 612846 446537 580302 590977 486562 506428 485854 705024 716726 588715 808309 788437 705031 788755 743548 528760 428111 503989 496709 528761 511328 573367 790960 792728 743426 508775 559290 630411 482420 675607 671462 628192 635719 401537 700013 705352 789190 627126 465252 526589 511319 486005 462061 556868 583288 ] |
||||||||||||||||||||||||||||||
|
2.64 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 223663 401537 402551 405951 407782 409331 411572 428111 429788 446537 447411 453699 453724 458602 458610 462058 462061 464690 465252 465499 466499 467323 468044 473823 480072 482420 485854 486005 486562 492432 494215 494591 495021 495950 496709 503235 503989 503991 505298 506428 508775 509936 511018 511319 511328 511443 514057 519979 523156 524889 525806 526589 528340 528603 528760 528761 528762 539342 541339 543594 546574 547575 551114 551562 556868 557735 559290 560526 563953 564757 573362 573367 580302 580347 583288 585317 587619 588715 589595 590977 600879 603513 605653 611894 612846 619024 621152 624421 624429 626328 627126 628192 630411 635719 640469 671462 675607 678793 690050 691046 700013 702017 705024 705031 705352 705870 710928 716726 725533 743426 743548 752891 788437 788755 789190 790960 792728 808304 808309 809562 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"беременую ебут"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беремен секс"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.