SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511938 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511938 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78982,1014638,611870,230800,155276,280657,594198,578132,397689,483256,307227,712642,410211,409951,311987,19708,281952,295195,450435,717636,814536,1035954,521342,1024778,848704,131730,565443,937205,124622,207968,855182,541870,964670,110981,405721,113060,47915,937093,254706,583091,822048,509895,217519,308827,715197,282893,312138,839293,611595,185668,596909,481057,180428,195613,199491,351739,101237,1025946,111179,635975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]