SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311448 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311448 [ RunTime:0.006021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474910,910149,485284,898568,889349,978735,853116,94027,160982,85631,992643,565342,295767,771570,845982,345409,611593,698854,617335,900404,708953,65665,192165,389734,602714,816064,275069,466705,467512,972642,133345,660851,322672,974160,427895,852405,357162,603300,1025188,832682,730784,251477,370893,843957,527876,157165,244766,544731,240668,791926,949902,641622,379289,359460,744822,787484,448311,773176,710774,561243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]