SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355343 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355343 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014247,516294,988581,894924,289119,678952,931571,783017,70532,16548,913589,1006783,288106,1001502,459946,832330,585779,1037880,69831,595964,975392,13786,227745,557084,923894,129361,736013,636637,556141,264986,335246,1039736,882336,253087,948597,2606,154487,978584,72378,487038,1006316,448258,509763,662070,818546,89434,546365,331369,586774,843306,995309,693323,454766,57353,971434,303838,1028913,713281,405191,171592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]