SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971540 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971540 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126587,780074,344107,991513,774163,799213,646986,597140,905126,159473,769100,462378,108784,570569,164344,692138,835932,700129,217278,52304,441114,512917,214644,983010,237753,943606,533227,974966,447221,819599,637435,527356,601461,305227,816519,206252,99969,92318,622046,105105,532918,545843,704815,941252,733277,267835,377389,189939,980698,903931,239994,287064,414305,954194,1043923,868816,502698,333107,853783,539207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]