SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974417 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974417 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373204,407185,275267,96043,121941,27204,572847,981047,939848,651441,49046,82599,427477,75352,677400,281607,608389,51088,248012,837013,841723,279607,1022409,973895,1006963,5582,534894,322250,574432,423549,759931,860043,670738,420334,836577,846129,708954,109594,985739,899084,56146,1006742,561645,440230,835757,572365,252785,244400,686387,448414,652525,14559,396939,773148,930032,270668,435565,932358,511861,367236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]