SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010475 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010475 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235847,595131,798510,223057,720890,526901,143300,412699,232621,665236,702948,479906,974601,257529,269392,857457,380519,613691,508544,884802,639275,984308,652948,794338,980142,159616,482930,97318,10556,438438,124515,940510,554422,411029,560369,695541,999475,742282,792736,14257,924557,778908,50614,805983,325843,874561,736861,460713,684468,187951,1008278,711226,261551,84073,5231,705068,577888,963643,574404,708831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]