Query Metrics
7
Database Queries
7
Different statements
654.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
277.04 ms (42.36%) |
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 610401 618333 610006 608759 612425 475622 390818 489995 527138 509318 546419 573176 549670 615170 616376 591501 526106 567322 609810 592953 436831 389765 594525 512542 516409 516407 541948 558790 556746 675280 555195 623841 469350 522206 526988 526566 514054 583361 624787 621849 516413 518782 528863 526826 579429 588154 477718 506950 545641 643489 524040 582871 614144 624291 580532 670226 654000 424253 486419 498405 500633 500635 510047 466671 554459 567383 565456 549517 564816 574414 575411 626546 492370 529153 595114 525483 505206 514789 549856 542223 565828 667787 605833 607830 602504 624163 479953 497118 721068 743725 602407 454216 470560 519845 512518 512993 544505 545522 576340 551574 562008 587308 610108 620093 594518 544032 596274 585124 530209 595046 504384 537010 537824 543554 610931 498973 505645 566335 519612 543795 ] |
||||||||||||||||||||||||||||||
|
206.24 ms (31.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm tits"
]
|
||||||||||||||||||||||||||||||
|
162.25 ms (24.81%) |
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 389765 390818 424253 436831 454216 466671 469350 470560 475622 477718 479953 486419 489995 492370 497118 498405 498973 500633 500635 504384 505206 505645 506950 509318 510047 512518 512542 512993 514054 514789 516407 516409 516413 518782 519612 519845 522206 524040 525483 526106 526566 526826 526988 527138 528863 529153 530209 537010 537824 541948 542223 543554 543795 544032 544505 545522 545641 546419 549517 549670 549856 551574 554459 555195 556746 558790 562008 564816 565456 565828 566335 567322 567383 573176 574414 575411 576340 579429 580532 582871 583361 585124 587308 588154 591501 592953 594518 594525 595046 595114 596274 602407 602504 605833 607830 608759 609810 610006 610108 610401 610931 612425 614144 615170 616376 618333 620093 621849 623841 624163 624291 624787 626546 643489 654000 667787 670226 675280 721068 743725 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.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 389765 390818 424253 436831 454216 466671 469350 470560 475622 477718 479953 486419 489995 492370 497118 498405 498973 500633 500635 504384 505206 505645 506950 509318 510047 512518 512542 512993 514054 514789 516407 516409 516413 518782 519612 519845 522206 524040 525483 526106 526566 526826 526988 527138 528863 529153 530209 537010 537824 541948 542223 543554 543795 544032 544505 545522 545641 546419 549517 549670 549856 551574 554459 555195 556746 558790 562008 564816 565456 565828 566335 567322 567383 573176 574414 575411 576340 579429 580532 582871 583361 585124 587308 588154 591501 592953 594518 594525 595046 595114 596274 602407 602504 605833 607830 608759 609810 610006 610108 610401 610931 612425 614144 615170 616376 618333 620093 621849 623841 624163 624291 624787 626546 643489 654000 667787 670226 675280 721068 743725 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.24%) |
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.