Query Metrics
7
Database Queries
7
Different statements
211.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.25 ms (90.32%) |
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 2939 25461 130089 153402 155175 190903 312831 370794 382731 383558 383590 384364 385489 385519 386804 386816 387227 387490 390049 391054 391884 392031 393435 394514 397172 397892 399164 399252 400265 400496 405806 406363 406896 407492 408380 411190 411300 413089 415548 418566 418968 418969 421065 423823 425653 425691 426414 428556 434193 438570 440867 442526 443941 444709 446741 448459 449153 451235 451713 452313 453922 454008 454290 454382 454888 454901 455298 457222 460461 460556 461338 461950 462814 463334 463509 464382 464426 465119 465426 465593 470347 471850 472805 472811 472816 472897 475282 482230 485909 489389 490406 491923 499839 501306 513532 520633 527156 536786 553433 562466 568410 569993 611305 659360 718984 744178 757539 793294 798943 801107 804073 804527 804552 804557 804829 806132 806181 808679 809372 814428 ] |
||||||||||||||||||||||||||||||
|
11.42 ms (5.39%) |
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 465593 385489 804557 411190 814428 454008 464382 499839 808679 406363 405806 482230 418969 460556 491923 386816 397172 411300 421065 418968 454382 463334 460461 489389 453922 461338 312831 527156 475282 461950 407492 562466 718984 804073 383590 440867 444709 434193 464426 568410 793294 408380 397892 472811 370794 392031 553433 659360 801107 744178 153402 385519 415548 465119 471850 472805 462814 155175 390049 454290 804829 394514 391054 406896 442526 387227 387490 130089 806132 386804 501306 465426 190903 428556 451713 399164 457222 485909 423823 520633 425653 490406 25461 413089 446741 455298 454888 472897 569993 611305 804552 809372 806181 400496 2939 383558 470347 400265 426414 513532 393435 804527 757539 384364 391884 425691 438570 443941 451235 449153 454901 452313 536786 463509 798943 448459 472816 399252 418566 382731 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.16%) |
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 2939 25461 130089 153402 155175 190903 312831 370794 382731 383558 383590 384364 385489 385519 386804 386816 387227 387490 390049 391054 391884 392031 393435 394514 397172 397892 399164 399252 400265 400496 405806 406363 406896 407492 408380 411190 411300 413089 415548 418566 418968 418969 421065 423823 425653 425691 426414 428556 434193 438570 440867 442526 443941 444709 446741 448459 449153 451235 451713 452313 453922 454008 454290 454382 454888 454901 455298 457222 460461 460556 461338 461950 462814 463334 463509 464382 464426 465119 465426 465593 470347 471850 472805 472811 472816 472897 475282 482230 485909 489389 490406 491923 499839 501306 513532 520633 527156 536786 553433 562466 568410 569993 611305 659360 718984 744178 757539 793294 798943 801107 804073 804527 804552 804557 804829 806132 806181 808679 809372 814428 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщины с большими те%…"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин большие"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.68%) |
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.