SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284454 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284454 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209115,951842,63505,762205,618315,170600,52727,988139,713252,235107,554391,984796,466351,144104,64453,968163,151894,655803,962064,782059,534902,303726,859623,930801,946377,637166,857627,854107,98566,489885,280247,433068,966091,224260,901291,594919,788247,288976,1001120,773793,60060,368579,104930,681117,73615,66686,524860,438409,531024,660214,482145,601662,726308,622845,418581,730124,251354,29549,788900,422191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]