Query Metrics
7
Database Queries
7
Different statements
151.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.99 ms (82.62%) |
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 20617 123614 383338 387682 390991 394103 405894 407156 409784 419840 422523 425466 429068 429635 430270 430444 431484 431660 435726 443274 443550 443600 446476 458327 463750 464949 471822 473372 479277 480363 485576 486018 486759 489806 492414 494402 494510 500565 508769 510581 512182 517857 519907 525176 525178 526090 539942 540206 550615 550637 550717 550769 551984 552008 552041 552931 554419 554424 555821 556607 557518 557537 558377 559889 559898 560215 564585 565985 565997 566002 566849 572373 572736 573566 585159 586588 599602 601024 603144 614529 617921 622197 622200 623502 623542 623564 623813 623814 624814 628161 630533 647945 654624 679061 679367 688560 695199 699602 704335 712089 715501 717947 731957 735387 737106 737927 745892 752155 754784 754877 759537 790884 793633 797801 805103 809157 814778 821745 823295 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (10.99%) |
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 623542 793633 805103 745892 754877 754784 704335 715501 20617 473372 737927 383338 405894 431484 435726 446476 525178 525176 539942 500565 551984 552041 554419 550637 556607 558377 550717 552008 557518 566849 573566 628161 585159 603144 586588 601024 622197 623564 623502 123614 463750 394103 422523 471822 429635 430270 494402 489806 557537 458327 519907 623813 486018 550615 419840 814778 480363 647945 654624 695199 624814 623814 797801 731957 486759 407156 443550 443600 517857 485576 508769 823295 540206 512182 552931 559898 679061 679367 688560 712089 717947 559889 565985 622200 614529 599602 627735 737106 759537 735387 699602 560215 630533 430444 809157 821745 479277 555821 790884 425466 387682 429068 492414 464949 494510 526090 565997 566002 550769 564585 554424 572373 572736 617921 752155 390991 431660 443274 409784 510581 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.06%) |
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 20617 123614 383338 387682 390991 394103 405894 407156 409784 419840 422523 425466 429068 429635 430270 430444 431484 431660 435726 443274 443550 443600 446476 458327 463750 464949 471822 473372 479277 480363 485576 486018 486759 489806 492414 494402 494510 500565 508769 510581 512182 517857 519907 525176 525178 526090 539942 540206 550615 550637 550717 550769 551984 552008 552041 552931 554419 554424 555821 556607 557518 557537 558377 559889 559898 560215 564585 565985 565997 566002 566849 572373 572736 573566 585159 586588 599602 601024 603144 614529 617921 622197 622200 623502 623542 623564 623813 623814 624814 628161 630533 647945 654624 679061 679367 688560 695199 699602 704335 712089 715501 717947 731957 735387 737106 737927 745892 752155 754784 754877 759537 790884 793633 797801 805103 809157 814778 821745 823295 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick pussy asian"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза pussy азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза pussy азиатк"
]
|
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.