Query Metrics
7
Database Queries
7
Different statements
232.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.85 ms (87.70%) |
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 416128 422351 422426 427137 434201 434455 435356 438898 442218 444262 446122 446336 446929 451521 452429 453694 454041 454354 454528 455171 457372 457853 458601 460600 462478 462479 462651 463242 464563 464663 464955 465288 469832 469833 473836 481399 481465 483506 483513 484751 486007 486013 488224 489298 489301 489725 492958 492965 494600 498808 501589 503858 505842 506023 506552 507221 507427 508766 509292 511315 512875 515056 515849 517392 517599 519826 522449 524284 524327 524419 524543 526723 528052 529833 543181 546115 546116 546914 547790 549174 550517 555885 560435 560487 563551 564575 565535 577132 578803 581953 585966 589431 590984 591155 591929 592580 607023 607717 615984 616472 617346 620473 625093 626015 666869 675492 687544 697196 713177 728255 729181 737274 737922 773977 785153 786486 794162 794259 797802 ] |
||||||||||||||||||||||||||||||
|
18.67 ms (8.03%) |
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 728255 462651 464563 481399 452429 464663 486007 498808 463242 560487 697196 729181 737274 797802 515849 494600 506552 422426 465288 528052 522449 524287 507427 486013 550517 549174 563551 565535 794162 620473 444262 489725 492965 687544 590984 453694 501589 526723 529833 713177 615984 785153 794259 458601 473836 524419 560435 546115 666869 625093 454528 457372 581953 546116 675492 564575 589431 454041 484751 416128 464955 519826 511315 546914 737922 435356 469833 517392 446929 492958 773977 786486 481465 454354 483513 607023 457853 578803 451521 434455 446336 506023 503858 462479 591929 626015 517599 434201 488224 524543 508766 524327 555885 617346 592580 460600 512875 585966 422351 509292 438898 442218 469832 515056 462478 577132 446122 455171 489301 505842 547790 607717 591155 616472 427137 524284 483506 543181 489298 507221 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.29%) |
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 416128 422351 422426 427137 434201 434455 435356 438898 442218 444262 446122 446336 446929 451521 452429 453694 454041 454354 454528 455171 457372 457853 458601 460600 462478 462479 462651 463242 464563 464663 464955 465288 469832 469833 473836 481399 481465 483506 483513 484751 486007 486013 488224 489298 489301 489725 492958 492965 494600 498808 501589 503858 505842 506023 506552 507221 507427 508766 509292 511315 512875 515056 515849 517392 517599 519826 522449 524284 524327 524419 524543 526723 528052 529833 543181 546115 546116 546914 547790 549174 550517 555885 560435 560487 563551 564575 565535 577132 578803 581953 585966 589431 590984 591155 591929 592580 607023 607717 615984 616472 617346 620473 625093 626015 666869 675492 687544 697196 713177 728255 729181 737274 737922 773977 785153 786486 794162 794259 797802 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pregnant fuck"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беремен секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.67%) |
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.