SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035749 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035749 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117241,49296,801534,839564,986549,416882,528537,231587,247454,343523,680629,39934,341230,864092,539473,908708,672119,890325,1044081,261685,218063,186072,526316,93443,833337,553606,333511,510463,851502,569381,642863,962301,380618,243721,155889,440827,156680,466045,483387,348984,288939,130126,861563,166852,575999,96286,726809,262303,802049,927299,389417,605267,611600,746522,873838,169727,275681,499069,418143,220459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]