SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33205 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33205 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591358,441879,201149,695926,66308,101708,18496,476096,397649,201660,605627,191351,413507,768166,354127,863128,870641,809639,24410,187362,906268,180233,265059,808151,767187,43781,522900,534107,715357,256236,1034252,926617,151582,822395,761582,448849,256886,273663,113441,981213,477198,195767,826535,584032,668098,115267,228240,474052,11258,883048,382115,860817,558811,388946,648737,277818,526429,784430,113330,621000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]