SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4908 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4908 [ RunTime:0.004176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457857,88915,39993,217188,468674,18281,855568,644663,504842,967534,58988,527254,310782,897211,476485,767270,1000155,798669,375783,646699,879065,304294,20626,450184,466265,826134,202284,48445,778743,596070,396170,773267,633669,32471,429360,443609,508675,953929,710652,758300,1001531,329017,789764,854705,521561,544152,533927,282165,991546,583357,747428,746800,118478,695835,99316,212008,270707,14787,397052,774593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]