SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401909 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401909 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570011,591252,340797,887185,914243,734555,1043278,572821,957517,114189,979432,279665,487948,149434,659985,735807,66339,651590,919923,598185,64410,877467,726112,519656,788210,380361,696911,336459,450841,982265,555490,765954,476945,186148,822031,757363,70846,1020053,158315,526371,326737,301455,475167,71963,15681,216907,336180,935843,696184,776031,603701,287270,734478,847493,972524,654651,21579,744160,557312,126101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]