SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264991 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264991 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564130,354063,210204,313440,441721,91823,719792,347166,3861,329745,836047,617646,140138,666484,769001,786062,936889,194173,755674,575404,805582,86670,615108,682669,537060,269615,717273,956784,1047160,304769,136874,396031,606645,379657,206851,559860,223911,126649,25526,211015,665134,516310,167073,932094,709482,508976,812983,675818,794588,805549,509835,303456,775073,636716,322130,92479,687170,274585,854441,700069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000368s ]