Query Metrics
7
Database Queries
7
Different statements
190.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.88 ms (84.04%) |
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 100685 241603 391923 391959 391986 392019 397885 398099 401126 402649 413388 414125 414271 415329 418989 420174 420774 426511 428179 429799 429859 430353 432299 436937 439393 439532 440775 441157 441160 443242 443255 445945 448082 448464 451337 454000 463840 465143 467882 467893 468220 469120 470034 470052 471124 471682 473427 473743 475649 476184 482773 482775 483762 486767 486775 486831 495737 499927 500339 501258 501263 502465 508891 510807 511254 514235 518766 519700 527409 530021 530372 530480 532779 532830 534530 534546 536285 536419 542707 547488 547767 552800 569050 572022 573197 583468 584301 590255 596684 596694 598115 598406 601668 604265 619802 626588 628113 633119 648710 648820 660364 660399 665784 665957 717859 722388 722392 726946 742738 758785 758786 760983 761608 765497 765634 796675 804765 806952 812542 824121 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (9.20%) |
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 415329 448082 465143 500339 824121 440775 665784 414271 413388 448464 486775 573197 660399 665957 626588 467882 467893 430353 414125 426511 527409 397885 398099 436937 583468 511254 486767 514235 470034 501258 598406 429799 429859 439532 590255 418989 482773 502465 547488 722392 469120 391923 536419 100685 572022 439393 471682 532830 534530 534546 530021 519700 530372 648710 660364 717859 598115 604265 628113 812542 806952 758785 726946 758786 761608 633119 722388 796675 441160 445945 508891 530480 619802 765497 765634 569050 742738 241603 392019 420774 428179 441157 420174 495737 483762 552800 596684 596694 601668 804765 401126 532779 536285 760983 547767 470052 499927 432299 443242 443255 463840 482775 473427 476184 471124 501263 473743 475649 542707 391986 402649 451337 454000 486831 518766 648820 584301 391959 510807 468220 ] |
||||||||||||||||||||||||||||||
|
5.51 ms (2.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal milf"
]
|
||||||||||||||||||||||||||||||
|
2.55 ms (1.34%) |
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 100685 241603 391923 391959 391986 392019 397885 398099 401126 402649 413388 414125 414271 415329 418989 420174 420774 426511 428179 429799 429859 430353 432299 436937 439393 439532 440775 441157 441160 443242 443255 445945 448082 448464 451337 454000 463840 465143 467882 467893 468220 469120 470034 470052 471124 471682 473427 473743 475649 476184 482773 482775 483762 486767 486775 486831 495737 499927 500339 501258 501263 502465 508891 510807 511254 514235 518766 519700 527409 530021 530372 530480 532779 532830 534530 534546 536285 536419 542707 547488 547767 552800 569050 572022 573197 583468 584301 590255 596684 596694 598115 598406 601668 604265 619802 626588 628113 633119 648710 648820 660364 660399 665784 665957 717859 722388 722392 726946 742738 758785 758786 760983 761608 765497 765634 796675 804765 806952 812542 824121 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд анал milf"
]
|
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.