Query Metrics
7
Database Queries
7
Different statements
147.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.00 ms (81.61%) |
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 6741 114712 382049 395547 396010 396650 396877 397335 401113 402715 407823 415223 415957 415966 416512 416596 416614 416677 416681 416694 417660 419034 420637 421394 422617 424362 427524 429427 429848 435027 435052 435131 436139 437516 439151 441616 444321 444885 445883 447481 451550 453187 456414 457163 460050 461624 462078 462821 463756 463762 463798 464129 468417 468990 471991 472147 474167 477580 478955 480024 481343 483095 484084 485998 488153 489679 491725 492092 492528 494780 494979 498560 502191 515193 518289 520992 526442 527375 531194 533611 537966 544480 549814 552074 552666 554577 557848 557976 564949 569153 569232 572783 575170 575178 576343 577369 580941 588276 592320 593639 597083 597450 625171 637751 642022 644636 663348 680149 684963 695178 720245 720387 721226 737134 745161 766141 770824 792624 804771 825812 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (11.67%) |
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 416596 416694 417660 419034 436139 444885 444321 416681 445883 462078 462821 463756 463798 484084 492092 456414 472147 478955 481343 489679 520992 537966 515193 494979 533611 460050 468417 483095 485998 569153 544480 557976 564949 569232 572783 575170 580941 554577 575178 663348 680149 684963 695178 720245 720387 721226 549814 552074 552666 557848 576343 577369 592320 593639 642022 597450 588276 597083 637751 644636 804771 792624 770824 737134 745161 766141 625171 396010 396650 397335 435131 453187 474167 382049 401113 402715 424362 437516 451550 468990 471991 439151 114712 416614 420637 427524 429427 461624 435027 435052 492528 498560 488153 494780 502191 527375 491725 395547 6741 396877 407823 415957 415966 422617 429848 415223 441616 416512 416677 421394 825812 447481 463762 457163 477580 464129 480024 526442 518289 531194 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.85%) |
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 6741 114712 382049 395547 396010 396650 396877 397335 401113 402715 407823 415223 415957 415966 416512 416596 416614 416677 416681 416694 417660 419034 420637 421394 422617 424362 427524 429427 429848 435027 435052 435131 436139 437516 439151 441616 444321 444885 445883 447481 451550 453187 456414 457163 460050 461624 462078 462821 463756 463762 463798 464129 468417 468990 471991 472147 474167 477580 478955 480024 481343 483095 484084 485998 488153 489679 491725 492092 492528 494780 494979 498560 502191 515193 518289 520992 526442 527375 531194 533611 537966 544480 549814 552074 552666 554577 557848 557976 564949 569153 569232 572783 575170 575178 576343 577369 580941 588276 592320 593639 597083 597450 625171 637751 642022 644636 663348 680149 684963 695178 720245 720387 721226 737134 745161 766141 770824 792624 804771 825812 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen glasses"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen очкастая"
]
|
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.