Query Metrics
7
Database Queries
7
Different statements
171.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.34 ms (82.31%) |
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 191179 389608 393775 405175 412097 417485 417647 420028 420714 422824 423298 423551 423684 424254 426359 427455 432719 436591 437839 437914 437997 442611 443269 445243 445366 445733 446293 447008 447487 450657 452227 453298 453800 454737 455130 456120 456345 456940 457071 458427 458471 459364 459615 460368 461377 463409 463458 463518 463630 464058 464905 464977 466860 467065 467590 468959 471635 471754 471759 473526 475404 476598 477695 479638 479937 481792 485537 486876 486879 487516 488474 490440 490665 491796 496553 498657 498825 499612 502778 502870 509259 509620 510219 510881 513031 515497 518165 521556 523668 523845 526319 526380 527549 527555 528838 534676 539991 545667 547767 552355 552460 553247 553673 555090 557038 559564 559617 562869 564378 572245 584421 589442 591385 592446 599102 626064 630500 670107 756209 815648 ] |
||||||||||||||||||||||||||||||
|
19.95 ms (11.62%) |
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 459364 461377 464905 471759 491796 446293 454737 455130 477695 481792 539991 502870 510219 460368 466860 490665 553247 559564 559617 572245 552460 557038 589442 592446 756209 626064 389608 432719 442611 443269 456940 436591 437997 458471 467065 471754 479937 422824 423551 437914 450657 457071 447487 453800 463458 468959 420028 447008 456345 518165 521556 526319 485537 490440 502778 513031 523845 534676 498657 498825 499612 510881 523668 527555 486879 488474 509259 509620 527549 545667 191179 393775 423298 417647 417485 437839 445366 815648 456120 458427 464977 479638 445733 487516 452227 453298 464058 496553 526380 515497 528838 463518 486876 555090 562869 547767 552355 553673 584421 670107 564378 591385 599102 630500 427455 463630 473526 423684 445243 424254 426359 459615 467590 476598 405175 420714 463409 475404 412097 471635 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.84%) |
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 191179 389608 393775 405175 412097 417485 417647 420028 420714 422824 423298 423551 423684 424254 426359 427455 432719 436591 437839 437914 437997 442611 443269 445243 445366 445733 446293 447008 447487 450657 452227 453298 453800 454737 455130 456120 456345 456940 457071 458427 458471 459364 459615 460368 461377 463409 463458 463518 463630 464058 464905 464977 466860 467065 467590 468959 471635 471754 471759 473526 475404 476598 477695 479638 479937 481792 485537 486876 486879 487516 488474 490440 490665 491796 496553 498657 498825 499612 502778 502870 509259 509620 510219 510881 513031 515497 518165 521556 523668 523845 526319 526380 527549 527555 528838 534676 539991 545667 547767 552355 552460 553247 553673 555090 557038 559564 559617 562869 564378 572245 584421 589442 591385 592446 599102 626064 630500 670107 756209 815648 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde cum"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая cum"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая cum"
]
|
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.