SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009713 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009713 [ RunTime:0.002753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333894,703272,831897,993820,943766,364297,290195,885795,311987,525488,485490,144295,422596,372098,724231,974919,415627,888859,369156,982826,740248,78160,124099,1006202,544889,208838,181576,426277,842109,532787,725151,320291,1007497,45302,170559,297410,675423,688024,75440,26238,452046,85045,16869,213831,135089,116105,984423,153814,582691,245302,56388,224476,909756,186327,20157,225017,770816,976084,950268,334602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]