Query Metrics
7
Database Queries
7
Different statements
179.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.76 ms (84.15%) |
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 34353 95673 145163 181284 385034 386751 388770 391986 396044 400157 403690 410748 414374 415857 420178 421827 423929 424446 425924 426078 428852 432583 439523 440767 440896 441824 444321 446017 448951 450286 452602 455496 457541 457701 458083 463858 466049 466209 466256 466271 469386 469396 476379 478041 478530 482761 482773 484008 493781 497699 498243 498448 499318 499383 500546 503377 508336 513431 516481 519230 521130 522868 532117 541398 547506 565625 576685 583182 593985 602293 606283 616856 618094 634661 638543 644688 664649 682296 686185 691626 695103 707605 714117 716858 718996 721721 725197 725440 725456 726966 729287 729923 734960 737554 758904 759980 765306 766592 769503 770501 786527 793573 795909 797191 801261 802157 811510 812054 815081 815542 815931 816535 816545 818528 819241 820327 820345 822930 823471 824500 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (9.83%) |
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 145163 428852 414374 396044 425924 441824 458083 500546 682296 714117 593985 616856 602293 797191 766592 729287 403690 457701 498448 497699 770501 466256 466209 466049 521130 386751 482761 415857 522868 181284 421827 618094 519230 493781 686185 452602 34353 691626 95673 444321 469396 469386 457541 440896 391986 499383 583182 664649 503377 820327 478041 716858 565625 725197 759980 802157 718996 385034 482773 476379 423929 388770 420178 455496 466271 448951 541398 424446 400157 815931 818528 823471 816545 815542 820345 822930 824500 816535 547506 695103 606283 638543 786527 729923 765306 801261 811510 812054 737554 726966 734960 815081 644688 634661 410748 498243 576685 450286 440767 446017 484008 532117 707605 793573 758904 795909 725456 769503 725440 721721 432583 426078 508336 819241 478530 439523 463858 513431 516481 499318 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.78%) |
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 34353 95673 145163 181284 385034 386751 388770 391986 396044 400157 403690 410748 414374 415857 420178 421827 423929 424446 425924 426078 428852 432583 439523 440767 440896 441824 444321 446017 448951 450286 452602 455496 457541 457701 458083 463858 466049 466209 466256 466271 469386 469396 476379 478041 478530 482761 482773 484008 493781 497699 498243 498448 499318 499383 500546 503377 508336 513431 516481 519230 521130 522868 532117 541398 547506 565625 576685 583182 593985 602293 606283 616856 618094 634661 638543 644688 664649 682296 686185 691626 695103 707605 714117 716858 718996 721721 725197 725440 725456 726966 729287 729923 734960 737554 758904 759980 765306 766592 769503 770501 786527 793573 795909 797191 801261 802157 811510 812054 815081 815542 815931 816535 816545 818528 819241 820327 820345 822930 823471 824500 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother mother panties"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин мам женщин трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.