Query Metrics
7
Database Queries
7
Different statements
213.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.25 ms (82.12%) |
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 123949 382539 385446 385919 394707 395533 395584 395951 396099 397072 399909 400368 400582 400587 403918 404095 404117 404422 405420 410203 410435 413262 420367 420700 425915 428689 429271 429588 430948 444755 449368 449442 449517 450509 452417 452920 454361 454622 456290 456302 456866 457859 458090 459012 459668 462782 462967 464101 466704 467321 470143 472087 472732 473954 474389 475106 477678 481073 481490 482579 482914 484732 485184 485635 487449 491192 491551 492225 492266 494305 499469 499484 501772 502791 506215 508066 508262 512321 513203 517905 520069 522555 522836 523282 524058 527071 527795 535336 538213 540601 543436 548760 552208 552212 552229 552661 553093 555800 562126 569979 570205 570436 570514 571908 572116 572442 576280 578110 590390 594215 600018 604466 617869 630758 663088 777818 778653 803335 806045 810964 ] |
||||||||||||||||||||||||||||||
|
18.37 ms (8.61%) |
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 462967 523282 508262 385919 395533 395584 396099 404422 428689 459012 458090 494305 472732 572442 578110 552208 552212 552229 552661 570205 571908 555800 569979 572116 594215 600018 630758 778653 400368 466704 470143 473954 394707 403918 404095 462782 382539 400582 405420 425915 429271 475106 456866 508066 522555 527795 512321 513203 482914 485635 485184 487449 492266 506215 524058 538213 385446 482579 449368 452920 477678 472087 481490 481073 570514 576280 562126 553093 604466 590390 444755 459668 464101 429588 454622 420700 399909 410203 420367 430948 456302 467321 501772 502791 517905 520069 484732 492225 499469 491551 499484 527071 491192 522836 535336 540601 413262 410435 397072 400587 449517 457859 456290 449442 452417 543436 548760 570436 663088 803335 777818 806045 810964 617869 454361 123949 395951 404117 450509 474389 ] |
||||||||||||||||||||||||||||||
|
10.65 ms (4.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.67%) |
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 123949 382539 385446 385919 394707 395533 395584 395951 396099 397072 399909 400368 400582 400587 403918 404095 404117 404422 405420 410203 410435 413262 420367 420700 425915 428689 429271 429588 430948 444755 449368 449442 449517 450509 452417 452920 454361 454622 456290 456302 456866 457859 458090 459012 459668 462782 462967 464101 466704 467321 470143 472087 472732 473954 474389 475106 477678 481073 481490 482579 482914 484732 485184 485635 487449 491192 491551 492225 492266 494305 499469 499484 501772 502791 506215 508066 508262 512321 513203 517905 520069 522555 522836 523282 524058 527071 527795 535336 538213 540601 543436 548760 552208 552212 552229 552661 553093 555800 562126 569979 570205 570436 570514 571908 572116 572442 576280 578110 590390 594215 600018 604466 617869 630758 663088 777818 778653 803335 806045 810964 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин красивая"
]
|
||||||||||||||||||||||||||||||
|
1.75 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.