SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 925013 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 925013 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989592,632080,118102,693260,535157,1013472,967498,112467,181307,528523,571333,806247,467338,511879,182560,87106,810181,44802,441632,382606,803434,618205,750799,183703,983679,914403,790622,676989,434642,164235,306892,560203,1047571,550227,501598,594172,536145,1043845,910010,735068,667701,294597,313894,588163,311416,447113,118853,585199,859692,922498,523048,184140,665223,299710,1001681,221893,278523,764617,184428,581389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 925013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 925013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]