SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103253 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103253 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749321,735165,594288,767600,418740,956001,1026640,767494,339228,38862,138541,778728,36297,908099,23488,81800,452273,533965,975731,48402,893510,403928,952818,781680,995260,746207,299532,439750,799211,514233,859923,276404,201857,392062,255386,843327,363726,237482,138278,570690,299457,480391,799976,816506,1010797,351455,687022,8421,585814,411030,4576,393571,353478,379869,707115,556815,354120,520511,147583,825031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]