SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522678 LIMIT 1 [ RunTime:0.001171s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522678 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220401,143316,258626,289802,931956,556892,132731,912461,501836,219901,105073,966038,398861,124763,629712,57754,63189,385439,310095,199046,746486,826130,237919,199770,75538,1020035,981856,493754,219721,821960,748582,533610,320783,722669,932343,444611,1037797,646345,1016847,940320,548835,884378,427255,348482,179304,530006,125106,679908,279123,727682,218715,824829,545371,1018585,694278,715175,688547,485307,939093,503419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]