Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "latina sleep"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'latina sleep' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  472974
  492134
  517275
  535046
  526307
  508168
  535043
  511777
  558720
  561468
  565737
  565788
  579899
  673522
  617322
  621354
  620071
  803293
  412362
  445542
  421043
  526390
  415710
  565743
  752956
  637404
  473145
  517137
  519179
  514106
  552322
  552305
  557196
  580913
  562886
  591599
  618718
  446811
  475033
  472693
  515135
  453438
  801033
  446864
  430190
  492572
  514653
  520628
  540657
  552319
  677108
  611241
  621352
  425802
  494779
  501027
  788878
  555181
  489026
  491584
  737228
  403240
  560205
  532129
  532039
  428166
  446041
  467395
  491219
  521461
  453716
  531920
  516308
  565782
  726526
  620085
  518768
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (472974, 492134, 517275, 535046, 526307, 508168, 535043, 511777, 558720, 561468, 565737, 565788, 579899, 673522, 617322, 621354, 620071, 803293, 412362, 445542, 421043, 526390, 415710, 565743, 752956, 637404, 473145, 517137, 519179, 514106, 552322, 552305, 557196, 580913, 562886, 591599, 618718, 446811, 475033, 472693, 515135, 453438, 801033, 446864, 430190, 492572, 514653, 520628, 540657, 552319, 677108, 611241, 621352, 425802, 494779, 501027, 788878, 555181, 489026, 491584, 737228, 403240, 560205, 532129, 532039, 428166, 446041, 467395, 491219, 521461, 453716, 531920, 516308, 565782, 726526, 620085, 518768);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  403240
  412362
  415710
  421043
  425802
  428166
  430190
  445542
  446041
  446811
  446864
  453438
  453716
  467395
  472693
  472974
  473145
  475033
  489026
  491219
  491584
  492134
  492572
  494779
  501027
  508168
  511777
  514106
  514653
  515135
  516308
  517137
  517275
  518768
  519179
  520628
  521461
  526307
  526390
  531920
  532039
  532129
  535043
  535046
  540657
  552305
  552319
  552322
  555181
  557196
  558720
  560205
  561468
  562886
  565737
  565743
  565782
  565788
  579899
  580913
  591599
  611241
  617322
  618718
  620071
  620085
  621352
  621354
  637404
  673522
  677108
  726526
  737228
  752956
  788878
  801033
  803293
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (403240, 412362, 415710, 421043, 425802, 428166, 430190, 445542, 446041, 446811, 446864, 453438, 453716, 467395, 472693, 472974, 473145, 475033, 489026, 491219, 491584, 492134, 492572, 494779, 501027, 508168, 511777, 514106, 514653, 515135, 516308, 517137, 517275, 518768, 519179, 520628, 521461, 526307, 526390, 531920, 532039, 532129, 535043, 535046, 540657, 552305, 552319, 552322, 555181, 557196, 558720, 560205, 561468, 562886, 565737, 565743, 565782, 565788, 579899, 580913, 591599, 611241, 617322, 618718, 620071, 620085, 621352, 621354, 637404, 673522, 677108, 726526, 737228, 752956, 788878, 801033, 803293);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  403240
  412362
  415710
  421043
  425802
  428166
  430190
  445542
  446041
  446811
  446864
  453438
  453716
  467395
  472693
  472974
  473145
  475033
  489026
  491219
  491584
  492134
  492572
  494779
  501027
  508168
  511777
  514106
  514653
  515135
  516308
  517137
  517275
  518768
  519179
  520628
  521461
  526307
  526390
  531920
  532039
  532129
  535043
  535046
  540657
  552305
  552319
  552322
  555181
  557196
  558720
  560205
  561468
  562886
  565737
  565743
  565782
  565788
  579899
  580913
  591599
  611241
  617322
  618718
  620071
  620085
  621352
  621354
  637404
  673522
  677108
  726526
  737228
  752956
  788878
  801033
  803293
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (403240, 412362, 415710, 421043, 425802, 428166, 430190, 445542, 446041, 446811, 446864, 453438, 453716, 467395, 472693, 472974, 473145, 475033, 489026, 491219, 491584, 492134, 492572, 494779, 501027, 508168, 511777, 514106, 514653, 515135, 516308, 517137, 517275, 518768, 519179, 520628, 521461, 526307, 526390, 531920, 532039, 532129, 535043, 535046, 540657, 552305, 552319, 552322, 555181, 557196, 558720, 560205, 561468, 562886, 565737, 565743, 565782, 565788, 579899, 580913, 591599, 611241, 617322, 618718, 620071, 620085, 621352, 621354, 637404, 673522, 677108, 726526, 737228, 752956, 788878, 801033, 803293);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "латинская спящ"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'латинская спящ';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "латинская спящ"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'латинская спящ';