Query Metrics
7
Database Queries
7
Different statements
164.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.02 ms (82.93%) |
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 384795 398966 419128 421880 421954 424210 428695 432741 433291 433350 435599 439454 439641 439676 440339 441228 441511 443896 444709 450130 450154 451713 452531 453111 454152 454171 454556 454812 456603 457449 457683 458965 459778 460277 460305 463852 464132 464484 464884 464997 467671 467936 468337 468339 469420 470502 474277 475489 477307 477904 479821 480423 481618 485646 486046 488441 489316 493735 496979 499329 499338 500230 505345 505726 516226 517325 519766 523760 526525 534633 535662 536956 536980 545077 545179 557240 563041 565645 566763 570876 580628 585457 586376 590473 592907 599770 604306 606077 613837 615511 618856 664150 680328 730342 735005 747054 752011 756289 759369 764151 765400 766777 766779 767163 767189 767272 770263 784700 788079 794776 794868 803957 804927 813075 813422 813514 813566 814226 816687 817258 ] |
||||||||||||||||||||||||||||||
|
17.69 ms (10.79%) |
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 433291 440339 457449 464484 433350 456603 464132 526525 457683 516226 590473 424210 464997 421880 421954 454812 460277 419128 435599 452531 454556 470502 505345 496979 517325 443896 813566 454152 486046 463852 480423 468337 489316 499329 519766 534633 536956 535662 499338 460305 566763 580628 545179 557240 664150 680328 545077 565645 585457 586376 606077 613837 592907 615511 599770 604306 794776 794868 813075 813422 764151 767189 767272 784700 813514 759369 765400 767163 735005 766777 730342 756289 766779 788079 803957 477904 500230 488441 618856 439641 439676 770263 481618 467936 505726 570876 563041 804927 384795 398966 467671 475489 523760 464884 428695 536980 752011 747054 441228 444709 439454 441511 432741 814226 816687 817258 450154 454171 469420 474277 477307 493735 451713 459778 468339 479821 485646 450130 453111 458965 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.81%) |
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 384795 398966 419128 421880 421954 424210 428695 432741 433291 433350 435599 439454 439641 439676 440339 441228 441511 443896 444709 450130 450154 451713 452531 453111 454152 454171 454556 454812 456603 457449 457683 458965 459778 460277 460305 463852 464132 464484 464884 464997 467671 467936 468337 468339 469420 470502 474277 475489 477307 477904 479821 480423 481618 485646 486046 488441 489316 493735 496979 499329 499338 500230 505345 505726 516226 517325 519766 523760 526525 534633 535662 536956 536980 545077 545179 557240 563041 565645 566763 570876 580628 585457 586376 590473 592907 599770 604306 606077 613837 615511 618856 664150 680328 730342 735005 747054 752011 756289 759369 764151 765400 766777 766779 767163 767189 767272 770263 784700 788079 794776 794868 803957 804927 813075 813422 813514 813566 814226 816687 817258 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature doggy pov"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature рак пов"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature рак пов"
]
|
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.