Query Metrics
7
Database Queries
7
Different statements
151.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.60 ms (83.72%) |
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 202846 381987 382066 382503 387696 390022 398529 405816 439520 452925 453266 454684 455500 457631 458549 466035 466926 469113 469416 471174 474159 474206 475278 475639 478806 487751 490744 499587 500905 511314 513632 513663 513670 513681 516005 516006 519384 528339 531047 531373 531546 537548 537717 539416 541102 544017 546550 547689 549342 550575 554454 557504 561589 562574 570800 574285 574358 577398 579910 583822 586613 587805 589610 592923 596769 605973 612110 615949 615990 621230 629903 643373 646289 662606 676248 677146 680665 681085 692701 696347 709398 710379 710523 710769 714364 714408 714461 720527 729935 731137 733117 734386 736047 738359 741713 742569 744200 744203 744229 744459 744461 746106 746604 746663 755354 760656 770122 770252 777089 777654 784147 789748 790380 794701 797359 798081 802739 809297 811242 817130 ] |
||||||||||||||||||||||||||||||
|
16.01 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 744229 490744 516005 539416 516006 596769 439520 531047 547689 549342 554454 574285 615990 629903 817130 537548 537717 579910 570800 583822 676248 709398 562574 615949 784147 612110 790380 458549 680665 475639 455500 466035 513663 544017 574358 714461 710523 681085 592923 643373 734386 736047 469113 452925 457631 528339 487751 513681 586613 499587 577398 405816 471174 589610 478806 519384 382503 646289 561589 744200 546550 662606 760656 729935 381987 390022 474159 531546 541102 714408 692701 696347 720527 587805 777654 794701 802739 731137 797359 744459 770122 733117 738359 742569 755354 770252 746106 714364 811242 475278 500905 202846 382066 387696 453266 474206 469416 511314 531373 550575 557504 710769 677146 605973 809297 746663 798081 741713 744461 744203 746604 621230 710379 777089 789748 398529 454684 466926 513670 513632 ] |
||||||||||||||||||||||||||||||
|
2.28 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 202846 381987 382066 382503 387696 390022 398529 405816 439520 452925 453266 454684 455500 457631 458549 466035 466926 469113 469416 471174 474159 474206 475278 475639 478806 487751 490744 499587 500905 511314 513632 513663 513670 513681 516005 516006 519384 528339 531047 531373 531546 537548 537717 539416 541102 544017 546550 547689 549342 550575 554454 557504 561589 562574 570800 574285 574358 577398 579910 583822 586613 587805 589610 592923 596769 605973 612110 615949 615990 621230 629903 643373 646289 662606 676248 677146 680665 681085 692701 696347 709398 710379 710523 710769 714364 714408 714461 720527 729935 731137 733117 734386 736047 738359 741713 742569 744200 744203 744229 744459 744461 746106 746604 746663 755354 760656 770122 770252 777089 777654 784147 789748 790380 794701 797359 798081 802739 809297 811242 817130 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелые женщины эротик…"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин эротик"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.96%) |
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.