SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534311 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534311 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734508,528003,267611,889030,551077,975379,231293,316197,253634,632916,466909,29225,544836,508314,522368,466827,443316,158858,828478,1028358,1001386,849486,638878,148206,771632,887567,959092,168800,4345,898608,795978,770548,251131,605039,812100,144846,301150,1016102,349748,771890,577441,959123,764825,989191,477388,429361,662974,807276,65601,465240,497525,614905,934701,640977,367231,182514,285092,287403,135398,1022734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]