Query Metrics
7
Database Queries
7
Different statements
359.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.62 ms (58.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"косичк пов"
]
|
||||||||||||||||||||||||||||||
|
123.84 ms (34.44%) |
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 448266 455409 458454 460104 460509 475516 479948 483437 486939 488396 490489 490584 495987 496059 496243 496923 500043 500044 506072 506735 515762 516783 521597 521834 521851 522009 522764 523987 524230 528225 532569 535280 539524 542076 542919 545182 546592 547080 549079 549100 549108 551562 552687 554333 555346 555378 555767 555774 556315 556784 557772 559387 560961 561464 561602 561627 562211 565784 565884 566126 567097 567108 567250 567701 569058 569547 569552 571106 574717 577944 579001 579485 579573 581611 583207 584052 584858 585248 585257 585766 588516 588726 588791 591513 591921 592141 592152 593248 593249 593405 594824 595086 598736 598962 599360 602072 602686 605561 605966 615895 618185 619333 626080 627626 633215 647146 648939 652773 655268 664399 677003 682922 685754 686593 697414 713911 717851 718958 822011 825949 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (4.72%) |
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 822011 825949 479948 488396 490584 455409 458454 460104 448266 475516 486939 490489 495987 500044 516783 523987 539524 496923 515762 524230 528225 500043 506735 521597 521851 522764 535280 496059 496243 506072 521834 522009 532569 460509 483437 552687 555378 555767 562211 565784 567108 579485 579573 581611 584052 584858 542076 542919 545182 547080 551562 555346 556315 567250 571106 574717 549079 549100 549108 554333 556784 561464 561627 565884 567701 569547 569552 682922 686593 713911 717851 652773 664399 677003 685754 697414 718958 647146 648939 655268 546592 555774 557772 559387 560961 561602 566126 567097 569058 577944 579001 583207 585248 585257 585766 592141 592152 593249 598736 605966 618185 619333 626080 627626 588516 588791 591513 591921 593405 594824 598962 599360 588726 593248 595086 602072 602686 605561 615895 633215 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pigtails pov"
]
|
||||||||||||||||||||||||||||||
|
2.54 ms (0.71%) |
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 448266 455409 458454 460104 460509 475516 479948 483437 486939 488396 490489 490584 495987 496059 496243 496923 500043 500044 506072 506735 515762 516783 521597 521834 521851 522009 522764 523987 524230 528225 532569 535280 539524 542076 542919 545182 546592 547080 549079 549100 549108 551562 552687 554333 555346 555378 555767 555774 556315 556784 557772 559387 560961 561464 561602 561627 562211 565784 565884 566126 567097 567108 567250 567701 569058 569547 569552 571106 574717 577944 579001 579485 579573 581611 583207 584052 584858 585248 585257 585766 588516 588726 588791 591513 591921 592141 592152 593248 593249 593405 594824 595086 598736 598962 599360 602072 602686 605561 605966 615895 618185 619333 626080 627626 633215 647146 648939 652773 655268 664399 677003 682922 685754 686593 697414 713911 717851 718958 822011 825949 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"косичк пов"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.53%) |
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.