Query Metrics
7
Database Queries
7
Different statements
195.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.53 ms (87.05%) |
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 7981 389440 400237 400602 401114 407656 408306 408774 412362 414014 414126 415004 419475 421043 430486 440620 446501 451932 454788 457446 460135 471945 475752 481584 482679 486594 487344 487517 487708 492523 492534 498030 499636 502767 506009 507512 508474 511895 514097 519497 520253 521723 524262 531415 531545 531996 533014 534823 534961 535485 536724 544596 549507 550064 550672 557534 559952 559953 566321 566606 566825 574298 575656 577402 581620 583238 587854 587907 589647 602259 603249 603431 604386 614097 620160 622335 628641 629363 631199 634475 637060 640710 640721 642742 647328 647901 650806 664212 674056 682107 714973 720291 724656 790878 792558 792610 792612 797447 798683 802826 806430 807363 808579 808600 809414 809479 810899 810976 813101 814392 814892 814901 815232 815250 815374 815545 816249 816569 817857 820973 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (7.94%) |
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 816249 815545 820973 460135 536724 524262 534961 475752 566321 566825 575656 549507 550672 664212 642742 589647 603249 620160 587907 628641 634475 631199 798683 806430 808600 810899 797447 802826 809414 809479 629363 714973 720291 790878 813101 7981 400602 430486 492523 650806 535485 724656 498030 507512 519497 814901 492534 487344 414014 408774 814392 816569 815232 815374 482679 487517 531996 502767 506009 514097 531415 559952 566606 577402 583238 550064 682107 647901 674056 647328 544596 559953 574298 604386 614097 637060 587854 602259 622335 792610 792612 603431 792558 389440 401114 400237 412362 414126 415004 446501 471945 421043 451932 499636 487708 511895 457446 407656 521723 533014 486594 815250 817857 408306 440620 814892 454788 508474 520253 531545 534823 481584 557534 581620 640721 807363 808579 810976 640710 419475 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.42%) |
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 7981 389440 400237 400602 401114 407656 408306 408774 412362 414014 414126 415004 419475 421043 430486 440620 446501 451932 454788 457446 460135 471945 475752 481584 482679 486594 487344 487517 487708 492523 492534 498030 499636 502767 506009 507512 508474 511895 514097 519497 520253 521723 524262 531415 531545 531996 533014 534823 534961 535485 536724 544596 549507 550064 550672 557534 559952 559953 566321 566606 566825 574298 575656 577402 581620 583238 587854 587907 589647 602259 603249 603431 604386 614097 620160 622335 628641 629363 631199 634475 637060 640710 640721 642742 647328 647901 650806 664212 674056 682107 714973 720291 724656 790878 792558 792610 792612 797447 798683 802826 806430 807363 808579 808600 809414 809479 810899 810976 813101 814392 814892 814901 815232 815250 815374 815545 816249 816569 817857 820973 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская mature mom"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina mature mom"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская mature mom"
]
|
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.