Query Metrics
7
Database Queries
7
Different statements
158.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.47 ms (82.89%) |
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 390218 397880 400181 400191 400249 407379 407566 410806 418958 421813 421821 421822 421825 421841 421845 421847 421859 421865 422168 422191 422196 422203 422204 422235 422254 426865 426994 428137 428853 429561 429586 430433 430486 434608 437314 439560 439565 439623 439633 439660 439666 439671 439678 439680 439687 439704 439763 439767 443702 443801 444044 447163 447828 448674 455206 460659 461016 461018 463215 464413 464438 468884 468941 469030 474777 474781 474786 476628 477890 485057 485172 485276 486198 489979 492121 492309 493166 502305 502812 504927 505399 512212 514301 514441 516226 516281 516484 517004 518160 518834 518852 518960 519037 519480 519931 520253 520695 521759 523356 523829 524262 524637 525152 526512 526515 531996 532012 534228 538008 539744 549739 550221 561607 563218 563432 565982 577051 600965 630475 808675 ] |
||||||||||||||||||||||||||||||
|
17.93 ms (11.30%) |
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 524262 502812 505399 518160 492309 565982 550221 549739 563432 808675 390218 428853 421821 421822 428137 460659 397880 421847 422196 444044 439660 439704 439763 443702 443801 448674 474781 474786 418958 421825 421845 422235 430433 430486 519480 514441 516281 493166 429561 519931 489979 526515 630475 400249 426994 439680 469030 422203 468941 516484 523356 519037 526512 492121 485276 518852 439623 410806 422191 439671 485057 464438 531996 532012 521759 502305 516226 520695 534228 512212 561607 577051 600965 400191 407379 421813 422168 437314 439678 447828 474777 476628 439687 400181 421841 421859 439560 439666 421865 422204 426865 439633 422254 429586 464413 468884 525152 524637 485172 514301 518834 523829 538008 455206 461018 463215 477890 517004 563218 439767 439565 486198 518960 504927 434608 407566 447163 461016 539744 520253 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom son mature"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.30%) |
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 390218 397880 400181 400191 400249 407379 407566 410806 418958 421813 421821 421822 421825 421841 421845 421847 421859 421865 422168 422191 422196 422203 422204 422235 422254 426865 426994 428137 428853 429561 429586 430433 430486 434608 437314 439560 439565 439623 439633 439660 439666 439671 439678 439680 439687 439704 439763 439767 443702 443801 444044 447163 447828 448674 455206 460659 461016 461018 463215 464413 464438 468884 468941 469030 474777 474781 474786 476628 477890 485057 485172 485276 486198 489979 492121 492309 493166 502305 502812 504927 505399 512212 514301 514441 516226 516281 516484 517004 518160 518834 518852 518960 519037 519480 519931 520253 520695 521759 523356 523829 524262 524637 525152 526512 526515 531996 532012 534228 538008 539744 549739 550221 561607 563218 563432 565982 577051 600965 630475 808675 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom son mature"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom son mature"
]
|
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.