SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10438 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10438 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25772,574230,402593,210800,999745,958517,458828,260084,452312,780871,376542,32319,349366,489263,789052,537320,590913,288218,1037402,211851,120826,601188,1021592,517893,919306,156409,965043,575878,308929,363109,886005,68599,846809,429549,135124,1002632,491021,4468,681393,516141,422833,340206,654596,305816,216100,232866,706775,648452,258870,508417,127178,456452,401777,349790,364658,1025282,594734,895183,713564,749874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]