SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341059 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341059 [ RunTime:0.003765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938142,509238,975887,362706,29138,233967,437797,66824,198801,492684,802555,857206,1042352,15148,140734,968563,725930,167398,525707,986054,261417,574285,317994,14981,93509,618953,602738,95114,196504,254694,929562,769072,251342,58409,640525,943057,814063,694900,771636,1160,356884,797631,235677,621246,742729,838393,924304,541710,546508,881218,492936,939019,445709,158403,467148,486213,260323,441883,214825,343289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]