SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003620 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003620 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983012,1026073,653759,428493,312662,727004,276335,592480,544735,256983,312987,1020266,878157,785454,210662,620701,1014483,682465,372146,932821,940899,15775,632998,510622,524805,58309,1019225,134657,931125,710619,342115,230983,450830,533066,232362,498735,524445,94339,334395,40490,19986,830844,204114,1033224,986383,177187,285445,776612,74303,773061,413510,186874,133558,129723,146157,1041847,316799,726395,312845,781432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]