SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409046 LIMIT 1 [ RunTime:0.000919s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409046 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009166,403253,757212,614100,629015,704931,198130,859136,953281,236258,1044353,555795,252690,31030,442942,552020,702489,480128,993476,298115,171967,533458,296798,702408,1033805,713208,418603,394664,597632,18081,4764,749574,245858,726791,89005,426133,354177,989172,481304,805713,587342,305089,685450,105189,286199,414803,208250,301636,455270,1006020,640091,469741,872008,1004595,835455,875361,885761,778154,1032928,493257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]