Veiksmīgas uzņēmejdarbības atslēga-
Kvalitatīva mājas lapu izstrāde un uzturēšana.
Pilna servisa interneta risinājumu aģēntūra!

Zvaniet, jautājiet
(+371) 20364800

Sākums / Pakalpojumi / Datortehnika

Datortehnika

Komplektējam datortehniku gan juridiskām, gan privātpersonām.

(default) 14 queries took 11 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `services`	7	7	1
2	DESCRIBE `service_types`	4	4	1
3	DESCRIBE `i18n`	6	6	1
4	DESCRIBE `layouts`	2	2	1
5	DESCRIBE `articles`	6	6	1
6	SELECT `Service`., `ServiceType`., `Layout`.*, `I18n__name`.`content`, `I18n__description`.`content`, `Service`.`id` FROM `services` AS `Service` LEFT JOIN `i18n` AS `I18n__name` ON (`Service`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Service' AND `I18n__name`.`field` = 'name') LEFT JOIN `i18n` AS `I18n__description` ON (`Service`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Service' AND `I18n__description`.`field` = 'description') LEFT JOIN `service_types` AS `ServiceType` ON (`Service`.`service_types_id` = `ServiceType`.`id`) LEFT JOIN `layouts` AS `Layout` ON (`Service`.`layouts_id` = `Layout`.`id`) WHERE `Service`.`id` = 22 AND `I18n__name`.`locale` = 'lav' AND `I18n__description`.`locale` = 'lav' LIMIT 1	1	1	2
7	SELECT `ServiceType`.`id`, `ServiceType`.`name`, `ServiceType`.`created`, `ServiceType`.`updated` FROM `service_types` AS `ServiceType` WHERE `ServiceType`.`id` = 2	1	1	0
8	SELECT `Service`.`id`, `Service`.`service_types_id`, `Service`.`name`, `Service`.`description`, `Service`.`created`, `Service`.`updated`, `Service`.`layouts_id` FROM `services` AS `Service` WHERE `Service`.`service_types_id` = (2)	25	25	0
9	SELECT `nameTranslated`.`id`, `nameTranslated`.`locale`, `nameTranslated`.`model`, `nameTranslated`.`foreign_key`, `nameTranslated`.`field`, `nameTranslated`.`content` FROM `i18n` AS `nameTranslated` WHERE `model` = 'ServiceType' AND `field` = 'name' AND `nameTranslated`.`foreign_key` = (2)	3	3	1
10	SELECT `descriptionTranslated`.`id`, `descriptionTranslated`.`locale`, `descriptionTranslated`.`model`, `descriptionTranslated`.`foreign_key`, `descriptionTranslated`.`field`, `descriptionTranslated`.`content` FROM `i18n` AS `descriptionTranslated` WHERE `model` = 'ServiceType' AND `field` = 'description' AND `descriptionTranslated`.`foreign_key` = (2)	3	3	1
11	SELECT `Layout`.`id`, `Layout`.`name` FROM `layouts` AS `Layout` WHERE `Layout`.`id` = 1	1	1	0
12	SELECT `Article`.`id`, `Article`.`name`, `Article`.`body`, `Article`.`created`, `Article`.`updated`, `Article`.`layouts_id` FROM `articles` AS `Article` WHERE `Article`.`layouts_id` = (1)	3	3	0
13	SELECT `nameTranslated`.`id`, `nameTranslated`.`locale`, `nameTranslated`.`model`, `nameTranslated`.`foreign_key`, `nameTranslated`.`field`, `nameTranslated`.`content` FROM `i18n` AS `nameTranslated` WHERE `model` = 'Service' AND `field` = 'name' AND `nameTranslated`.`foreign_key` = (22)	3	3	1
14	SELECT `descriptionTranslated`.`id`, `descriptionTranslated`.`locale`, `descriptionTranslated`.`model`, `descriptionTranslated`.`foreign_key`, `descriptionTranslated`.`field`, `descriptionTranslated`.`content` FROM `i18n` AS `descriptionTranslated` WHERE `model` = 'Service' AND `field` = 'description' AND `descriptionTranslated`.`foreign_key` = (22)	3	3	1

(default) 14 queries took 11 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `services`

DESCRIBE `service_types`

DESCRIBE `i18n`

DESCRIBE `layouts`

DESCRIBE `articles`

SELECT `Service`.*, `ServiceType`.*, `Layout`.*, `I18n__name`.`content`, `I18n__description`.`content`, `Service`.`id` FROM `services` AS `Service` LEFT JOIN `i18n` AS `I18n__name` ON (`Service`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Service' AND `I18n__name`.`field` = 'name') LEFT JOIN `i18n` AS `I18n__description` ON (`Service`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Service' AND `I18n__description`.`field` = 'description') LEFT JOIN `service_types` AS `ServiceType` ON (`Service`.`service_types_id` = `ServiceType`.`id`) LEFT JOIN `layouts` AS `Layout` ON (`Service`.`layouts_id` = `Layout`.`id`) WHERE `Service`.`id` = 22 AND `I18n__name`.`locale` = 'lav' AND `I18n__description`.`locale` = 'lav' LIMIT 1

SELECT `ServiceType`.`id`, `ServiceType`.`name`, `ServiceType`.`created`, `ServiceType`.`updated` FROM `service_types` AS `ServiceType` WHERE `ServiceType`.`id` = 2

SELECT `Service`.`id`, `Service`.`service_types_id`, `Service`.`name`, `Service`.`description`, `Service`.`created`, `Service`.`updated`, `Service`.`layouts_id` FROM `services` AS `Service` WHERE `Service`.`service_types_id` = (2)

SELECT `nameTranslated`.`id`, `nameTranslated`.`locale`, `nameTranslated`.`model`, `nameTranslated`.`foreign_key`, `nameTranslated`.`field`, `nameTranslated`.`content` FROM `i18n` AS `nameTranslated` WHERE `model` = 'ServiceType' AND `field` = 'name' AND `nameTranslated`.`foreign_key` = (2)

SELECT `descriptionTranslated`.`id`, `descriptionTranslated`.`locale`, `descriptionTranslated`.`model`, `descriptionTranslated`.`foreign_key`, `descriptionTranslated`.`field`, `descriptionTranslated`.`content` FROM `i18n` AS `descriptionTranslated` WHERE `model` = 'ServiceType' AND `field` = 'description' AND `descriptionTranslated`.`foreign_key` = (2)

SELECT `Layout`.`id`, `Layout`.`name` FROM `layouts` AS `Layout` WHERE `Layout`.`id` = 1

SELECT `Article`.`id`, `Article`.`name`, `Article`.`body`, `Article`.`created`, `Article`.`updated`, `Article`.`layouts_id` FROM `articles` AS `Article` WHERE `Article`.`layouts_id` = (1)

SELECT `nameTranslated`.`id`, `nameTranslated`.`locale`, `nameTranslated`.`model`, `nameTranslated`.`foreign_key`, `nameTranslated`.`field`, `nameTranslated`.`content` FROM `i18n` AS `nameTranslated` WHERE `model` = 'Service' AND `field` = 'name' AND `nameTranslated`.`foreign_key` = (22)

SELECT `descriptionTranslated`.`id`, `descriptionTranslated`.`locale`, `descriptionTranslated`.`model`, `descriptionTranslated`.`foreign_key`, `descriptionTranslated`.`field`, `descriptionTranslated`.`content` FROM `i18n` AS `descriptionTranslated` WHERE `model` = 'Service' AND `field` = 'description' AND `descriptionTranslated`.`foreign_key` = (22)

M?jas lapu izstr?de

Datortehnika