SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421303 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421303 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104680,718890,1038553,50925,382672,20032,898979,331749,699521,279233,764035,226215,208041,163376,475130,950653,933384,938840,892399,1021711,687476,579798,951410,77001,1632,684809,913860,771008,883380,98779,569948,121857,42260,559048,452094,878397,489320,687129,288996,463515,157873,728766,902301,696541,525969,550408,375346,39073,579547,872844,265916,397960,509151,432818,472335,20917,174074,955998,491600,252988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]