Query Metrics
7
Database Queries
7
Different statements
187.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.69 ms (86.44%) |
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 114672 145922 186993 229460 382805 383440 385448 387374 388819 389511 389973 395703 395710 396910 396997 401802 403279 405855 407878 412642 413233 415594 416926 419292 421249 423462 424423 426840 428920 432889 438410 443183 443456 443709 443824 445930 449096 456731 458987 460938 462799 465114 465209 470995 471536 472720 474038 474096 475020 475590 476146 476161 476712 477116 477959 485457 486805 487347 488628 488993 490645 492412 496056 499847 502102 505384 510662 512800 515883 519262 521230 523031 542502 543012 543819 546921 547431 549228 555314 555377 559057 559864 573931 581273 581351 584974 671721 687972 703909 713146 719141 724750 726641 729038 729814 730556 730839 734399 735518 736539 742925 753057 765134 773522 783322 802433 804101 804359 804987 805385 807705 814431 814926 814927 815451 815559 815645 816541 816547 820388 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (8.28%) |
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 802433 804101 804359 804987 805385 807705 729038 730839 734399 724750 729814 735518 753057 765134 730556 736539 742925 726641 773522 703909 713146 783322 401802 395710 387374 403279 383440 385448 114672 186993 389511 443183 458987 470995 474038 477959 445930 465114 474096 492412 488993 543819 546921 547431 671721 584974 382805 419292 424423 476161 395703 405855 475590 426840 443824 456731 460938 471536 145922 396910 396997 415594 472720 475020 476146 443709 510662 515883 505384 523031 496056 229460 388819 389973 416926 421249 438410 407878 443456 412642 413233 423462 428920 432889 820388 814431 814927 814926 815451 815559 815645 816541 816547 465209 477116 486805 487347 490645 449096 476712 462799 488628 519262 499847 502102 512800 521230 485457 549228 555377 559864 573931 581273 542502 543012 555314 559057 581351 687972 719141 ] |
||||||||||||||||||||||||||||||
|
2.64 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 114672 145922 186993 229460 382805 383440 385448 387374 388819 389511 389973 395703 395710 396910 396997 401802 403279 405855 407878 412642 413233 415594 416926 419292 421249 423462 424423 426840 428920 432889 438410 443183 443456 443709 443824 445930 449096 456731 458987 460938 462799 465114 465209 470995 471536 472720 474038 474096 475020 475590 476146 476161 476712 477116 477959 485457 486805 487347 488628 488993 490645 492412 496056 499847 502102 505384 510662 512800 515883 519262 521230 523031 542502 543012 543819 546921 547431 549228 555314 555377 559057 559864 573931 581273 581351 584974 671721 687972 703909 713146 719141 724750 726641 729038 729814 730556 730839 734399 735518 736539 742925 753057 765134 773522 783322 802433 804101 804359 804987 805385 807705 814431 814926 814927 815451 815559 815645 816541 816547 820388 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking hairy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.58 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.