SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98109 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98109 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491729,210639,143249,323235,171019,681221,512342,302565,587628,170486,843431,183040,185493,919356,620109,190928,996773,92812,712973,375988,121518,140834,350090,942203,934294,177384,839784,945722,642404,920566,748748,206787,11099,556506,108721,294407,339082,1044807,377755,221407,595244,142558,951526,299811,135688,846656,920112,375213,722497,600438,215374,197884,165131,711797,921710,679354,187604,8431,539768,210634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]