Query Metrics
7
Database Queries
7
Different statements
172.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.32 ms (87.15%) |
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 383419 390413 400490 401025 411697 414157 414581 415205 415223 416252 417456 419579 420398 421974 422500 422582 422603 422617 422705 422834 422908 422970 423010 423018 423037 423040 423266 423271 423283 423400 423412 423821 423825 423829 424658 426789 429256 434624 436358 442691 443247 445933 446260 446266 459395 461056 462504 464043 464281 470344 471505 473168 473797 473798 473848 474008 474916 475072 475303 476898 477034 477966 478459 479060 479679 479684 481792 481817 485899 489003 492396 493231 495647 496080 497950 499365 499374 499378 500125 509024 509403 510420 510938 511058 511502 512934 515142 520159 520174 520176 523423 523540 523825 524015 528884 531594 534771 541725 543460 543821 544477 544493 549314 554805 555847 555850 555873 558983 559897 565556 569129 579517 600599 605094 615636 626405 644674 663503 668747 693078 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (7.80%) |
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 417456 429256 473797 479679 476898 481817 475303 479060 481792 492396 511502 531594 510938 515142 509403 520159 534771 528884 464281 471505 479684 569129 543821 579517 668747 693078 549314 555847 555873 559897 615636 605094 423271 411697 415205 400490 422970 473168 524015 489003 499378 383419 422834 422908 423283 445933 446260 464043 477034 459395 509024 520176 523540 493231 541725 544477 543460 663503 555850 558983 565556 600599 626405 644674 416252 473848 423412 473798 390413 423821 423825 424658 420398 423266 500125 510420 499374 511058 499365 512934 401025 414581 422617 423010 423037 436358 415223 422603 422500 434624 414157 423018 443247 422582 442691 462504 446266 520174 523423 544493 423400 477966 421974 422705 423829 426789 470344 474916 523825 419579 423040 461056 474008 485899 475072 478459 497950 495647 496080 554805 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.40%) |
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 383419 390413 400490 401025 411697 414157 414581 415205 415223 416252 417456 419579 420398 421974 422500 422582 422603 422617 422705 422834 422908 422970 423010 423018 423037 423040 423266 423271 423283 423400 423412 423821 423825 423829 424658 426789 429256 434624 436358 442691 443247 445933 446260 446266 459395 461056 462504 464043 464281 470344 471505 473168 473797 473798 473848 474008 474916 475072 475303 476898 477034 477966 478459 479060 479679 479684 481792 481817 485899 489003 492396 493231 495647 496080 497950 499365 499374 499378 500125 509024 509403 510420 510938 511058 511502 512934 515142 520159 520174 520176 523423 523540 523825 524015 528884 531594 534771 541725 543460 543821 544477 544493 549314 554805 555847 555850 555873 558983 559897 565556 569129 579517 600599 605094 615636 626405 644674 663503 668747 693078 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny ugly"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые ugly"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые ugly"
]
|
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.