SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 221998 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 221998 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499385,553542,19266,775681,26165,301541,217392,782123,63869,732301,590954,489664,130100,875571,270551,469041,443519,1000406,835058,727955,805423,19490,352971,591687,958177,951933,386874,43852,527705,1042254,56133,223468,979179,215900,261961,454131,626831,660035,954248,89360,874696,200470,818748,650770,629212,793855,987927,335517,441932,647259,133947,637427,660850,907425,1034713,166195,82687,846381,261860,533364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 221998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 221998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]