Query Metrics
7
Database Queries
7
Different statements
211.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.85 ms (85.69%) |
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 32999 160233 187847 188437 384030 385356 386140 389440 389474 389973 394329 400818 400826 400847 401117 401216 403319 404582 406083 406563 407018 407721 407782 411394 411468 413110 415635 418746 418972 419127 420131 420227 422261 424417 425892 428817 434215 434254 435542 441131 442084 443695 445791 445937 446945 450759 453629 453889 454226 454237 462271 464601 465927 465958 466109 466890 470114 470147 471410 477993 479034 480832 481933 481967 482392 484175 484532 485357 486571 488454 489794 491612 491993 493138 496322 498363 502755 504152 506891 518854 519580 520693 522602 525158 531995 550219 555083 557993 563060 563081 563194 569941 590607 609823 609825 620041 625221 633529 659383 664972 666434 678857 689055 701247 702299 707487 714938 720522 727039 730934 742930 751498 757114 759635 788275 795033 795041 801775 807546 810389 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (8.45%) |
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 385356 406083 465958 386140 446945 807546 394329 466890 425892 445791 484175 531995 701247 795033 810389 187847 525158 434215 689055 590607 659383 788275 407782 563081 707487 730934 727039 563194 428817 400847 443695 633529 795041 479034 419127 471410 757114 415635 188437 401117 434254 751498 491612 160233 418972 422261 470114 569941 389474 454237 491993 424417 702299 620041 557993 32999 481967 489794 450759 522602 496322 435542 519580 482392 470147 609825 442084 466109 411468 403319 666434 720522 389973 488454 464601 462271 801775 563060 477993 411394 407018 384030 506891 498363 504152 400818 609823 480832 502755 420227 400826 404582 550219 555083 520693 485357 714938 481933 486571 406563 407721 453889 445937 484532 493138 664972 625221 742930 413110 420131 418746 441131 678857 759635 453629 389440 454226 401216 518854 465927 ] |
||||||||||||||||||||||||||||||
|
4.09 ms (1.94%) |
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 32999 160233 187847 188437 384030 385356 386140 389440 389474 389973 394329 400818 400826 400847 401117 401216 403319 404582 406083 406563 407018 407721 407782 411394 411468 413110 415635 418746 418972 419127 420131 420227 422261 424417 425892 428817 434215 434254 435542 441131 442084 443695 445791 445937 446945 450759 453629 453889 454226 454237 462271 464601 465927 465958 466109 466890 470114 470147 471410 477993 479034 480832 481933 481967 482392 484175 484532 485357 486571 488454 489794 491612 491993 493138 496322 498363 502755 504152 506891 518854 519580 520693 522602 525158 531995 550219 555083 557993 563060 563081 563194 569941 590607 609823 609825 620041 625221 633529 659383 664972 666434 678857 689055 701247 702299 707487 714938 720522 727039 730934 742930 751498 757114 759635 788275 795033 795041 801775 807546 810389 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy and mother"
]
|
||||||||||||||||||||||||||||||
|
2.25 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.80%) |
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.