SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101447 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101447 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498897,953846,828789,673629,956611,767942,257502,724304,261559,584146,614774,914708,411438,573090,525887,640285,312594,812535,270008,871890,193414,616369,547012,251441,673031,753765,326813,751123,653302,800634,812859,59914,78169,506827,422502,873259,708083,851401,167545,254130,1035821,323669,780916,341774,871376,307913,531581,80379,131327,977303,970726,334739,60906,971768,649776,253785,631126,373158,201628,918156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]