SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485743 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485743 [ RunTime:0.005580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494501,418688,503204,95957,858235,604804,276006,774827,245284,558966,495271,572689,16735,588302,607039,989235,129624,122756,995645,241579,742253,128109,390496,201405,97601,868185,240187,816862,988268,554954,957660,267417,519948,210893,366712,81982,38049,903208,697572,201461,824135,418425,800765,684381,213445,732673,513677,312456,279683,554615,961256,294795,825303,924961,466126,201650,370836,464340,631769,630628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]