SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145214 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145214 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998983,65014,714118,610229,920189,613277,380933,192966,82524,721029,310891,416383,223734,251552,723845,951973,187525,233045,675371,919721,155863,586207,289933,739454,1014243,316074,493910,736155,356016,597896,575853,129244,318348,635415,686210,14575,32059,968415,755048,458267,421457,182227,142340,339892,529208,40335,347578,662532,532893,1015821,197708,820230,7515,718592,119158,120792,516584,932944,513936,567305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001578s ]