Query Metrics
7
Database Queries
7
Different statements
387.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.97 ms (55.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск большие boobs"
]
|
||||||||||||||||||||||||||||||
|
152.49 ms (39.33%) |
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 405832 459483 465620 502716 504334 511683 511941 515860 529868 530614 533180 533190 533291 533766 537506 537650 543173 543585 546500 547008 547022 547038 547133 548040 548308 548473 550543 555521 556564 558157 560343 561557 567114 567121 568173 572929 575922 577528 577814 582746 583611 588371 593271 598000 603676 612276 616016 616646 617654 617999 627354 629226 629340 629956 631134 631766 634041 634674 634684 634732 635826 639139 642945 643283 643980 644174 648766 651799 651815 652525 653339 656246 664768 667752 668270 668563 669680 675263 675849 679895 682332 683426 683476 687373 692008 692084 697149 699654 700235 701026 705208 707561 710538 710912 712120 714865 719447 722959 723082 728551 733046 736008 748465 748605 757724 757925 761956 768066 772151 774994 778580 790831 793618 798770 798846 811271 818761 824086 825837 ] |
||||||||||||||||||||||||||||||
|
11.44 ms (2.95%) |
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 639139 612276 798952 504334 748465 533291 511683 465620 572929 543173 577814 675263 598000 757724 772151 405832 567114 558157 712120 748605 736008 761956 722959 723082 818761 824086 793618 537650 533766 537506 529868 530614 548473 556564 567121 568173 547038 547133 548308 561557 577528 583611 543585 546500 550543 648766 656246 664768 668270 675849 683476 701026 710538 668563 679895 683426 692084 697149 705208 651799 651815 652525 653339 682332 687373 699654 719447 548040 575922 582746 631134 631766 588371 603676 616016 627354 634041 634674 643980 644174 616646 634684 635826 642945 617654 733046 617999 629956 634732 707561 710912 790831 511941 560343 774994 798846 533180 547008 547022 700235 629226 643283 593271 825837 533190 728551 714865 778580 502716 667752 669680 692008 629340 757925 459483 515860 555521 798770 811271 768066 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (0.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 405832 459483 465620 502716 504334 511683 511941 515860 529868 530614 533180 533190 533291 533766 537506 537650 543173 543585 546500 547008 547022 547038 547133 548040 548308 548473 550543 555521 556564 558157 560343 561557 567114 567121 568173 572929 575922 577528 577814 582746 583611 588371 593271 598000 603676 612276 616016 616646 617654 617999 627354 629226 629340 629956 631134 631766 634041 634674 634684 634732 635826 639139 642945 643283 643980 644174 648766 651799 651815 652525 653339 656246 664768 667752 668270 668563 669680 675263 675849 679895 682332 683426 683476 687373 692008 692084 697149 699654 700235 701026 705208 707561 710538 710912 712120 714865 719447 722959 723082 728551 733046 736008 748465 748605 757724 757925 761956 768066 772151 774994 778580 790831 793618 798770 798846 811271 818761 824086 825837 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск большие boobs"
]
|
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.