SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546748 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546748 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148461,753193,988380,95348,706610,449259,807714,232543,27358,772283,625889,15365,189198,286200,509196,789664,802244,497318,602525,239974,113352,702360,253086,431035,500843,122622,296405,931250,951284,818991,880601,337211,669580,687201,520996,328999,46340,753315,309102,832210,211493,807618,417543,780203,202330,1016004,29219,925018,983807,286913,420417,420472,922948,38517,334415,361135,30239,490028,1032482,151730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000364s ]