SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550463 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550463 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638703,1027907,52655,118220,217124,155870,266005,888848,445464,22300,113164,310640,911527,639695,809796,872792,620287,496887,312192,847971,532713,38452,459650,1007878,36360,943311,736143,554772,202335,897008,1036503,351964,1011468,250360,978485,89714,309504,239431,576369,821941,806267,541873,210345,17944,431284,894769,680932,377394,346378,703486,46596,685387,353328,230020,492057,887219,277850,207904,977610,891267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]