SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583819 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583819 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359607,689189,30436,676052,403802,81206,46887,286100,225389,592690,29212,39140,1040357,89656,581392,769828,186247,76551,347554,838874,533418,322792,266543,997539,705750,853306,430439,333083,937283,1009813,237634,594306,34051,437905,637834,729059,818115,3052,275905,964155,529533,1002262,859391,808263,769376,285547,3179,564955,224624,908481,538113,157433,107836,837049,420050,551899,58796,507471,343833,127141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]