SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331027 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331027 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036681,957551,672549,165157,462645,978922,595178,865452,561656,33171,133579,1010207,419873,982341,375846,743234,119761,7651,358331,489257,654453,218441,800686,108277,33812,251862,861466,760870,129882,641807,931552,649775,1046466,75011,378010,665012,434073,171997,275501,268168,464194,914863,89294,871531,913851,628113,927868,840466,665454,718809,849071,940919,791745,337008,534914,455693,452126,535319,839038,461889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]