SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354275 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354275 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421233,150121,767334,15859,68357,310747,1015651,198860,627721,823633,503561,893431,664851,810754,9838,92906,346511,888614,825286,85578,822139,58592,918897,312200,797809,369124,755158,36187,742924,571533,651829,844774,493792,528041,517037,168369,99933,120992,839197,824748,114594,856529,718099,668433,888357,306255,842238,682226,617715,195473,301874,449284,146680,950255,729993,814246,257268,375887,879137,198326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]