Query Metrics
7
Database Queries
7
Different statements
160.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.48 ms (85.02%) |
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 398740 400497 400638 409934 415246 420625 426511 432929 439150 439601 439960 443242 445026 447040 447191 452881 455608 460900 463693 465159 468186 469691 471124 473427 475209 476471 477496 493807 495481 501342 502832 504085 509991 516320 518614 530171 530382 530784 530791 531144 531403 532345 532442 532739 532741 532847 532963 533833 533837 535358 535644 536249 536359 537654 537988 541846 541863 544028 545509 558190 563939 571039 582526 582540 590977 598920 600290 604298 608367 609154 613637 615716 617424 629007 631178 634122 636309 639742 640800 642032 642035 645276 648795 649520 649914 650175 666528 673580 673797 674959 674988 676023 676088 676097 677773 678128 678514 693269 696154 699682 716900 728072 738841 742224 746201 748504 762222 781300 784662 785877 788423 788800 798685 799937 800538 808235 812043 815559 820688 822298 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (9.06%) |
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 746201 673580 629007 518614 604298 537988 400497 455608 509991 608367 545509 532963 617424 784662 676023 571039 798685 728072 788800 463693 475209 420625 536359 530784 678128 815559 447191 439150 649520 699682 447040 582526 590977 613637 785877 400638 533833 533837 645276 582540 615716 649914 822298 808235 800538 762222 781300 788423 748504 742224 476471 666528 443242 473427 471124 426511 530382 558190 563939 738841 537654 536249 531144 501342 532847 676088 445026 820688 639742 544028 439960 432929 532345 676097 439601 530171 812043 468186 493807 469691 535358 600290 640800 516320 531403 532442 696154 673797 642035 495481 465159 460900 409934 541863 674988 693269 598920 674959 477496 398740 799937 452881 532739 530791 541846 648795 677773 678514 631178 636309 716900 642032 532741 535644 650175 634122 609154 415246 504085 502832 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.84%) |
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 398740 400497 400638 409934 415246 420625 426511 432929 439150 439601 439960 443242 445026 447040 447191 452881 455608 460900 463693 465159 468186 469691 471124 473427 475209 476471 477496 493807 495481 501342 502832 504085 509991 516320 518614 530171 530382 530784 530791 531144 531403 532345 532442 532739 532741 532847 532963 533833 533837 535358 535644 536249 536359 537654 537988 541846 541863 544028 545509 558190 563939 571039 582526 582540 590977 598920 600290 604298 608367 609154 613637 615716 617424 629007 631178 634122 636309 639742 640800 642032 642035 645276 648795 649520 649914 650175 666528 673580 673797 674959 674988 676023 676088 676097 677773 678128 678514 693269 696154 699682 716900 728072 738841 742224 746201 748504 762222 781300 784662 785877 788423 788800 798685 799937 800538 808235 812043 815559 820688 822298 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.