Query Metrics
7
Database Queries
7
Different statements
148.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.29 ms (83.91%) |
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 391306 418575 426483 426869 428798 429815 437759 437816 437982 441169 442571 443711 445993 448218 451502 452312 453685 455809 456022 459313 460458 468803 472307 472940 488458 489389 489772 494281 502721 503633 505953 509887 513017 517277 519511 524346 524369 536434 537640 559623 560859 562732 564228 565014 568126 569641 579209 583222 588879 590974 591039 592735 593741 599668 601300 605471 606403 607517 608070 609833 610114 614419 616603 617146 618771 619873 620041 642571 646721 656808 659197 659401 669507 678732 689002 689970 709298 709503 710571 711320 717116 717493 719443 722332 729567 731239 741588 743479 744924 746021 747682 750579 751354 753748 756289 758564 775013 780620 784210 787176 787713 791578 792604 795363 798701 801570 804527 805276 807227 807295 807321 807460 808300 812652 813150 ] |
||||||||||||||||||||||||||||||
|
13.57 ms (9.16%) |
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 472307 428798 426483 488458 583222 731239 418575 517277 503633 442571 437816 441169 429815 456022 459313 468803 448218 455809 489772 502721 524346 505953 524369 537640 519511 494281 489389 560859 559623 565014 646721 656808 659197 659401 669507 719443 662145 678732 689970 722332 564228 568126 569641 590974 599668 606403 642571 607517 610114 618771 588879 591039 605471 617146 619873 620041 592735 608070 614419 784210 787176 787713 804527 807295 807460 775013 795363 801570 729567 807227 807321 808300 813150 747682 743479 746021 753748 758564 751259 736904 741588 744924 750579 751354 756289 769530 709298 709503 710571 711320 717116 780620 792604 798701 812652 437759 453685 443711 437982 452312 445993 451502 460458 472940 509887 513017 536434 391306 426869 562732 579209 716936 717493 689002 593741 609833 616603 601300 791578 805276 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (2.08%) |
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 391306 418575 426483 426869 428798 429815 437759 437816 437982 441169 442571 443711 445993 448218 451502 452312 453685 455809 456022 459313 460458 468803 472307 472940 488458 489389 489772 494281 502721 503633 505953 509887 513017 517277 519511 524346 524369 536434 537640 559623 560859 562732 564228 565014 568126 569641 579209 583222 588879 590974 591039 592735 593741 599668 601300 605471 606403 607517 608070 609833 610114 614419 616603 617146 618771 619873 620041 642571 646721 656808 659197 659401 669507 678732 689002 689970 709298 709503 710571 711320 717116 717493 719443 722332 729567 731239 741588 743479 744924 746021 747682 750579 751354 753748 756289 758564 775013 780620 784210 787176 787713 791578 792604 795363 798701 801570 804527 805276 807227 807295 807321 807460 808300 812652 813150 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен caught"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен caught"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife caught"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.10%) |
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.