Query Metrics
7
Database Queries
7
Different statements
165.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.94 ms (80.90%) |
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 20180 147735 213273 416297 418400 421325 421462 424984 425333 425773 426623 427351 428280 428417 429627 430675 437875 442992 443485 444974 445378 453901 453973 456911 461088 464838 465042 467051 469085 469569 471387 475604 475894 481078 483127 483558 484899 486152 486858 487057 488330 491299 491717 493209 494196 494411 495030 496087 496088 497372 497749 500453 504553 508710 510676 511723 513074 513885 518915 518977 519213 519690 521980 524277 524283 525776 526477 526478 527515 528952 528958 528963 529005 529032 529060 529065 529079 532567 534800 541482 542578 542587 544206 544352 545526 548536 558574 564218 564632 565447 565562 567375 568460 568714 569061 569163 569231 571784 574467 579365 586593 586599 586654 590203 590920 601054 602653 617267 620597 627803 634791 646336 671817 674082 691990 705528 761573 772600 790209 805039 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (11.11%) |
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 504553 497749 541482 590203 475894 467051 519690 518977 421462 456911 425333 510676 147735 213273 427351 444974 524283 524277 534800 525776 565447 601054 790209 453973 481078 521980 443485 471387 568460 569163 569061 437875 518915 493209 496087 486152 465042 483127 526478 497372 469085 526477 544206 627803 421325 544352 571784 602653 519213 428280 634791 453901 430675 500453 528963 491299 487057 558574 565562 567375 568714 617267 494196 513885 486858 772600 545526 542587 646336 805039 494411 442992 418400 513074 529032 691990 671817 761573 445378 464838 483558 491717 532567 579365 542578 586599 529079 488330 429627 529065 529005 564218 564632 590920 620597 461088 20180 475604 426623 484899 511723 495030 586593 586654 425773 469569 496088 416297 424984 428417 528952 529060 508710 527515 528958 569231 574467 674082 548536 705528 ] |
||||||||||||||||||||||||||||||
|
5.03 ms (3.04%) |
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 20180 147735 213273 416297 418400 421325 421462 424984 425333 425773 426623 427351 428280 428417 429627 430675 437875 442992 443485 444974 445378 453901 453973 456911 461088 464838 465042 467051 469085 469569 471387 475604 475894 481078 483127 483558 484899 486152 486858 487057 488330 491299 491717 493209 494196 494411 495030 496087 496088 497372 497749 500453 504553 508710 510676 511723 513074 513885 518915 518977 519213 519690 521980 524277 524283 525776 526477 526478 527515 528952 528958 528963 529005 529032 529060 529065 529079 532567 534800 541482 542578 542587 544206 544352 545526 548536 558574 564218 564632 565447 565562 567375 568460 568714 569061 569163 569231 571784 574467 579365 586593 586599 586654 590203 590920 601054 602653 617267 620597 627803 634791 646336 671817 674082 691990 705528 761573 772600 790209 805039 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl compilation"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
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.