SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407209 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407209 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515377,195907,741981,962466,159230,182788,1022811,568411,73282,596848,346251,122385,186285,355198,688630,883901,422714,573754,1022641,1013394,731535,439459,34520,839424,970078,930386,764035,528889,314208,757379,265608,235749,502691,569752,642492,146652,472568,612247,542928,194133,766301,935043,140670,972921,622732,463561,921068,537807,187433,242878,221522,60331,300949,668389,257626,483858,480263,510282,578929,297344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]