SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498570 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498570 [ RunTime:0.002896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788930,168227,17955,131212,211914,470540,404210,850723,578185,904943,374121,631901,174739,451814,234355,542562,974126,769153,730467,668208,897015,944291,211079,975640,498285,524670,596040,15141,139336,683677,415379,405947,291599,580678,836315,519264,28983,60579,578349,805836,992801,907924,507486,154349,944000,598960,285608,288558,1023535,374404,161819,710441,948127,100615,890371,286147,36049,958156,1021541,571394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]