Query Metrics
7
Database Queries
7
Different statements
398.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.49 ms (53.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature соло трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
163.01 ms (40.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 386412 398954 407438 429737 435592 442941 446386 452936 456230 457666 460237 467067 467900 470470 471077 473427 490380 490384 494207 499391 503836 509767 511039 513637 517807 522102 523371 527180 529370 529838 530402 530566 532460 532691 533632 541078 542215 543945 544108 544980 550597 555503 558097 558103 559359 561524 561805 576479 578693 580976 585050 587877 590831 592999 595092 596961 597663 599641 603768 604941 605096 605480 606060 607573 609164 610062 614848 618507 619385 620648 623936 629281 637489 642313 655298 660054 660415 672808 680937 680968 714706 721895 726794 731787 738068 740589 744200 746628 746687 749087 750412 751640 754583 760211 770108 770241 781875 784221 787358 792540 793508 794219 796819 796831 797144 798743 799630 801620 803034 805362 807424 807567 808029 809542 811813 812549 812557 814184 818532 819964 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (3.73%) |
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 523371 530402 544108 559359 576479 660415 618507 801620 750412 629281 503836 456230 511039 721895 620648 796831 660054 527180 605480 798743 457666 544980 558097 578693 543945 558103 561805 580976 680937 550597 599641 606060 796819 442941 494207 509767 513637 467067 542215 655298 623936 596961 809542 751640 740589 744200 770241 792540 398954 452936 473427 605096 490380 619385 609164 517807 819964 814184 530566 529838 532691 522102 460237 561524 555503 672808 714706 680968 592999 597663 607573 637489 590831 595092 614848 642313 803034 807424 807567 805362 808029 787358 811813 812549 812557 731787 746628 746687 754583 770108 726794 738068 610062 793508 794219 799630 471077 603768 604941 467900 407438 532460 797144 585050 587877 784221 429737 490384 529370 446386 749087 386412 435592 760211 781875 533632 470470 541078 499391 818532 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (0.70%) |
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 386412 398954 407438 429737 435592 442941 446386 452936 456230 457666 460237 467067 467900 470470 471077 473427 490380 490384 494207 499391 503836 509767 511039 513637 517807 522102 523371 527180 529370 529838 530402 530566 532460 532691 533632 541078 542215 543945 544108 544980 550597 555503 558097 558103 559359 561524 561805 576479 578693 580976 585050 587877 590831 592999 595092 596961 597663 599641 603768 604941 605096 605480 606060 607573 609164 610062 614848 618507 619385 620648 623936 629281 637489 642313 655298 660054 660415 672808 680937 680968 714706 721895 726794 731787 738068 740589 744200 746628 746687 749087 750412 751640 754583 760211 770108 770241 781875 784221 787358 792540 793508 794219 796819 796831 797144 798743 799630 801620 803034 805362 807424 807567 808029 809542 811813 812549 812557 814184 818532 819964 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature solo panties"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.41%) |
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.