SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450441 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450441 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212995,278308,150144,14713,632177,815728,1025941,920578,872807,942086,395758,1000928,803165,328320,769706,351601,315887,966166,1032842,712393,17033,398981,965804,62843,505518,469249,251259,806652,675904,210089,50788,722350,575468,449246,243341,432665,203910,791165,598772,656655,345237,243533,676658,341834,61151,470398,323179,156495,540850,875572,144605,135074,773700,439111,238823,909532,846424,471734,290770,368042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]