Query Metrics
7
Database Queries
7
Different statements
163.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.30 ms (83.16%) |
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 400491 400808 415809 421780 422161 422243 424276 425347 426994 428017 433310 439518 439534 439544 439550 439558 439564 439565 439571 439578 439616 439623 439633 439671 439677 439699 439704 439726 439767 440999 442869 443722 443747 444707 445664 453721 453740 454141 455957 456058 457194 462322 462655 464200 473248 473483 474786 474788 474799 476628 479059 479114 483356 489330 493521 495229 508701 512369 512516 512556 514301 518267 518841 518852 518938 518959 518965 519589 519837 521763 521796 523901 523907 526181 535335 537122 537126 547612 548264 554400 582269 585321 586314 599703 600651 601851 608350 613319 614906 618359 619778 621724 623378 628696 659197 661991 687437 708582 719977 720313 726882 731063 731204 743429 787762 794951 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (9.88%) |
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 439704 474786 473483 456058 586314 731204 445664 424276 479059 439699 439616 440999 444707 708582 719977 661991 720313 743429 473248 479114 453740 794951 443722 518267 508701 519837 493521 439677 422161 455957 548264 731063 659197 554400 787762 526181 621724 613319 523901 400808 415809 421780 495229 608350 443747 521796 483356 400491 512556 464200 619778 462655 518938 439623 457194 628696 474788 439565 439726 428017 439550 439571 454141 518841 426994 442869 433310 439518 439558 439671 476628 439633 523907 521763 687437 600651 585321 726882 512516 518965 535335 439578 439767 425347 518959 439534 489330 512369 514301 462322 519589 537126 537122 422243 474799 547612 439544 453721 518852 614906 439564 599703 601851 618359 623378 582269 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.15%) |
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 400491 400808 415809 421780 422161 422243 424276 425347 426994 428017 433310 439518 439534 439544 439550 439558 439564 439565 439571 439578 439616 439623 439633 439671 439677 439699 439704 439726 439767 440999 442869 443722 443747 444707 445664 453721 453740 454141 455957 456058 457194 462322 462655 464200 473248 473483 474786 474788 474799 476628 479059 479114 483356 489330 493521 495229 508701 512369 512516 512556 514301 518267 518841 518852 518938 518959 518965 519589 519837 521763 521796 523901 523907 526181 535335 537122 537126 547612 548264 554400 582269 585321 586314 599703 600651 601851 608350 613319 614906 618359 619778 621724 623378 628696 659197 661991 687437 708582 719977 720313 726882 731063 731204 743429 787762 794951 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son webcam"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son вебкамер"
]
|
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.