Query Metrics
7
Database Queries
7
Different statements
376.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.05 ms (56.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite teens"
]
|
||||||||||||||||||||||||||||||
|
140.54 ms (37.30%) |
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 33236 80663 101894 120415 383523 392421 393442 396184 396449 396572 396581 399096 402013 402147 403216 404343 405508 409484 410402 412952 413732 418540 420050 420062 420621 420624 421468 421482 425714 427252 428741 429040 429384 429754 436847 438857 439049 439281 439870 441048 442851 443506 448844 453619 456262 456319 459043 459229 461083 462369 463315 463341 472752 485907 498479 499013 505319 516206 517780 517793 519793 602069 630381 632563 635064 698045 698282 727852 728353 730872 730886 731933 732033 735446 736628 738770 740689 742854 743103 743142 745445 745915 747466 747573 747655 747938 747955 750196 750471 751676 752599 755001 755331 757142 758986 761108 761580 762718 763352 767315 769209 777659 789843 797720 797814 799394 802596 802898 803097 810191 814137 817913 819597 820420 820766 821038 822301 823500 825693 ] |
||||||||||||||||||||||||||||||
|
16.69 ms (4.43%) |
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 743103 743142 747466 752599 758986 769209 800948 802596 810191 727852 730872 730886 731933 736628 740689 742854 747955 750196 761580 763352 728353 745445 747655 750471 755001 755331 732033 735446 745915 747938 751676 762718 767315 738770 747573 757142 761108 602069 630381 635064 698045 698282 777659 789843 797720 797814 799394 802898 803097 80663 396449 396572 421482 439281 448844 463341 412952 421468 459043 33236 405508 420050 420062 428741 439049 459229 463315 436847 443506 462369 453619 456262 456319 461083 472752 485907 499013 516206 517780 498479 505319 517793 519793 632563 383523 120415 101894 393442 392421 396184 396581 399096 402147 402013 403216 404343 409484 410402 413732 418540 429040 420624 427252 420621 429754 441048 425714 429384 438857 439870 442851 820420 822301 823500 819597 814137 817913 825693 820766 821038 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (0.72%) |
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 33236 80663 101894 120415 383523 392421 393442 396184 396449 396572 396581 399096 402013 402147 403216 404343 405508 409484 410402 412952 413732 418540 420050 420062 420621 420624 421468 421482 425714 427252 428741 429040 429384 429754 436847 438857 439049 439281 439870 441048 442851 443506 448844 453619 456262 456319 459043 459229 461083 462369 463315 463341 472752 485907 498479 499013 505319 516206 517780 517793 519793 602069 630381 632563 635064 698045 698282 727852 728353 730872 730886 731933 732033 735446 736628 738770 740689 742854 743103 743142 745445 745915 747466 747573 747655 747938 747955 750196 750471 751676 752599 755001 755331 757142 758986 761108 761580 762718 763352 767315 769209 777659 789843 797720 797814 799394 802596 802898 803097 810191 814137 817913 819597 820420 820766 821038 822301 823500 825693 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite teens"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite teens"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.