SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394993 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394993 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472776,335018,552213,690014,140034,560097,1036349,840332,988299,45494,244612,325901,432660,536580,702740,310418,254695,357483,730201,528818,124840,121545,357670,966020,491201,567153,950721,908159,1009218,690372,163606,699006,162197,725920,423048,747564,480086,275366,700135,509991,790708,404161,553105,762539,317862,164667,368482,135772,751831,650881,163197,812796,855642,915328,394381,881167,415096,287401,843374,1025053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]