Query Metrics
7
Database Queries
7
Different statements
263.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.02 ms (88.88%) |
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 10035 53477 76074 385790 396626 405151 411182 411813 412474 415511 415871 417720 417735 417737 426386 427555 427967 428996 436304 445804 451755 454960 456098 457291 457671 458929 459864 460479 462915 464212 465158 466602 466603 466611 466612 468498 468688 468778 473009 474604 474657 483708 484449 484457 484461 484789 486509 486883 495367 498456 503220 510205 511898 513280 513773 513989 514747 522004 523923 526896 527753 530128 533747 533783 540483 545153 550403 553090 557180 564306 566057 566903 571212 575711 577334 579370 582766 590413 598672 603004 605301 605323 608386 621421 622025 634543 639305 645810 655296 664105 670412 671392 689582 690761 693295 705365 705465 712520 713083 718283 719897 721455 721457 726833 730094 730570 730655 735995 741885 745411 757950 767301 773533 774154 784961 793753 795488 800558 809174 819677 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (6.70%) |
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 458929 468688 10035 460479 412474 553090 705365 571212 484461 466602 459864 510205 486883 465158 511898 605301 634543 527753 473009 503220 495367 693295 721455 466603 417737 670412 639305 757950 730655 741885 767301 385790 622025 415511 533783 566903 689582 466611 426386 726833 513773 540483 427555 474604 486509 603004 411813 466612 474657 445804 484449 514747 718283 745411 705465 730094 719897 468778 411182 513989 523923 564306 545153 526896 513280 484457 793753 773533 621421 713083 690761 712520 645810 721457 582766 735995 795488 774154 730570 427967 457291 605323 456098 590413 498456 557180 530128 655296 664105 608386 809174 800558 464212 457671 598672 53477 396626 405151 417720 415871 819677 522004 484789 671392 550403 577334 784961 76074 454960 468498 428996 483708 533747 417735 462915 436304 451755 575711 579370 566057 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (1.55%) |
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 10035 53477 76074 385790 396626 405151 411182 411813 412474 415511 415871 417720 417735 417737 426386 427555 427967 428996 436304 445804 451755 454960 456098 457291 457671 458929 459864 460479 462915 464212 465158 466602 466603 466611 466612 468498 468688 468778 473009 474604 474657 483708 484449 484457 484461 484789 486509 486883 495367 498456 503220 510205 511898 513280 513773 513989 514747 522004 523923 526896 527753 530128 533747 533783 540483 545153 550403 553090 557180 564306 566057 566903 571212 575711 577334 579370 582766 590413 598672 603004 605301 605323 608386 621421 622025 634543 639305 645810 655296 664105 670412 671392 689582 690761 693295 705365 705465 712520 713083 718283 719897 721455 721457 726833 730094 730570 730655 735995 741885 745411 757950 767301 773533 774154 784961 793753 795488 800558 809174 819677 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob casting"
]
|
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.