SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416500 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416500 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100107,77290,835077,400836,825235,386324,226388,168851,142693,178748,605769,271667,175372,215701,325061,538796,56131,221986,535294,1036412,990444,212031,908447,1040818,840573,460719,983012,793763,671392,926248,846975,670783,854892,293861,532221,498533,439109,519749,708712,379227,335573,130135,285382,530063,807300,291449,398262,496295,83043,901407,1046016,437285,365768,863870,91661,587891,1033976,1005192,30870,443520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]