SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305191 LIMIT 1 [ RunTime:0.001179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305191 [ RunTime:0.006626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474668,266452,628020,272576,259537,414432,96739,898416,223994,711930,927423,376075,68623,341570,674155,48626,170021,144647,608722,571790,388143,517700,137189,335540,274390,701064,437296,212435,1005688,8356,820563,268695,114442,302744,508417,706209,975894,448491,219285,861611,893677,693823,236022,812406,174742,326039,1027232,48498,915892,272401,56674,725720,538679,440682,860196,694018,535305,97058,903223,542221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001084s ]