SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482576 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482576 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687846,422447,250725,261413,142255,933451,915734,933247,616168,11054,702914,31600,86590,717417,824045,596681,519947,675791,603739,484612,756573,574853,945197,476477,435018,858757,1014816,341320,856710,602723,251304,629219,20808,338129,208605,987539,461786,710791,1011445,139175,353278,82761,343401,350401,235529,1013597,687968,32822,863723,661473,968444,470198,573627,592332,925612,260016,154796,17464,788287,967826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]