Query Metrics
7
Database Queries
7
Different statements
155.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.35 ms (86.03%) |
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 21500 33459 151018 188122 188556 337012 382134 384419 388474 391744 391930 396728 397263 401101 408238 418864 428706 443389 443773 446275 447671 452384 452625 453342 454350 455085 460535 461767 463825 464118 464372 465061 465354 466801 467109 467960 468154 469187 470202 472484 473450 474894 476195 476224 477069 477118 478517 478575 479071 480296 481047 482559 485100 485152 486260 487632 490783 491837 493488 493740 496729 499899 500339 500938 502108 510132 511572 511895 519215 521210 521596 522140 522348 525376 527434 532876 533331 533966 535878 542572 544510 560122 569003 576916 581995 583190 592377 592489 593571 615014 629658 631683 632668 636540 678813 681313 698981 719300 720206 724614 727573 728440 731565 749245 758097 758122 766692 782407 786454 801259 801306 802064 802157 805355 808527 809477 813085 814991 817242 817268 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (8.09%) |
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 473450 560122 801306 472484 486260 720206 382134 522140 468154 487632 428706 481047 446275 453342 615014 817242 21500 418864 467109 533331 464118 447671 510132 525376 188122 813085 749245 758122 391930 583190 533966 188556 519215 678813 477069 581995 542572 629658 786454 728440 632668 636540 522348 576916 592489 485100 466801 631683 465061 391744 477118 511572 719300 527434 337012 469187 499899 479071 461767 500938 151018 502108 454350 491837 801259 802157 817268 474894 396728 493740 535878 724614 758097 782407 681313 592377 809477 698981 460535 388474 455085 521596 485152 511895 593571 805355 476195 397263 452384 465354 470202 452625 521210 727573 766692 490783 476224 480296 532876 808527 463825 478575 482559 478517 802064 731565 443389 464372 443773 467960 384419 408238 493488 544510 401101 500339 496729 33459 814991 569003 ] |
||||||||||||||||||||||||||||||
|
2.81 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 21500 33459 151018 188122 188556 337012 382134 384419 388474 391744 391930 396728 397263 401101 408238 418864 428706 443389 443773 446275 447671 452384 452625 453342 454350 455085 460535 461767 463825 464118 464372 465061 465354 466801 467109 467960 468154 469187 470202 472484 473450 474894 476195 476224 477069 477118 478517 478575 479071 480296 481047 482559 485100 485152 486260 487632 490783 491837 493488 493740 496729 499899 500339 500938 502108 510132 511572 511895 519215 521210 521596 522140 522348 525376 527434 532876 533331 533966 535878 542572 544510 560122 569003 576916 581995 583190 592377 592489 593571 615014 629658 631683 632668 636540 678813 681313 698981 719300 720206 724614 727573 728440 731565 749245 758097 758122 766692 782407 786454 801259 801306 802064 802157 805355 808527 809477 813085 814991 817242 817268 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mature compilation"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mature подборк"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.88%) |
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.