SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398424 LIMIT 1 [ RunTime:0.001409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398424 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488138,334827,552067,851266,147062,97083,948775,198572,445695,154405,1013599,91169,882613,176835,607762,577301,682025,359092,906904,918983,381926,849356,976599,886476,656283,323590,701491,638852,255714,150281,964186,698023,990508,791208,851762,590210,345369,59913,255947,39499,780772,160044,668590,1039547,811675,70830,855441,292455,31823,190995,817389,856691,332375,971160,258639,890363,629312,172664,904826,506705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]