SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200113 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200113 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165311,463265,200401,8801,95831,1034356,46204,712309,622513,536375,110612,16013,813332,904263,709726,319806,999191,459939,375164,214155,392637,482962,519848,856157,526320,964338,657751,163095,571508,14851,1026181,303264,876690,866617,435571,913254,461080,407818,438858,312188,885169,458655,279115,1010804,391482,233301,809395,634741,524324,648920,113370,807367,44360,683293,566416,889333,789104,151743,419878,269384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]