SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423481 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423481 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300043,1022214,764399,654484,56848,676386,362862,137402,975987,973893,439571,420979,942165,894697,252561,614668,652580,329412,396272,885898,330981,566073,925993,924050,645841,330500,365065,202573,968912,551786,490815,544038,121191,467710,190373,823767,550137,236447,958594,219340,332161,636401,507586,248579,495815,750630,562426,116867,801404,718596,740678,772999,66128,520636,230216,932203,569420,78626,143892,784012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001236s ]