Query Metrics
7
Database Queries
7
Different statements
175.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.19 ms (88.40%) |
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 12169 388007 418821 420349 420356 421561 422463 424864 429430 429479 430876 431954 433217 450939 452040 461241 464418 472644 477745 479533 481620 488557 495682 497857 498620 501533 501561 508298 514778 517839 519326 524640 528293 530259 533338 546010 550189 552992 566251 570766 570959 572313 573215 576632 580238 591157 596438 597767 609219 613885 623614 623969 626443 632137 636636 651173 652251 653234 660739 664443 665959 668625 671487 674259 677227 682999 690321 690830 690912 691497 691533 691669 693732 694555 695932 696529 701888 705680 708233 711683 714049 717962 718472 718840 720269 720398 721658 722685 723538 723952 726862 727553 727579 730306 730572 731416 732080 733346 734661 738534 741147 742974 745186 748363 748598 748963 750223 750560 754619 761733 763733 765428 767403 791585 802337 813542 814251 821458 825217 ] |
||||||||||||||||||||||||||||||
|
11.91 ms (6.79%) |
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 825217 573215 652251 665959 690321 696529 708233 693732 720269 722685 690830 690912 701888 720398 721658 626443 623969 813542 723952 734661 741147 742974 750560 761733 791585 726862 748363 754619 727553 730572 732080 745186 748963 765428 727579 738534 711683 421561 723538 814251 821458 477745 464418 533338 517839 479533 566251 546010 668625 695932 714049 718472 671487 691497 691533 691669 694555 674259 718840 613885 609219 733346 763733 748598 764183 750223 767403 632137 636636 705680 488557 420349 530259 653234 501561 514778 508298 524640 550189 664443 597767 596438 730306 731416 433217 429479 420356 450939 452040 498620 501533 570959 576632 660739 623614 802337 418821 429430 431954 422463 430876 528293 552992 580238 424864 388007 461241 481620 651173 677227 682999 717962 591157 519326 497857 472644 495682 572313 570766 12169 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.38%) |
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 12169 388007 418821 420349 420356 421561 422463 424864 429430 429479 430876 431954 433217 450939 452040 461241 464418 472644 477745 479533 481620 488557 495682 497857 498620 501533 501561 508298 514778 517839 519326 524640 528293 530259 533338 546010 550189 552992 566251 570766 570959 572313 573215 576632 580238 591157 596438 597767 609219 613885 623614 623969 626443 632137 636636 651173 652251 653234 660739 664443 665959 668625 671487 674259 677227 682999 690321 690830 690912 691497 691533 691669 693732 694555 695932 696529 701888 705680 708233 711683 714049 717962 718472 718840 720269 720398 721658 722685 723538 723952 726862 727553 727579 730306 730572 731416 732080 733346 734661 738534 741147 742974 745186 748363 748598 748963 750223 750560 754619 761733 763733 765428 767403 791585 802337 813542 814251 821458 825217 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close-up licking dick"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up лиза член"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up лиза член"
]
|
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.