SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109798 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109798 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3790,575569,193491,734229,961991,339498,780807,622135,98696,254270,432451,609851,510199,1040637,334080,205464,143529,38530,775407,428480,999444,582483,223672,1010696,449126,297637,722554,545898,696374,639692,368302,750534,910483,551678,812930,7869,793062,873431,635132,801616,206158,385978,396446,547076,693403,227850,391300,360124,627150,795809,10076,254854,1039256,132993,707443,270989,539663,388981,685257,709231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]