Query Metrics
7
Database Queries
7
Different statements
233.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.25 ms (88.18%) |
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 133695 385009 387009 388791 390108 395653 401071 418793 418796 418894 421161 425374 426213 426634 429020 430396 432161 434326 435023 435883 438650 438655 445010 445014 452215 452576 456659 457992 457999 462224 463896 464677 465700 466503 468209 470225 473460 475014 476646 476656 479669 480359 483467 486738 487299 488789 488887 493553 495554 495870 498552 499369 507031 509760 510828 510914 512031 512035 512617 514905 515403 516035 516197 516401 518514 520179 521024 522639 524479 524594 525421 526164 528284 529230 530106 531818 532635 536786 537034 537147 538565 541096 556004 558610 561971 564486 576503 579381 579466 614710 619903 644510 675055 714474 726829 736178 738919 738926 742402 744050 748285 750996 751045 754991 755001 763744 769382 770226 782094 784026 787630 797060 799641 801326 803617 806696 807227 808796 814412 814467 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (6.57%) |
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 787630 799641 803617 807227 808796 738919 744050 748285 751045 736178 738926 755001 726829 742402 750996 763744 754991 769382 770226 614710 619903 644510 714474 782094 784026 797060 801326 806696 401071 464677 475014 388791 395653 421161 435883 445010 456659 418796 438650 445014 465700 468209 520179 528284 487299 495870 499369 516035 537034 510828 516401 495554 516197 521024 556004 564486 675055 524479 385009 133695 387009 390108 429020 425374 426634 432161 438655 418894 426213 435023 434326 418793 430396 525421 814412 814467 452215 457999 466503 476656 493553 452576 462224 470225 483467 486738 488789 488887 457992 473460 476646 479669 515403 532635 536786 509760 512031 514905 531818 507031 510914 526164 530106 537147 538565 498552 512035 512617 518514 522639 524594 529230 463896 480359 541096 558610 561971 576503 579381 579466 ] |
||||||||||||||||||||||||||||||
|
4.26 ms (1.82%) |
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 133695 385009 387009 388791 390108 395653 401071 418793 418796 418894 421161 425374 426213 426634 429020 430396 432161 434326 435023 435883 438650 438655 445010 445014 452215 452576 456659 457992 457999 462224 463896 464677 465700 466503 468209 470225 473460 475014 476646 476656 479669 480359 483467 486738 487299 488789 488887 493553 495554 495870 498552 499369 507031 509760 510828 510914 512031 512035 512617 514905 515403 516035 516197 516401 518514 520179 521024 522639 524479 524594 525421 526164 528284 529230 530106 531818 532635 536786 537034 537147 538565 541096 556004 558610 561971 564486 576503 579381 579466 614710 619903 644510 675055 714474 726829 736178 738919 738926 742402 744050 748285 750996 751045 754991 755001 763744 769382 770226 782094 784026 787630 797060 799641 801326 803617 806696 807227 808796 814412 814467 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло sexy"
]
|
||||||||||||||||||||||||||||||
|
2.34 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo sexy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло sexy"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.63%) |
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.