SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918678 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918678 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006925,844509,280025,907074,100425,759659,642041,897041,739224,826347,983583,487086,910177,838869,976629,1048868,922659,380295,909009,840417,377734,649784,458760,1017010,358744,934392,941480,390806,845649,1020785,614456,718897,844955,710908,183829,245741,467873,543696,296410,491151,640006,306671,937895,809839,666632,672719,55402,88508,524025,567923,97740,918176,546221,190906,261411,842593,657196,759240,763957,221775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]