SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019594 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019594 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595699,701510,708514,778307,54543,621664,855998,552626,172400,585084,464389,1011747,829651,510045,141990,1045464,781504,124292,828452,299443,150450,181543,123518,537440,289014,725969,946943,696352,733824,97458,411256,225758,178296,387585,21681,232313,959208,599563,482658,38252,254396,639124,209361,198021,42851,52723,120329,238129,984927,262961,916625,970956,45269,629644,330007,442756,711489,420738,810216,288134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]