SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32053 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32053 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520301,517672,874499,882801,448828,367709,752026,97359,277754,872201,735389,549036,960695,161506,144375,771888,1039120,606842,557875,972791,710554,523010,361260,605135,754702,166747,711429,525107,1029920,954458,561918,519953,584121,221007,64382,318046,575540,486756,717562,18971,730130,369914,536448,103442,895966,227507,967519,1014263,87884,704581,655567,617503,990722,42273,837464,957060,1039203,750372,384612,96231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]