SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504395 LIMIT 1 [ RunTime:0.001066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504395 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83978,98146,64099,651544,348194,592603,686487,695881,190704,371984,33744,788690,634948,628510,1002259,379835,469953,102432,446031,449073,813006,632787,65638,869066,466169,566775,127803,621881,723551,561126,64561,951447,822879,748044,37175,860144,514163,716507,940307,235254,840060,217650,786476,957581,807603,965001,780902,34280,52507,369317,661506,905093,1020082,442898,592979,414381,374886,462357,988014,508455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002422s ]