SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504011 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504011 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732976,433436,217077,505308,13248,233956,554160,328337,728287,864174,57474,821659,409244,237498,82194,431932,871234,385676,896357,145105,369950,288312,599187,770545,850658,97970,112827,129198,198893,709349,59310,924680,707030,286231,15131,52748,949449,293286,361134,675661,394160,665339,658701,174261,635187,914265,655354,64075,297470,124296,73266,1017922,267865,881398,1005616,250156,460633,811680,955605,509606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]