Query Metrics
7
Database Queries
7
Different statements
160.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.65 ms (81.24%) |
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 389821 425749 431521 436490 452782 454868 455179 457658 459947 460119 460392 460727 461387 463065 465276 470957 471054 473617 475866 477036 477051 477392 480613 495808 498847 499037 503941 505960 505987 506853 511717 513591 513865 516783 517020 518231 520024 521845 522669 525141 537161 549153 550478 550720 555254 557090 558220 559573 560516 561942 563612 564695 578856 579196 580651 584867 600737 603925 608036 610275 614007 614443 619344 622323 623392 624920 626067 663318 670620 672251 676664 695338 697181 700905 705020 705080 707233 714819 721580 723601 726598 728009 728277 728808 740051 740129 742871 743196 745866 747170 748337 750836 752301 758848 758895 759635 760193 764668 776703 777937 779768 780805 782346 788223 789291 796626 797440 799365 801329 802562 807284 807296 807453 807488 810037 811042 823747 824250 827233 ] |
||||||||||||||||||||||||||||||
|
21.42 ms (13.32%) |
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 670620 460119 475866 525141 498847 740051 663318 600737 477051 721580 461387 584867 776703 454868 499037 506853 495808 455179 518231 750836 752301 780805 788223 811042 389821 824250 723601 560516 550720 714819 700905 610275 777937 789291 807453 807284 807296 807488 774140 764668 564695 477392 810037 555254 705080 676664 705020 614007 622323 697181 463065 513865 457658 758895 460392 480613 431521 827233 465276 517020 740129 745866 758848 516783 563612 470957 801329 603925 623392 459947 537161 557090 580651 477036 624920 779768 799365 759635 460727 614443 471054 513591 503941 505960 521845 550478 672251 707233 802562 747170 782346 743196 436490 452782 549153 578856 608036 742871 728009 579196 626067 522669 425749 619344 823747 561942 695338 760193 726598 728808 796626 797440 728277 505987 559573 558220 748337 473617 520024 511717 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.41%) |
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 389821 425749 431521 436490 452782 454868 455179 457658 459947 460119 460392 460727 461387 463065 465276 470957 471054 473617 475866 477036 477051 477392 480613 495808 498847 499037 503941 505960 505987 506853 511717 513591 513865 516783 517020 518231 520024 521845 522669 525141 537161 549153 550478 550720 555254 557090 558220 559573 560516 561942 563612 564695 578856 579196 580651 584867 600737 603925 608036 610275 614007 614443 619344 622323 623392 624920 626067 663318 670620 672251 676664 695338 697181 700905 705020 705080 707233 714819 721580 723601 726598 728009 728277 728808 740051 740129 742871 743196 745866 747170 748337 750836 752301 758848 758895 759635 760193 764668 776703 777937 779768 780805 782346 788223 789291 796626 797440 799365 801329 802562 807284 807296 807453 807488 810037 811042 823747 824250 827233 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее спящие миньет"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск спящ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.84%) |
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.