Query Metrics
7
Database Queries
7
Different statements
144.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.29 ms (82.32%) |
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 197591 383073 385697 388900 391184 391344 392605 398284 398843 403109 405650 406230 407532 407605 407876 409088 411917 413842 415207 415307 415935 416063 417042 419101 419819 421132 421696 421853 423769 427432 428132 430351 433556 433614 435114 439792 440534 440598 440877 440889 442619 446794 448532 450259 450297 451022 453013 453137 453540 453750 454190 455051 456602 456787 457465 457644 458420 460001 460183 461637 461827 463858 464248 464554 464884 465143 466834 467851 467896 468462 468857 470034 470501 471589 472263 474317 474634 474894 476243 476666 477185 477485 478376 482239 484331 484669 484776 485226 490183 490813 491105 492121 492417 493221 493222 500424 501001 508740 509320 512687 514596 517652 521485 523764 526941 529250 547746 547758 547777 549367 563513 564716 580221 582396 596948 617116 756273 781780 811259 814885 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (10.90%) |
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 457465 439792 440598 463858 470034 509320 529250 471589 477185 467896 470501 474634 523764 385697 197591 388900 398843 407532 416063 428132 440877 433556 435114 440889 415935 442619 453750 464248 474894 453137 458420 491105 456602 456787 457644 460001 485226 547777 547758 464884 476243 407605 433614 446794 460183 461827 391344 421132 464554 409088 419819 430351 440534 448532 468462 421853 465143 477485 521485 514596 411917 383073 564716 617116 500424 484669 450259 468857 454190 492417 455051 461637 474317 582396 596948 811259 756273 398284 478376 423769 406230 407876 419101 427432 476666 526941 508740 484776 490813 493222 415207 493221 492121 563513 517652 484331 391184 403109 415307 421696 814885 451022 472263 450297 453013 482239 501001 512687 466834 490183 549367 580221 547746 781780 392605 453540 467851 405650 413842 417042 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.70%) |
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 197591 383073 385697 388900 391184 391344 392605 398284 398843 403109 405650 406230 407532 407605 407876 409088 411917 413842 415207 415307 415935 416063 417042 419101 419819 421132 421696 421853 423769 427432 428132 430351 433556 433614 435114 439792 440534 440598 440877 440889 442619 446794 448532 450259 450297 451022 453013 453137 453540 453750 454190 455051 456602 456787 457465 457644 458420 460001 460183 461637 461827 463858 464248 464554 464884 465143 466834 467851 467896 468462 468857 470034 470501 471589 472263 474317 474634 474894 476243 476666 477185 477485 478376 482239 484331 484669 484776 485226 490183 490813 491105 492121 492417 493221 493222 500424 501001 508740 509320 512687 514596 517652 521485 523764 526941 529250 547746 547758 547777 549367 563513 564716 580221 582396 596948 617116 756273 781780 811259 814885 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шикарные зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сочные зрелые"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"шикарные зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
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.