SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104672 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104672 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571670,88080,200809,998214,372141,91929,669383,747743,657968,289910,688640,722775,254631,468510,53470,934252,90870,647664,100109,499471,852820,1037366,871389,851106,1033994,698254,614317,159789,628348,627410,205894,476263,387175,784572,706520,601068,981574,796222,429458,701589,69663,91800,37897,952060,232182,864891,562917,406158,334701,296864,826493,798091,669726,168417,503257,432223,699877,884474,299156,6268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]