Query Metrics
7
Database Queries
7
Different statements
143.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.84 ms (83.10%) |
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 325984 387690 388353 390670 392216 397065 398862 400021 414194 414498 426024 428574 430802 432514 447662 447999 452922 456156 461449 461968 480260 482526 495364 510547 515291 518905 520764 529061 536266 537245 542042 546057 568485 575127 575560 575740 583082 590806 595367 595478 596619 597798 598501 598754 598781 600064 611930 620901 624170 624174 632302 633870 640390 645202 647275 649571 650230 652273 654346 654460 657143 658728 659329 659432 660338 660597 662148 662181 670832 671660 672780 674980 677367 678125 694492 696107 696966 700681 709037 712583 712939 719376 720159 720223 721424 722628 722629 722649 722834 724129 725549 729937 741529 742942 746802 750316 750727 750917 752595 753340 753373 753818 753831 753898 755634 756687 761115 762972 769802 774650 777056 785582 796939 805654 805668 805961 806334 814228 819677 821132 ] |
||||||||||||||||||||||||||||||
|
12.31 ms (8.61%) |
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 575127 575740 568485 649571 662181 600064 596619 598501 598781 624174 620901 595367 632302 796939 414194 414498 398862 426024 430802 432514 325984 397065 400021 447999 452922 480260 461968 495364 753373 392216 428574 814228 821132 515291 529061 482526 546057 583082 650230 657143 658728 670832 712583 722628 660597 662148 672780 694492 719376 720223 647275 654346 659329 660338 700681 722649 597798 595478 633870 590806 598754 624170 805961 774650 777056 785582 805654 746802 750316 752595 753818 755634 769802 805668 724129 729937 741529 762972 753898 725549 742942 750727 750917 756687 753340 761115 611930 640390 696966 720159 722834 806334 461449 387690 536266 542042 674980 678125 388353 753831 390670 819677 456156 447662 518905 520764 537245 510547 575560 652273 654460 677367 712939 722629 645202 659432 671660 696107 709037 721424 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (2.68%) |
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 325984 387690 388353 390670 392216 397065 398862 400021 414194 414498 426024 428574 430802 432514 447662 447999 452922 456156 461449 461968 480260 482526 495364 510547 515291 518905 520764 529061 536266 537245 542042 546057 568485 575127 575560 575740 583082 590806 595367 595478 596619 597798 598501 598754 598781 600064 611930 620901 624170 624174 632302 633870 640390 645202 647275 649571 650230 652273 654346 654460 657143 658728 659329 659432 660338 660597 662148 662181 670832 671660 672780 674980 677367 678125 694492 696107 696966 700681 709037 712583 712939 719376 720159 720223 721424 722628 722629 722649 722834 724129 725549 729937 741529 742942 746802 750316 750727 750917 752595 753340 753373 753818 753831 753898 755634 756687 761115 762972 769802 774650 777056 785582 796939 805654 805668 805961 806334 814228 819677 821132 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina teen"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин teen"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин teen"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.18%) |
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.