SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40001 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40001 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211414,349052,644179,244190,348345,140869,231053,24069,512890,648545,18462,374402,661809,843185,245265,286681,546017,411054,317463,245364,634186,560670,397830,528050,194894,961573,272734,820065,134500,104336,733077,761782,1024659,218985,265282,1040258,675150,380632,254266,1045387,489148,165248,297340,407085,436603,240788,601500,810096,946375,710571,1007910,442221,355463,450162,20374,931763,814790,481807,430350,263392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]