SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502644 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502644 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984001,195929,655145,975722,233890,960052,31861,763341,1929,247902,969574,877171,775842,9344,181855,612981,125771,540809,975405,697079,918236,237720,193867,386947,923064,347868,124676,323264,914331,77882,646330,573034,118334,528509,138907,522804,453334,923640,255831,950676,345126,720737,950613,177529,761140,105600,1043552,282537,208433,25335,897460,13124,229351,597654,457990,394530,37416,388908,804028,362328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]