SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30958 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30958 [ RunTime:0.003136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706178,1032091,493161,848242,789097,534708,622980,216038,642162,496623,265841,313433,1041393,837757,196209,51889,28173,713375,614338,723885,1017358,1002562,711839,746854,162598,236738,439838,1020493,421288,1005902,788675,226900,355417,881170,985946,799274,468929,673331,836499,265643,118027,612285,1005425,981907,350863,579890,464650,988354,358617,13603,634149,424955,322012,347929,537086,725511,399107,1041591,487540,564315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]