Query Metrics
7
Database Queries
7
Different statements
419.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.30 ms (51.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple young секс"
]
|
||||||||||||||||||||||||||||||
|
181.91 ms (43.37%) |
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 371202 390931 391156 404483 405946 407522 408424 409184 413053 414646 415834 418883 422089 425337 426694 426917 427490 428609 429946 430853 438872 444230 448532 453418 453422 453424 453644 455876 458544 459530 460451 460917 461993 464565 467668 470211 470525 470756 473139 473310 474903 479050 482225 482609 483331 483346 484670 485499 488709 489226 490339 490365 491071 495844 499709 500795 502865 504195 504228 504252 504261 504805 507366 510484 510491 510528 510671 512162 513255 514805 518329 521443 521988 522549 522560 524070 525118 528727 531523 534173 534950 537274 546766 547874 547913 548785 550024 550629 552183 552282 552738 553147 558689 559009 559030 559033 566473 569608 571680 584480 592782 594602 598121 663492 663956 665108 665116 665379 679657 682545 685681 688041 694715 704557 707688 724328 748224 761088 802723 822692 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (3.70%) |
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 426694 422089 460917 461993 510671 507366 510484 513255 404483 665116 665108 482609 552282 594602 663492 688041 484670 428609 534950 491071 550024 552738 413053 453424 473310 453418 694715 566473 458544 522549 559009 444230 552183 464565 460451 500795 724328 408424 490365 665379 504805 546766 663956 592782 391156 685681 548785 448532 514805 482225 390931 470756 490339 525118 427490 470525 704557 371202 453644 499709 518329 483331 504261 521988 504195 550629 438872 459530 537274 483346 547913 679657 426917 474903 485499 495844 559030 707688 510491 453422 467668 489226 682545 473139 430853 559033 504252 409184 407522 802723 405946 504228 521443 558689 822692 553147 531523 748224 415834 425337 547874 479050 512162 522560 528727 761088 488709 584480 598121 418883 429946 455876 470211 569608 414646 502865 510528 524070 534173 571680 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (0.63%) |
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 371202 390931 391156 404483 405946 407522 408424 409184 413053 414646 415834 418883 422089 425337 426694 426917 427490 428609 429946 430853 438872 444230 448532 453418 453422 453424 453644 455876 458544 459530 460451 460917 461993 464565 467668 470211 470525 470756 473139 473310 474903 479050 482225 482609 483331 483346 484670 485499 488709 489226 490339 490365 491071 495844 499709 500795 502865 504195 504228 504252 504261 504805 507366 510484 510491 510528 510671 512162 513255 514805 518329 521443 521988 522549 522560 524070 525118 528727 531523 534173 534950 537274 546766 547874 547913 548785 550024 550629 552183 552282 552738 553147 558689 559009 559030 559033 566473 569608 571680 584480 592782 594602 598121 663492 663956 665108 665116 665379 679657 682545 685681 688041 694715 704557 707688 724328 748224 761088 802723 822692 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple young sex"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple young секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.37%) |
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.