SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411101 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411101 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183519,363185,977133,875134,935772,183587,961369,502333,423192,847890,17878,694211,94468,653399,387108,351102,85214,1005376,34194,172859,436663,820015,328020,991874,614052,700000,1010681,979401,352171,127284,291030,913050,411400,232676,198712,741017,23953,586812,580853,1008867,678346,520417,306108,599005,812316,558430,480692,921007,489207,984287,518429,748678,769026,2164,10050,648164,151164,229375,793330,521014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001025s ]