SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010102 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010102 [ RunTime:0.006158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547520,811313,144423,11096,22974,413304,254092,609415,51420,855053,459061,905946,572967,420553,229232,1027732,310481,423300,18395,22997,857694,820420,1014550,482664,985382,115916,935201,907477,320594,873389,735040,584327,179007,961994,51876,110537,239065,804745,551192,278122,840725,927311,858066,503795,397496,319436,608276,383893,184454,289521,647266,666296,380836,824282,120864,477669,855686,628836,145779,677540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]