Query Metrics
7
Database Queries
7
Different statements
171.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.04 ms (83.20%) |
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 390573 396360 402458 417095 417512 419096 423435 425340 425861 426176 428610 434946 435236 436530 441697 441760 455947 456322 463083 463369 463416 474968 487862 488224 489050 490139 498550 500538 501543 502195 502411 507287 509709 510183 510907 511328 514284 517028 517167 519865 520437 520820 521041 521170 523242 523279 525448 525898 528118 528125 529113 542087 547584 552953 552964 555377 556392 557666 561506 567330 567985 571126 572235 573411 575157 576003 576543 576942 576959 577572 577696 578790 580895 581861 581896 582077 583470 584112 584431 584438 584567 586691 587369 588258 589469 589653 589684 590929 591726 591928 592544 593689 595358 596479 596694 598227 604314 605200 610401 615613 615919 619171 622366 628478 630292 632102 632143 635364 640152 649384 654463 664241 670821 672240 700470 712094 728229 749150 750171 784157 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (10.70%) |
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 520820 520437 529113 489050 547584 555377 575157 576003 581896 584431 542087 571126 576543 576942 581861 582077 572235 577572 577696 649384 700470 672240 552964 556392 567330 580895 583470 584112 584567 589653 598227 604314 605200 635364 587369 590929 591726 596479 610401 619171 588258 589469 596694 615919 628478 630292 592544 595358 632143 784157 728229 749150 750171 622366 632102 441760 455947 417512 426176 390573 419096 423435 463369 474968 498550 502411 521170 501543 525448 514284 593689 441697 396360 402458 428610 434946 425861 435236 417095 425340 436530 456322 463416 487862 488224 463083 490139 500538 502195 507287 510907 523279 511328 519865 523242 525898 509709 510183 517028 517167 521041 528118 528125 561506 567985 576959 552953 584438 578790 664241 670821 712094 654463 557666 573411 640152 586691 589684 591928 615613 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.90%) |
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 390573 396360 402458 417095 417512 419096 423435 425340 425861 426176 428610 434946 435236 436530 441697 441760 455947 456322 463083 463369 463416 474968 487862 488224 489050 490139 498550 500538 501543 502195 502411 507287 509709 510183 510907 511328 514284 517028 517167 519865 520437 520820 521041 521170 523242 523279 525448 525898 528118 528125 529113 542087 547584 552953 552964 555377 556392 557666 561506 567330 567985 571126 572235 573411 575157 576003 576543 576942 576959 577572 577696 578790 580895 581861 581896 582077 583470 584112 584431 584438 584567 586691 587369 588258 589469 589653 589684 590929 591726 591928 592544 593689 595358 596479 596694 598227 604314 605200 610401 615613 615919 619171 622366 628478 630292 632102 632143 635364 640152 649384 654463 664241 670821 672240 700470 712094 728229 749150 750171 784157 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding creampie"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз creampie"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз creampie"
]
|
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.