back

prva novost

2012-01-16 18:42:54

When working on web portals, if the project is large FIGURE 2enough to justify the expense, there are designers involved. I work with a team of designers on most of my projects. Typically, designers do not think in terms of what is possible with the software used to build the solution.

read more

Page 1 of 1, showing 1 records out of 1 total, starting on record 1, ending on 1

<< previous | | next >>
 
(default) 10 queries took 18 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `contents`12122
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SHOW FULL COLUMNS FROM `content_types`222
4SHOW FULL COLUMNS FROM `i18n`664
5SHOW FULL COLUMNS FROM `blocks`772
6SHOW FULL COLUMNS FROM `content_blocks`222
7SELECT COUNT(DISTINCT(`Content`.`id`)) AS count FROM `contents` AS `Content` INNER JOIN `i18n` AS `I18nModel` ON (`Content`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'Content' AND `I18nModel`.`locale` = 'eng') LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) WHERE `content_type_id` = 5 AND `published` = 1 111
8SELECT DISTINCT `Content`.`id`, `Content`.`published`, `Content`.`order`, `Content`.`created`, `I18n__title`.`content`, `I18n__body`.`content`, `I18n__navigate_url`.`content` FROM `contents` AS `Content` INNER JOIN `i18n` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Content' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__body` ON (`Content`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Content' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__navigate_url` ON (`Content`.`id` = `I18n__navigate_url`.`foreign_key` AND `I18n__navigate_url`.`model` = 'Content' AND `I18n__navigate_url`.`field` = 'navigate_url' AND `I18n__navigate_url`.`locale` = 'eng') LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) WHERE `content_type_id` = 5 AND `published` = 1 LIMIT 20113
9SELECT `Content`.`id`, `I18n__title`.`content`, `I18n__navigate_url`.`content`, `I18n__menu_text`.`content` FROM `contents` AS `Content` INNER JOIN `i18n` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Content' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__navigate_url` ON (`Content`.`id` = `I18n__navigate_url`.`foreign_key` AND `I18n__navigate_url`.`model` = 'Content' AND `I18n__navigate_url`.`field` = 'navigate_url' AND `I18n__navigate_url`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__menu_text` ON (`Content`.`id` = `I18n__menu_text`.`foreign_key` AND `I18n__menu_text`.`model` = 'Content' AND `I18n__menu_text`.`field` = 'menu_text' AND `I18n__menu_text`.`locale` = 'eng') LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) WHERE `Content`.`published` = 1 AND `Content`.`in_menu` = 1 ORDER BY `Content`.`order` ASC 550
10SELECT Block.id, Block.name, Block.published, Block.order, Block.conten_location, I18n__title.content, I18n__body.content, Content.id, content_blocks.content_id, content_blocks.block_id FROM blocks AS Block Left Join content_blocks On ( content_blocks.block_id = Block.id) Left Join contents AS Content ON(content_blocks.content_id = Content.id) INNER JOIN i18n AS I18n__title ON (Block.id = I18n__title.foreign_key AND I18n__title.model = 'Block' AND I18n__title.field = 'title' AND I18n__title.locale = 'eng') INNER JOIN i18n AS I18n__body ON (Block.id = I18n__body.foreign_key AND I18n__body.model = 'Block' AND I18n__body.field = 'body' AND I18n__body.locale = 'eng') WHERE Content.id=3 ORDER BY Block.order 001