SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400332 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400332 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131982,528494,796104,409215,901137,496650,900956,716882,674326,397878,875655,911961,760642,521445,962730,474460,937895,549974,559284,290942,994437,223002,149226,597540,648907,658835,575025,526829,65894,416344,513962,970547,600846,388521,535536,60528,439459,907584,855823,545328,986455,447079,946843,566951,348865,293844,919674,868955,1042054,992978,289633,402708,59460,372760,413432,116486,33840,793753,836340,844705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]