Query Metrics
7
Database Queries
7
Different statements
146.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.40 ms (80.63%) |
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 45357 142253 383541 384038 385697 386761 387915 389098 401233 402386 406083 407266 411871 412772 413007 414736 415221 418840 420178 421672 421866 425925 428432 428855 429741 430546 432366 432644 433769 433866 434072 438206 439709 443183 445464 446766 446926 451758 452274 452774 452822 453700 454172 454551 457671 459178 459304 460190 460272 460773 462271 462347 464426 464814 464826 465545 466462 467207 468180 468359 468497 468946 469180 469420 470052 470271 470453 470468 472605 472814 472857 473325 474699 476711 478348 479123 482443 482769 483576 485364 488914 490287 491126 491766 493730 505447 508906 512079 513628 519361 520715 520908 527163 543636 544362 549370 591989 594804 628658 631982 668594 669200 675477 714443 714493 734212 769348 780115 782064 790612 791501 795953 798439 812228 815466 817952 818550 824584 824877 825825 ] |
||||||||||||||||||||||||||||||
|
17.39 ms (11.84%) |
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 432366 469180 479123 386761 412772 434072 472814 513628 488914 505447 472857 470052 428432 460773 485364 519361 438206 491766 402386 407266 452774 454172 508906 464814 464826 470453 493730 482769 473325 468359 465545 468497 470271 421866 453700 454551 439709 520908 459304 824877 668594 591989 795953 812228 798439 384038 429741 432644 420178 383541 433866 413007 446766 472605 446926 457671 483576 476711 45357 459178 462347 142253 466462 818550 817952 825825 478348 544362 549370 543636 675477 594804 631982 628658 782064 790612 780115 734212 769348 414736 425925 527163 430546 460190 389098 385697 387915 406083 421672 445464 452274 468946 474699 451758 462271 415221 468180 428855 520715 401233 433769 443183 411871 418840 815466 824584 482443 469420 470468 452822 460272 464426 467207 491126 512079 490287 669200 714493 714443 791501 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.96%) |
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 45357 142253 383541 384038 385697 386761 387915 389098 401233 402386 406083 407266 411871 412772 413007 414736 415221 418840 420178 421672 421866 425925 428432 428855 429741 430546 432366 432644 433769 433866 434072 438206 439709 443183 445464 446766 446926 451758 452274 452774 452822 453700 454172 454551 457671 459178 459304 460190 460272 460773 462271 462347 464426 464814 464826 465545 466462 467207 468180 468359 468497 468946 469180 469420 470052 470271 470453 470468 472605 472814 472857 473325 474699 476711 478348 479123 482443 482769 483576 485364 488914 490287 491126 491766 493730 505447 508906 512079 513628 519361 520715 520908 527163 543636 544362 549370 591989 594804 628658 631982 668594 669200 675477 714443 714493 734212 769348 780115 782064 790612 791501 795953 798439 812228 815466 817952 818550 824584 824877 825825 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother naked"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин голые"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.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.