Query Metrics
7
Database Queries
7
Different statements
185.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.24 ms (85.39%) |
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 386456 403588 414135 417493 417660 417839 418572 418574 432699 432707 434829 436235 438067 443987 444194 452251 452659 453875 457818 460388 464193 464196 464857 466739 469756 476887 478238 478707 487605 492239 492601 492794 496119 496813 498345 500758 501230 501682 504509 504692 507627 507876 508796 509058 510404 510769 511791 519319 519322 519349 519610 520632 521637 521785 522383 522506 522975 523430 525190 525349 525612 526118 526492 526908 526912 528445 528652 532644 539286 541776 542094 545038 550587 552991 555024 555127 566047 566122 567053 567062 567756 568283 569431 584511 591394 592382 594830 596497 597282 598644 599950 603911 614673 618534 622035 627139 628273 633047 643517 659216 661510 699409 714468 744704 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (9.17%) |
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 464196 492794 492601 501230 504509 496119 507627 522506 528652 414135 457818 519349 504692 542094 567062 545038 555024 592382 622035 417839 460388 509058 519610 519322 492239 552991 453875 643517 599950 443987 522383 598644 418574 526908 528445 744704 418572 508796 525612 478238 519319 466739 498345 507876 432707 478707 523430 417660 417493 476887 452659 501682 526492 541776 569431 555127 699409 525190 487605 496813 618534 714468 444194 432699 614673 566047 436235 510769 550587 438067 464193 511791 464857 568283 469756 434829 386456 525349 596497 661510 526118 521637 500758 584511 403588 633047 566122 539286 567756 452251 510404 522975 521785 591394 603911 526912 520632 567053 627139 628273 597282 659216 594830 532644 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.51%) |
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 386456 403588 414135 417493 417660 417839 418572 418574 432699 432707 434829 436235 438067 443987 444194 452251 452659 453875 457818 460388 464193 464196 464857 466739 469756 476887 478238 478707 487605 492239 492601 492794 496119 496813 498345 500758 501230 501682 504509 504692 507627 507876 508796 509058 510404 510769 511791 519319 519322 519349 519610 520632 521637 521785 522383 522506 522975 523430 525190 525349 525612 526118 526492 526908 526912 528445 528652 532644 539286 541776 542094 545038 550587 552991 555024 555127 566047 566122 567053 567062 567756 568283 569431 584511 591394 592382 594830 596497 597282 598644 599950 603911 614673 618534 622035 627139 628273 633047 643517 659216 661510 699409 714468 744704 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex on camera"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс camera"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс camera"
]
|
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.