SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003759s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501546 LIMIT 1 [ RunTime:0.002528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501546 [ RunTime:0.006883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528637,436376,266290,125303,855450,197761,193178,540807,194024,826381,659501,494227,713391,532910,460217,256847,575929,362030,941793,666812,548191,919189,153216,973061,322160,985835,405726,594591,904649,191419,585755,842241,79976,929365,1017082,990401,588529,381111,742265,925927,426620,649031,760046,788484,268484,919008,176216,168652,381455,259772,707305,232249,293656,478440,652033,498817,875994,944414,703340,870512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]