SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510093 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510093 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296578,1020591,819147,939284,1039319,242575,864199,398814,527495,432864,347821,905568,970515,67614,721210,751858,742587,911477,494715,972714,806529,249740,802629,341202,929043,612457,731028,451185,358666,176010,663028,37440,774484,426637,142013,54609,812041,100056,899929,139606,207414,977510,921676,813550,725978,231164,538904,455241,714991,289791,729905,165164,793946,1012804,213073,754349,129791,335536,217075,509359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]