SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804479 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804479 [ RunTime:0.003462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164428,406137,251726,470908,150230,930027,836705,121695,571117,1006252,708740,186481,770175,562781,505727,1007859,705715,976764,873322,517979,285052,263812,969276,564620,355530,964409,708122,1000122,861759,808862,208936,330452,920527,760740,694317,192185,450247,618238,173289,442931,471078,819755,489962,183007,86998,438337,820190,618882,847553,169662,76233,127750,765282,423704,760364,712279,451188,1022938,440050,24382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]