SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350201 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350201 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931872,205852,357632,950450,299398,465492,997648,986644,102905,644568,651936,561079,734257,428988,178800,308861,443325,1046728,476205,940544,422202,379342,654363,828926,146495,821494,577355,879077,673825,69683,214540,394840,58619,255754,770331,299141,952587,744433,126997,168400,754662,86885,733083,766305,585160,249285,47561,294672,868645,112397,507920,6447,1028258,540691,192031,453482,754024,731151,909223,975269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]