Query Metrics
7
Database Queries
7
Different statements
216.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.93 ms (88.37%) |
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 405988 416607 416691 418127 418149 418259 419646 423706 435171 435553 437874 437929 441041 441050 441071 441106 441952 442548 443914 449956 450437 451157 452572 457797 461309 467905 469794 469826 470883 473410 474806 474891 478986 479008 490692 493083 496787 500943 502877 508154 515452 518962 521108 523866 525744 527194 528429 533272 537640 537757 540915 544066 549554 552577 556900 558949 561979 577664 581050 581949 584812 586965 588538 589390 591446 595612 600539 602136 622509 624837 626378 632095 642390 643005 645479 664166 666432 669324 680592 680928 693772 693815 693816 703212 714086 715790 724498 729567 737759 739923 745900 747444 755198 757512 758706 760583 761150 768157 768659 771171 791516 793187 795231 795398 796336 796650 796675 799957 801068 806931 806952 810059 811507 811797 811808 812372 812495 813822 814491 817875 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (6.45%) |
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 760583 745900 474806 435553 457797 443914 451157 747444 724498 811797 622509 442548 814491 500943 581050 544066 552577 664166 666432 561979 626378 589390 796650 811507 812495 755198 757512 761150 796675 473410 461309 418259 478986 418127 523866 493083 502877 693815 600539 441106 558949 642390 591446 729567 796336 418149 452572 643005 441041 602136 595612 806931 470883 533272 693816 703212 715790 537757 680592 586965 799957 441071 515452 416691 588538 817875 479008 540915 584812 680928 528429 581949 549554 693772 419646 441952 450437 525744 496787 669324 806952 810059 737759 791516 739923 758706 768157 768659 771171 801068 474891 632095 437874 441050 813822 793187 537640 518962 645479 423706 556900 795398 467905 405988 437929 416607 508154 811808 435171 449956 469794 469826 490692 521108 527194 577664 714086 624837 795231 812372 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (1.83%) |
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 405988 416607 416691 418127 418149 418259 419646 423706 435171 435553 437874 437929 441041 441050 441071 441106 441952 442548 443914 449956 450437 451157 452572 457797 461309 467905 469794 469826 470883 473410 474806 474891 478986 479008 490692 493083 496787 500943 502877 508154 515452 518962 521108 523866 525744 527194 528429 533272 537640 537757 540915 544066 549554 552577 556900 558949 561979 577664 581050 581949 584812 586965 588538 589390 591446 595612 600539 602136 622509 624837 626378 632095 642390 643005 645479 664166 666432 669324 680592 680928 693772 693815 693816 703212 714086 715790 724498 729567 737759 739923 745900 747444 755198 757512 758706 760583 761150 768157 768659 771171 791516 793187 795231 795398 796336 796650 796675 799957 801068 806931 806952 810059 811507 811797 811808 812372 812495 813822 814491 817875 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur girls squirting"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск девушк squirting"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск девушк squirting"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.