SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544078 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544078 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846142,422249,74457,585011,852129,340927,249686,804822,742109,482188,600721,954530,143486,1018146,374802,548811,578767,10124,232139,688325,843226,568301,981117,568654,217915,965490,480995,538886,21811,512316,188421,580397,833155,503910,123227,624016,563179,38146,197497,593875,732387,444164,854113,750657,48140,244778,1029045,640256,661612,597577,429366,973370,811330,173536,992363,74407,502336,581498,357681,8316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]