Query Metrics
7
Database Queries
7
Different statements
159.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.03 ms (85.27%) |
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 182352 205251 385471 387374 393742 395269 395710 398593 399408 399722 400938 401585 402672 403279 407288 411702 413057 415387 416355 418521 421119 424715 425780 425802 428637 429317 437450 442021 442993 445560 448795 448832 449285 451961 453039 455373 458479 461079 461106 464315 464598 466178 467138 468301 471194 478401 478887 478900 481326 491288 491478 492328 493156 497828 500706 503905 509164 510648 512419 516089 522923 522946 522978 526859 542982 543045 544259 546368 550044 550332 553876 561743 563148 568153 570024 583853 587479 590992 596232 597604 601695 611339 612206 618056 620642 633498 641090 651075 666395 677738 677977 682134 683850 684251 697307 702862 703909 705600 718985 722142 722294 730289 735394 740105 742460 743212 743258 743276 755956 759168 765134 769877 785042 800419 801855 804101 806046 811140 812171 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (8.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 467138 544259 568153 542982 550044 553876 543045 651075 677738 702862 722142 666395 682134 683850 684251 718985 722294 583853 587479 596232 597604 612206 618056 620642 806046 735394 785042 800419 801855 804101 811140 759168 771521 742460 743276 755956 765134 769877 743212 743258 730289 740105 697307 703909 705600 812171 182352 395710 387374 403279 398593 510648 491478 611339 590992 633498 641090 448832 425802 509164 503905 478401 492328 385471 205251 399408 400938 429317 413057 442021 411702 471194 478887 445560 451961 461106 464315 468301 491288 500706 550332 570024 561743 563148 677977 546368 601695 407288 418521 395269 416355 425780 437450 449285 458479 466178 401585 402672 421119 428637 442993 453039 455373 464598 399722 448795 424715 481326 493156 497828 512419 522946 522978 526859 516089 522923 393742 478900 461079 415387 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.80%) |
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 182352 205251 385471 387374 393742 395269 395710 398593 399408 399722 400938 401585 402672 403279 407288 411702 413057 415387 416355 418521 421119 424715 425780 425802 428637 429317 437450 442021 442993 445560 448795 448832 449285 451961 453039 455373 458479 461079 461106 464315 464598 466178 467138 468301 471194 478401 478887 478900 481326 491288 491478 492328 493156 497828 500706 503905 509164 510648 512419 516089 522923 522946 522978 526859 542982 543045 544259 546368 550044 550332 553876 561743 563148 568153 570024 583853 587479 590992 596232 597604 601695 611339 612206 618056 620642 633498 641090 651075 666395 677738 677977 682134 683850 684251 697307 702862 703909 705600 718985 722142 722294 730289 735394 740105 742460 743212 743258 743276 755956 759168 765134 769877 785042 800419 801855 804101 806046 811140 812171 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.82%) |
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.