SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501202 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501202 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409623,732403,897005,533330,300712,1028677,564287,234278,1047426,552514,911404,670836,56448,873130,739407,296456,706085,409234,782560,514140,299545,771672,256824,335131,255386,489908,145138,927277,448608,371137,434637,525236,931148,696029,125341,635763,199057,292496,347318,632893,695174,757690,606366,629262,457954,716404,990006,1042238,1040903,231682,805540,32215,825524,211628,224592,1006222,785063,817322,1020080,728860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]