SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364728 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364728 [ RunTime:0.003118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936161,127488,76593,79558,943957,916988,380744,431578,164861,204037,877741,173005,878486,874526,36095,388394,21101,241090,383086,351787,353033,996317,71573,647766,289055,876427,726960,199988,67955,372954,269776,150433,153030,618730,872678,829197,998294,978064,912041,701112,844133,295993,233790,851597,653281,639945,641944,478995,423008,661672,574193,212544,1032687,6557,270605,317198,702059,286447,576008,749947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]