SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320251 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320251 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201333,109950,271123,667920,183589,459700,684137,514533,987063,765796,515421,420346,154848,60508,337199,124110,661703,147937,791132,701618,944795,515989,1006263,189406,876506,992134,538434,476242,296108,899245,283136,829466,583167,550486,910082,216421,194060,1031305,426003,628182,271027,302212,153867,441256,804749,939391,810991,850755,577556,488718,471170,221940,934035,190198,793963,536958,544140,202325,167055,728897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]