SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402434 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402434 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502044,374520,1044622,409170,502079,600192,814556,378670,466443,512168,54883,888483,241382,76601,167911,602687,764017,87535,814138,561523,814185,765228,707878,781466,305128,738325,972219,688115,471800,113365,949914,50864,543032,52529,654780,289711,409711,868605,360278,14259,951649,185610,574444,188476,997105,130908,864057,214808,826684,676237,717664,787850,287958,353946,952332,341228,649320,648513,964704,763979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]