Query Metrics
7
Database Queries
7
Different statements
355.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.79 ms (58.48%) |
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 492339 496059 498102 509473 509633 513920 523075 523275 525004 533639 535457 542477 543559 544200 544291 544619 545108 545168 548815 549505 550197 550419 550653 551078 553238 553242 553700 555418 555758 557159 557519 558921 559558 559819 561597 561627 563319 564611 565144 565180 565900 566065 566501 568614 569155 569550 571408 571461 572286 572446 573217 573638 573911 574694 575375 577485 579403 579573 579877 580501 581041 581992 583742 583871 584052 584275 584696 585684 589360 590852 590958 591654 591960 592354 595083 598343 599352 602634 602919 617877 618795 620323 620812 628459 638000 644004 645781 646186 648976 651142 651214 651824 652773 652805 653212 653333 653486 655405 656304 657764 659270 661259 661879 663454 663501 664286 664813 665193 667736 669640 670041 670952 671800 672283 675280 686862 687440 689603 690616 690846 ] |
||||||||||||||||||||||||||||||
|
125.59 ms (35.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 492339 496059 498102 509473 509633 513920 523075 523275 525004 533639 535457 542477 543559 544200 544291 544619 545108 545168 548815 549505 550197 550419 550653 551078 553238 553242 553700 555418 555758 557159 557519 558921 559558 559819 561597 561627 563319 564611 565144 565180 565900 566065 566501 568614 569155 569550 571408 571461 572286 572446 573217 573638 573911 574694 575375 577485 579403 579573 579877 580501 581041 581992 583742 583871 584052 584275 584696 585684 589360 590852 590958 591654 591960 592354 595083 598343 599352 602634 602919 617877 618795 620323 620812 628459 638000 644004 645781 646186 648976 651142 651214 651824 652773 652805 653212 653333 653486 655405 656304 657764 659270 661259 661879 663454 663501 664286 664813 665193 667736 669640 670041 670952 671800 672283 675280 686862 687440 689603 690616 690846 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (4.06%) |
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 590852 591960 595083 602634 618795 644004 585684 589360 591654 599352 602919 617877 620812 638000 667736 592354 598343 566065 569155 573911 575375 670041 653486 663454 690846 590958 628459 498102 620323 492339 509633 523075 523275 525004 533639 509473 496059 513920 535457 544291 544619 550197 550419 553700 559819 566501 568614 571408 572286 573217 574694 579403 579573 579877 580501 581041 583742 583871 584052 543559 544200 549505 550653 555418 555758 565144 565900 569550 572446 577485 584275 584696 542477 548815 553238 557159 559558 561597 561627 563319 571461 573638 581992 651142 651824 653212 653333 661879 664286 669640 672283 675280 689603 648976 652773 656304 657764 661259 663501 664813 670952 690616 645781 646186 651214 652805 655405 659270 665193 671800 686862 687440 545108 545168 551078 553242 557519 558921 564611 565180 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочка головки члена"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк головк член"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк головк член"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.45%) |
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.