SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41418 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41418 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990738,516931,589188,869050,875387,227396,547968,914805,519272,442764,763150,213903,679327,243068,481,1044614,499543,569563,85433,780164,1008029,698715,99841,780763,913098,456120,766810,74730,397312,665534,102935,717177,963841,352182,217159,660210,990225,714237,593758,654155,898949,692028,440120,622058,555622,553384,542602,358785,177541,802399,95512,540059,352443,340404,114821,849747,160685,103329,845851,780045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]