Query Metrics
7
Database Queries
7
Different statements
181.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.98 ms (87.95%) |
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 385216 393862 404395 415203 431673 438769 443303 447642 451015 456660 468756 469675 471860 475714 478462 478548 479590 482073 482538 485197 489544 490694 501892 504303 505905 508142 509036 510464 510510 513724 514718 515803 517195 521877 522591 523264 523276 523660 524526 528389 528808 528809 533065 534178 538214 540305 548645 552162 552574 557057 557160 560432 560639 563573 565558 570347 571549 573048 581330 586215 586603 588279 592487 598369 603727 608938 615460 619478 622483 653156 654517 654583 654584 654720 654759 655732 656737 656770 657416 657448 657594 657641 658605 659594 659619 659691 659795 660517 660540 660959 663863 663917 663986 667569 667576 671143 675768 679694 699668 721277 735798 738221 742953 750222 755086 755617 811886 815106 816523 816697 817762 821526 823342 824359 825142 825681 825792 ] |
||||||||||||||||||||||||||||||
|
12.50 ms (6.87%) |
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 482538 451015 508142 522591 517195 514718 533065 515803 560432 565558 552574 619478 586215 586603 404395 443303 447642 456660 469675 475714 478462 393862 431673 415203 468756 471860 478548 479590 438769 482073 501892 505905 524526 528809 510464 513724 523264 523276 534178 489544 504303 528389 485197 490694 509036 521877 523660 528808 538214 608938 548645 603727 824207 821981 824359 825681 557160 581330 654584 654720 660540 654517 655732 659619 699668 656770 657416 657448 658605 671143 675768 571549 592487 755086 755617 385216 821526 825142 822348 825792 816523 510510 557057 573048 570347 654759 659691 667569 663986 656737 663917 598369 750222 816697 823342 815106 660959 663863 667576 653156 654583 659795 660517 679694 657594 657641 659594 615460 588279 622483 811886 735798 738221 742953 721277 817762 540305 552162 560639 563573 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.67%) |
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 385216 393862 404395 415203 431673 438769 443303 447642 451015 456660 468756 469675 471860 475714 478462 478548 479590 482073 482538 485197 489544 490694 501892 504303 505905 508142 509036 510464 510510 513724 514718 515803 517195 521877 522591 523264 523276 523660 524526 528389 528808 528809 533065 534178 538214 540305 548645 552162 552574 557057 557160 560432 560639 563573 565558 570347 571549 573048 581330 586215 586603 588279 592487 598369 603727 608938 615460 619478 622483 653156 654517 654583 654584 654720 654759 655732 656737 656770 657416 657448 657594 657641 658605 659594 659619 659691 659795 660517 660540 660959 663863 663917 663986 667569 667576 671143 675768 679694 699668 721277 735798 738221 742953 750222 755086 755617 811886 815106 816523 816697 817762 821526 823342 824359 825142 825681 825792 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock skinny"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock худые"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock худые"
]
|
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.